Splunk Search

Reverse time info in chart

Ste
Path Finder

Dear experts

My search

index="abc" search_name="xyz" Umgebung="prod" earliest=-7d@d latest=@d zbpIdentifier IN (454-594, 256-14455, 453-12232)
| bin span=1d _time aligntime=@d
| stats count as myCount by _time, zbpIdentifier
| eval _time=strftime(_time,"%Y %m %d") 
| chart values(myCount) over zbpIdentifier by _time limit=0 useother=f

produces the following chart:

 

Ste_0-1733926591588.png

For each zbpIdentifier I have a group within the graph showing the number of messages during several days. 

How to change the order of the day values within the group? Green (yesterday) should be the most left, followed by pink (the day before yesterday) and orange, .....

| reverse

will change the order of the whole groups, that's not what I need. 

All kind of time sorting like 

| sort +"_time"
or
| sort -"_time"

before and after 

| chart ...

 does not change anything.

Labels (1)
0 Karma
1 Solution

ITWhisperer
SplunkTrust
SplunkTrust

Chart will put the columns in ascending order lexicographically. To get around this, you should use transpose, sort and transpose (back). Try something like this

| bin span=1d _time aligntime=@d
| stats count as myCount by _time, zbpIdentifier
| chart values(myCount) over zbpIdentifier by _time limit=0 useother=f
| transpose 0 column_name=date header_field=zbpIdentifier
| sort 0 -date
| eval date=strftime(date, "%Y %m %d")
| transpose 0 column_name==zbpIdentifier header_field=date

View solution in original post

ITWhisperer
SplunkTrust
SplunkTrust

Chart will put the columns in ascending order lexicographically. To get around this, you should use transpose, sort and transpose (back). Try something like this

| bin span=1d _time aligntime=@d
| stats count as myCount by _time, zbpIdentifier
| chart values(myCount) over zbpIdentifier by _time limit=0 useother=f
| transpose 0 column_name=date header_field=zbpIdentifier
| sort 0 -date
| eval date=strftime(date, "%Y %m %d")
| transpose 0 column_name==zbpIdentifier header_field=date

Ste
Path Finder

@ITWhisperer Cool, your proposal does exactly what I was looking for.
Thank you. 

0 Karma
Career Survey
First 500 qualified respondents will receive a $20 gift card! Tell us about your professional Splunk journey.

Can’t make it to .conf25? Join us online!

Get Updates on the Splunk Community!

What Is Splunk? Here’s What You Can Do with Splunk

Hey Splunk Community, we know you know Splunk. You likely leverage its unparalleled ability to ingest, index, ...

Level Up Your .conf25: Splunk Arcade Comes to Boston

With .conf25 right around the corner in Boston, there’s a lot to look forward to — inspiring keynotes, ...

Manual Instrumentation with Splunk Observability Cloud: How to Instrument Frontend ...

Although it might seem daunting, as we’ve seen in this series, manual instrumentation can be straightforward ...