How to perform mathematical calculations based off one column

[gdorman619]

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)

[niketn · Accepted solution]

@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)

[gdorman619]

Thank you very much! It worked.

[prabhakar_ps]

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

Check if this helps