https://community.splunk.com/t5/Splunk-Search/How-to-Calculate-the-Percentage-of-each-entry/m-p/566584#M197446 <P>Hi Ismo,</P><P>your solution works. Thanks! <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P>&nbsp;</P> Fri, 10 Sep 2021 08:30:48 GMT Sentira 2021-09-10T08:30:48Z https://community.splunk.com/t5/Splunk-Search/How-to-Calculate-the-Percentage-of-each-entry/m-p/566571#M197441 <P>I have the following SPL and I want to show table below. The value of&nbsp;Total must be equal to count of events (1588).&nbsp; How can I pur the total count of events into Total variable?<BR /><BR />index=abc&nbsp;<BR />| stats count as Count by reason_code<BR />| where reason_code != "false"<BR />| addtotals col=t labelfield=reason_code label="Retrieval task cancelled" fieldname="Percentage"<BR />| eval "Percentage"= round((Count/Total) * 100,2)."%"<BR /><BR /><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="image.png" style="width: 999px;"><img src="https://community.splunk.com/t5/image/serverpage/image-id/15938i145F7C3712CF5CB8/image-size/large?v=v2&amp;px=999" role="button" title="image.png" alt="image.png" /></span></P> Fri, 10 Sep 2021 06:36:53 GMT https://community.splunk.com/t5/Splunk-Search/How-to-Calculate-the-Percentage-of-each-entry/m-p/566571#M197441 Sentira 2021-09-10T06:36:53Z https://community.splunk.com/t5/Splunk-Search/How-to-Calculate-the-Percentage-of-each-entry/m-p/566574#M197442 <P>Hi</P><P>Did this help you?</P><LI-CODE lang="markup">index=abc | stats count as Count by reason_code | eventstats sum(Count) as Total | where reason_code != "false" | addtotals col=t labelfield=reason_code label="Retrieval task cancelled" fieldname="Percentage" | eval "Percentage"= round((Count/Total) * 100,2)."%"</LI-CODE><P>r. Ismo&nbsp;</P> Fri, 10 Sep 2021 06:46:56 GMT https://community.splunk.com/t5/Splunk-Search/How-to-Calculate-the-Percentage-of-each-entry/m-p/566574#M197442 isoutamo 2021-09-10T06:46:56Z https://community.splunk.com/t5/Splunk-Search/How-to-Calculate-the-Percentage-of-each-entry/m-p/566584#M197446 <P>Hi Ismo,</P><P>your solution works. Thanks! <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P>&nbsp;</P> Fri, 10 Sep 2021 08:30:48 GMT https://community.splunk.com/t5/Splunk-Search/How-to-Calculate-the-Percentage-of-each-entry/m-p/566584#M197446 Sentira 2021-09-10T08:30:48Z