All Apps and Add-ons

how to calculate percentage for each category

hqw
Path Finder

Hi all,

i want to calculate and display percentage for each category not the records, based on below search , i can get the result of records number, but i want to display as percentage, could you pls kindly let me know how to calculate? Thanks

**|stats count as count by Q |addtotals col=t row=f labelfield="Q" label=all

result:
Q count
A 220
B 387
C 228
D 247
E 268
all 1350

0 Karma
1 Solution

hqw
Path Finder

i have fixed the problem by below search:

**| eventstats count(Q) as total |stats count as count by Q total|eval percent=round(count/total*100,2) |table Q,percent

thanks.

View solution in original post

0 Karma

hqw
Path Finder

i have fixed the problem by below search:

**| eventstats count(Q) as total |stats count as count by Q total|eval percent=round(count/total*100,2) |table Q,percent

thanks.

0 Karma
Get Updates on the Splunk Community!

Splunk Observability Cloud | Unified Identity - Now Available for Existing Splunk ...

Raise your hand if you’ve already forgotten your username or password when logging into an account. (We can’t ...

Index This | How many sides does a circle have?

February 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

Registration for Splunk University is Now Open!

Are you ready for an adventure in learning?   Brace yourselves because Splunk University is back, and it's ...