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!

Extending Observability Content to Splunk Cloud

Watch Now!   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to leverage ...

More Control Over Your Monitoring Costs with Archived Metrics!

What if there was a way you could keep all the metrics data you need while saving on storage costs?This is now ...

New in Observability Cloud - Explicit Bucket Histograms

Splunk introduces native support for histograms as a metric data type within Observability Cloud with Explicit ...