Splunk Search
Highlighted

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

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
Highlighted

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

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

Highlighted

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

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