Splunk Search

Unable to find percentage of two values stored in two separate fieldnames

sh254087
Communicator

I'm facing a weird issue. I'm not able to calculate percentage value when I use two variables/fields.

I have a lookup file which looks something like - 

sl,Service,x_value

1,X,0.211

2,other,0.190

3,Y,0

4,X,0.200

5,other,0.220

I'm trying to get two columns in my resultant table to show total by service and percentage by service, respectively.
I've tried this - 

sh254087_0-1690536465779.png
percentage needs to be calculated using 2 fields whereas perc1 and perc2 are substituted with one of those two field values.

While the perc1 and perc2 gets processed and displayed, percentage doesn't show up.

I'm not sure what is that I'm doing wrong here. Can somebody please help?

Labels (5)
0 Karma
1 Solution

ITWhisperer
SplunkTrust
SplunkTrust
| inputlookup xyz.csv
| stats sum(x_value) as TotalMain by Service
| eventstats sum(TotalMain) as Total
| eval percentage=100*TotalMain/Total

View solution in original post

ITWhisperer
SplunkTrust
SplunkTrust
| inputlookup xyz.csv
| stats sum(x_value) as TotalMain by Service
| eventstats sum(TotalMain) as Total
| eval percentage=100*TotalMain/Total

sh254087
Communicator

This just worked perfectly. Thank you very much, @ITWhisperer .

I had never used eventstats practically. Will check more on it. 

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