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
---
What goes around comes around. If it helps, hit it with Karma 🙂
0 Karma
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

Persistent Queue at TcpOut — One of Splunk's Most Practical Features

Splunk introduced persistent queueing at the tcpout layer as one of the most practical resilience features in ...

Build resilience for the agentic era: Join us at Splunk Go San Jose

AI is changing how organizations build, operate, and secure digital services. As teams adopt AI agents and ...

Manage Edge Processor pipelines end to end with APIs

This guide uses the Data Management APIs to create an Edge Processor, onboard one instance, deploy a pipeline ...