topic Re: stats count by a values between a range in Splunk Search

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

jenkinsta — Thu, 15 Jun 2023 18:01:43 GMT

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"

isoutamo — Wed, 14 Jun 2023 20:56:57 GMT

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

jenkinsta — Wed, 14 Jun 2023 20:50:13 GMT

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