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!

Stay Connected: Your Guide to July and August Tech Talks, Office Hours, and Webinars!

Dive into our sizzling summer lineup for July and August Community Office Hours and Tech Talks. Scroll down to ...

Edge Processor Scaling, Energy & Manufacturing Use Cases, and More New Articles on ...

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...

Get More Out of Your Security Practice With a SIEM

Get More Out of Your Security Practice With a SIEMWednesday, July 31, 2024  |  11AM PT / 2PM ETREGISTER ...