Splunk Search

How to Find Standard Deviation of a Daily Volume?


I'm trying to find the standard deviation of the daily volume of traffic per host. index=index sourcetype=sourcetype earliest=-7d|stats sum(VOLUME) by host gives me the Total Volume per host over the last week, and index=index sourcetype=sourcetype earliest=-7d|stats sum(VOLUME) as VOLUME by host|eval avg=VOLUME/7 gives me the average daily volume per host. But if I try `stdev(avg)', or anything like that, I get no results. How can I get the standard deviation I want?

Note- I'm trying to do this in order to set up an alert to trigger if a daily volume falls outside the 95% confidence interval, so if there's an easier way to do that, please let me know.

Tags (2)
0 Karma
Get Updates on the Splunk Community!

.conf23 | Get Your Cybersecurity Defense Analyst Certification in Vegas

We’re excited to announce a new Splunk certification exam being released at .conf23! If you’re going to Las ...

Streamline Data Ingestion With Deployment Server Essentials

REGISTER NOW!Every day the list of sources Admins are responsible for gets bigger and bigger, often making the ...

Remediate Threats Faster and Simplify Investigations With Splunk Enterprise Security ...

REGISTER NOW!Join us for a Tech Talk around our latest release of Splunk Enterprise Security 7.2! We’ll walk ...