Splunk Search

How to get percentage from stats count on http statuses?

xvxt006
Contributor

Hi,

I would like to get stats by http status and also i would like to add percentage column. when i use top it gives by uri or some other field which i don't want.

Right now output looks like this. But i need to add percentage.
status count
200 557374
301 151
302 61
400 33
404 542
405 24
500 6541

Tags (2)
1 Solution

somesoni2
Revered Legend

Try something like this

your base search | stats count by status | eventstats sum(count) as perc | eval perc=round(count*100/perc,2)

View solution in original post

somesoni2
Revered Legend

Try something like this

your base search | stats count by status | eventstats sum(count) as perc | eval perc=round(count*100/perc,2)
Get Updates on the Splunk Community!

Introducing the 2024 SplunkTrust!

Hello, Splunk Community! We are beyond thrilled to announce our newest group of SplunkTrust members!  The ...

Introducing the 2024 Splunk MVPs!

We are excited to announce the 2024 cohort of the Splunk MVP program. Splunk MVPs are passionate members of ...

Splunk Custom Visualizations App End of Life

The Splunk Custom Visualizations apps End of Life for SimpleXML will reach end of support on Dec 21, 2024, ...