topic Re: Unable to find percentage of two values stored in two separate fieldnames in Splunk Search

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

sh254087 — Fri, 28 Jul 2023 10:11:51 GMT

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 -

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?

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

ITWhisperer — Fri, 28 Jul 2023 10:25:04 GMT

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

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

sh254087 — Fri, 28 Jul 2023 10:31:17 GMT

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

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