Use eval to display only Rain on categories

[sbnoobbb]

I had a search query of sourcetype="CurrentWeatherSGTraffic" | stats count AS values by Location current_summary | sort - values | stats list(current_summary) AS categories. How can I display only Rain in the categories. I use (eval(current_summary="Rain")) but it wont work.

[Drainy · Accepted solution]

Is someone else writing your search queries for you? I'm so confused as to how you are reaching this point? You're deliberately counting things into multivalues instead of just focusing on the single category?

Surely (trying to figure out the data from the search) you would just add a current_summary=Rain in your initial search terms with the sourcetype?

[sbnoobbb]

I gotten the search queries by the application itself, Thanks anyway 🙂