- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
avadhutha
Explorer
01-18-2024
07:08 AM
I have a chart formed like below and it's dynamic columns are created based on processes date. By default now the column header sort is happing from lower to higher value but I am looking in a format where headers of processDates are higher to lower.
Query:
|chart latest(Count) as Count by Name ,ProcessDate
Current Output:
Name | 20240101 | 20240102 | 20240103 |
xyz | NA | NA | NA |
123 | NA | NANA | NA |
Expecting output:
Name | 20240103 | 20240102 | 20240101 |
xyz | NA | NA | NA |
123 | NA | NANA | NA |
1 Solution
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
ITWhisperer

SplunkTrust
01-18-2024
07:39 AM
| transpose 0 column_name=Date header_field=Name
| sort 0 -Date
| transpose 0 column_name=Name header_field=Date
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
ITWhisperer

SplunkTrust
01-18-2024
07:39 AM
| transpose 0 column_name=Date header_field=Name
| sort 0 -Date
| transpose 0 column_name=Name header_field=Date
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
avadhutha
Explorer
01-18-2024
08:18 AM
Thank you mate for the help, Below corrected one helped with faster results.
|chart latest(Count) as Count by ProcessDate,Name
|sort 0 - ProcessDate
| transpose 0 column_name=Name header_field=ProcDate
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
dural_yyz
Motivator
01-18-2024
07:31 AM
Try
| chart latest(Count) as Count by Name, ProcessDate
| sort ProcessDate desc
Found a very similar request under this previously answered question.
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
avadhutha
Explorer
01-18-2024
07:39 AM
No, it is not working
