https://community.splunk.com/t5/Splunk-Search/How-to-calculate-successful-percentage-grouped-by-another-field/m-p/597463#M208009 <P>Give this a try (and may be post your question as text instead of picture next time<span class="lia-unicode-emoji" title=":beaming_face_with_smiling_eyes:">😁</span>&nbsp;)</P><LI-CODE lang="markup">Your Base search | where status="Received" OR status="Success" | stats count(eval(status="Received")) as Received count(eval(status="Success")) as Success by sourceNodeCode labelType | eval SuccessRate=round((Success*100)/ Received,2) | stats list(labelType) as labelType list(Received) as GenerationCount list(SuccessRate) as "SuccessRate%" by sourceNodeCode</LI-CODE><P>&nbsp;&nbsp;</P> Wed, 11 May 2022 18:20:24 GMT somesoni2 2022-05-11T18:20:24Z https://community.splunk.com/t5/Splunk-Search/How-to-calculate-successful-percentage-grouped-by-another-field/m-p/597438#M207998 <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="csahoo_0-1652283566233.png" style="width: 400px;"><img src="https://community.splunk.com/t5/image/serverpage/image-id/19587i7D09E8CEDBEEFEB8/image-size/medium?v=v2&amp;px=400" role="button" title="csahoo_0-1652283566233.png" alt="csahoo_0-1652283566233.png" /></span></P> <P>&nbsp;</P> Wed, 11 May 2022 15:46:51 GMT https://community.splunk.com/t5/Splunk-Search/How-to-calculate-successful-percentage-grouped-by-another-field/m-p/597438#M207998 csahoo 2022-05-11T15:46:51Z https://community.splunk.com/t5/Splunk-Search/How-to-calculate-successful-percentage-grouped-by-another-field/m-p/597447#M208005 <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="ITWhisperer_0-1652286765400.png" style="width: 400px;"><img src="https://community.splunk.com/t5/image/serverpage/image-id/19588i3D4DF7D1DD165ECD/image-size/medium?v=v2&amp;px=400" role="button" title="ITWhisperer_0-1652286765400.png" alt="ITWhisperer_0-1652286765400.png" /></span></P><P>&nbsp;</P> Wed, 11 May 2022 16:32:55 GMT https://community.splunk.com/t5/Splunk-Search/How-to-calculate-successful-percentage-grouped-by-another-field/m-p/597447#M208005 ITWhisperer 2022-05-11T16:32:55Z https://community.splunk.com/t5/Splunk-Search/How-to-calculate-successful-percentage-grouped-by-another-field/m-p/597463#M208009 <P>Give this a try (and may be post your question as text instead of picture next time<span class="lia-unicode-emoji" title=":beaming_face_with_smiling_eyes:">😁</span>&nbsp;)</P><LI-CODE lang="markup">Your Base search | where status="Received" OR status="Success" | stats count(eval(status="Received")) as Received count(eval(status="Success")) as Success by sourceNodeCode labelType | eval SuccessRate=round((Success*100)/ Received,2) | stats list(labelType) as labelType list(Received) as GenerationCount list(SuccessRate) as "SuccessRate%" by sourceNodeCode</LI-CODE><P>&nbsp;&nbsp;</P> Wed, 11 May 2022 18:20:24 GMT https://community.splunk.com/t5/Splunk-Search/How-to-calculate-successful-percentage-grouped-by-another-field/m-p/597463#M208009 somesoni2 2022-05-11T18:20:24Z https://community.splunk.com/t5/Splunk-Search/How-to-calculate-successful-percentage-grouped-by-another-field/m-p/597728#M208130 <P>Thank you very much &nbsp;<a href="https://community.splunk.com/t5/user/viewprofilepage/user-id/225168">@ITWhisperer</a>&nbsp;<a href="https://community.splunk.com/t5/user/viewprofilepage/user-id/15147">@somesoni2</a>&nbsp;both the queries are working fine</P> Fri, 13 May 2022 07:21:16 GMT https://community.splunk.com/t5/Splunk-Search/How-to-calculate-successful-percentage-grouped-by-another-field/m-p/597728#M208130 csahoo 2022-05-13T07:21:16Z