topic Re: How to perform mathematical calculations based off one column in Splunk Search

How to perform mathematical calculations based off one column

gdorman619 — Fri, 02 Aug 2019 23:44:28 GMT

Hello,

I'm new to Splunk and I'm having trouble with the following line of code. I think what I'm trying to do is pretty self-explanatory. Essentially the data I'm working with is one column and the values in the column are "0" or "1".
Any help would be greatly appreciated. Thank you!

| stats sum(ACCESS_REVIEW_COMPLETE) \ count(ACCESS_REVIEW_COMPLETE)

Re: How to perform mathematical calculations based off one column

prabhakar_ps — Wed, 30 Sep 2020 01:38:00 GMT

| stats sum(ACCESS_REVIEW_COMPLETE) as Total count as count1
| eval result=(Total/count1)

Check if this helps

Re: How to perform mathematical calculations based off one column

niketn — Sat, 03 Aug 2019 04:08:17 GMT

@gdorman619 try the following search ratio field will have required output.

<yourCurrentSearch>
| stats sum(ACCESS_REVIEW_COMPLETE) as sum count(ACCESS_REVIEW_COMPLETE) as count
| eval ratio=round(sum/count,2)

Re: How to perform mathematical calculations based off one column

gdorman619 — Sat, 03 Aug 2019 14:26:00 GMT

Thank you very much! It worked.