Comments and answers for "How to perform mathematical calculations based off one column"https://answers.splunk.com/answers/762806/how-to-perform-mathematical-calculations-based-off.html
The latest comments and answers for the question "How to perform mathematical calculations based off one column"Comment by gdorman619 on gdorman619's answerhttps://answers.splunk.com/comments/762826/view.html
Thank you very much! It worked.Sat, 03 Aug 2019 14:26:00 GMTgdorman619Answer by niketnilayhttps://answers.splunk.com/answering/763381/view.html
@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)Sat, 03 Aug 2019 04:08:17 GMTniketnilayAnswer by prabhakar_pshttps://answers.splunk.com/answering/763378/view.html
| stats sum(ACCESS_REVIEW_COMPLETE) as Total count as count1
| eval result=(Total/count1)
Check if this helpsSat, 03 Aug 2019 02:40:17 GMTprabhakar_ps