Dashboards & Visualizations

Convert ERROR count to overall percentage

OgoNARA
Explorer

I got a visualization that counts the total amount of errors using a lookup. Instead of the actual number of events I'd like to get a percentage of specifically errors. Image attached for reference 

OgoNARA_0-1723580938524.png

 

 

| inputlookup fm4143_3d.csv
| stats count(ERROR_MESSAGE)
```| appendpipe
[| stats count as message
| eval message=if(message==0,"", " ")]
| fields - message ```
Labels (2)
0 Karma

ITWhisperer
SplunkTrust
SplunkTrust

It is not clear what your events look like but assuming each event has an ERROR_MESSAGE field and you want to count by that message and work out the percentage of the total this represents, you could do something like this

| stats count by ERROR_MESSAGE
| eventstats sum(count) as total
| eval count=100*count/total
Get Updates on the Splunk Community!

Introduction to Splunk Observability Cloud - Building a Resilient Hybrid Cloud

Introduction to Splunk Observability Cloud - Building a Resilient Hybrid Cloud  In today’s fast-paced digital ...

Observability protocols to know about

Observability protocols define the specifications or formats for collecting, encoding, transporting, and ...

Take Your Breath Away with Splunk Risk-Based Alerting (RBA)

WATCH NOW!The Splunk Guide to Risk-Based Alerting is here to empower your SOC like never before. Join Haylee ...