Splunk Search

Create pie Chart from stats command

etherdoggy
Loves-to-Learn

I am trying to create a pie chart of success vs. failure with stats command with the following:

search | stats c(assigned_user) AS Success c(authorization_failure_user) AS Failed

Labels (1)
0 Karma

isoutamo
SplunkTrust
SplunkTrust
Hi
Are you trying to count those events or sum or what you are trying?
If count then change c -> count or dc on your stat.
r. Ismo
0 Karma

etherdoggy
Loves-to-Learn

Thanks for your response: 

I am using c count since each user may have multiple success or failure events. When I choose "Visualization", "pie", the pie renders as one metric. However, below the pie, I can see the numbers for both events are correct. Somehow the pie does not reflect the numbers.  

0 Karma
Get Updates on the Splunk Community!

See just what you’ve been missing | Observability tracks at Splunk University

Looking to sharpen your observability skills so you can better understand how to collect and analyze data from ...

Weezer at .conf25? Say it ain’t so!

Hello Splunkers, The countdown to .conf25 is on-and we've just turned up the volume! We're thrilled to ...

How SC4S Makes Suricata Logs Ingestion Simple

Network security monitoring has become increasingly critical for organizations of all sizes. Splunk has ...