Splunk Search

How to go about stats count by a values between a range?

jenkinsta
Path Finder

I am trying to return data for a pie chart with a specified range of values. How would I go about this? 

 

| stats count(Score < 5) as "0-4.9" count(Score >=5 AND Score <=8) as "5-8"

 

Labels (1)
0 Karma

isoutamo
SplunkTrust
SplunkTrust

Hi

here is link / example how you should do it.

In your case something like

 

 | stats count(eval(Score < 5)) as "0-4.9" count(eval(if(Score >=5 AND Score <=8),1,0)) as "5-8"

 

r. Ismo 

0 Karma

jenkinsta
Path Finder

THanks got it to work without the if statement was almost there just didnt think about the eval for that. 

Get Updates on the Splunk Community!

See just what you’ve been missing | Observability tracks at Splunk University

Looking to sharpen your observability skills so you can better understand how to collect and analyze data from ...

Weezer at .conf25? Say it ain’t so!

Hello Splunkers, The countdown to .conf25 is on-and we've just turned up the volume! We're thrilled to ...

How SC4S Makes Suricata Logs Ingestion Simple

Network security monitoring has become increasingly critical for organizations of all sizes. Splunk has ...