Splunk Search

How do I adjust the command so that the columns are ordered numerically in a chart?

GrahamHay
New Member

I am generating a basic chart with the following command:

index=test | eval latency = (_indextime - _time) | chart count by latency span=10

The order of the columns in the chart seems to be lexical so I get:

0-10,10-20,100-110,110-120, ...

How do I adjust the command so that the columns are ordered numerically?

0-10,10-20,20-30,30-40, ...

NB: there are too many bins for a solution using "rename" to be practical.

Many thanks
Graham

0 Karma
1 Solution

Vijeta
Influencer

sort latency, should work

View solution in original post

0 Karma

Vijeta
Influencer

sort latency, should work

0 Karma
Get Updates on the Splunk Community!

Fun with Regular Expression - multiples of nine

Fun with Regular Expression - multiples of nineThis challenge was first posted on Slack #regex channel ...

[Live Demo] Watch SOC transformation in action with the reimagined Splunk Enterprise ...

Overwhelmed SOC? Splunk ES Has Your Back Tool sprawl, alert fatigue, and endless context switching are making ...

What’s New & Next in Splunk SOAR

Security teams today are dealing with more alerts, more tools, and more pressure than ever.  Join us on ...