Splunk Search

How to add new column to chart with success rate of other columns

gsolomon11
New Member

I'm using the following search to generate the table below:

rex "<status>(?<status>.*?)<"|
search status=Incomplete OR    status=Complete OR status=Fail* |
count(status) by cRegion status

alt text

I'd like to create a fifth column which calulates the SuccessRate for each cRegion like this:

(Complete-(Failed+Incomplete)) / (Complete + Failed + Incomplete)

alt text

I've tried an assortment of different eval and stat and table expressions but cannot figure it out. Any help would be greatly appreciated! I would like to use the chart command.

Tags (1)
0 Karma
1 Solution

rjthibod
Champion

How about this?

rex "<status>(?<status>.*?)<"
| search status=Incomplete OR status=Complete OR status=Fail* 
| chart count(status) by cRegion status
| eval SuccessRate = round((Complete - (Failed + Incomplete)) / (Complete + Failed + Incomplete), 6)

View solution in original post

rjthibod
Champion

How about this?

rex "<status>(?<status>.*?)<"
| search status=Incomplete OR status=Complete OR status=Fail* 
| chart count(status) by cRegion status
| eval SuccessRate = round((Complete - (Failed + Incomplete)) / (Complete + Failed + Incomplete), 6)

gsolomon11
New Member

Wow, thank you so much!
I didn't know Splunk would know that the Complete/Failed/Incomplete parameters in the eval statement correspond to statuses and to automatically include them in the chart.

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 ...