Splunk Search

Why is multiple stats count eval not working?

onegame999
Explorer
SEARCH | stats count(eval(Status="1")) as Assigned count(eval(Status="2")) as In_progress, count(eval(Status="3")) as Pending. count(eval(Status="4")) as Resolved count(eval(Status="5")) as Closed 

I get nice table with all columns and headers but when I use column chart the first one Assigned is not on the legend and its seen as the x axis title

0 Karma

renjith_nair
Legend

@onegame999 ,

Thats because, your search does not have an x & y axis for a chart.

Try adding this to your search

your current search
| transpose column_name="Status"| rename "row 1" as count
Happy Splunking!
0 Karma
Get Updates on the Splunk Community!

Introducing the 2024 SplunkTrust!

Hello, Splunk Community! We are beyond thrilled to announce our newest group of SplunkTrust members!  The ...

Introducing the 2024 Splunk MVPs!

We are excited to announce the 2024 cohort of the Splunk MVP program. Splunk MVPs are passionate members of ...

Splunk Custom Visualizations App End of Life

The Splunk Custom Visualizations apps End of Life for SimpleXML will reach end of support on Dec 21, 2024, ...