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!

Dashboards: Hiding charts while search is being executed and other uses for tokens

There are a couple of features of SimpleXML / Classic dashboards that can be used to enhance the user ...

Splunk Observability Cloud's AI Assistant in Action Series: Explaining Metrics and ...

This is the fourth post in the Splunk Observability Cloud’s AI Assistant in Action series that digs into how ...

Brains, Bytes, and Boston: Learn from the Best at .conf25

When you think of Boston, you might picture colonial charm, world-class universities, or even the crack of a ...