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
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!

Community Content Calendar, September edition

Welcome to another insightful post from our Community Content Calendar! We're thrilled to continue bringing ...

Splunkbase Unveils New App Listing Management Public Preview

Splunkbase Unveils New App Listing Management Public PreviewWe're thrilled to announce the public preview of ...

Leveraging Automated Threat Analysis Across the Splunk Ecosystem

Are you leveraging automation to its fullest potential in your threat detection strategy?Our upcoming Security ...