Splunk Search

How to calculate the mean and standard deviation in Splunk?

pavanae
Builder

I have a search as follows :-

My search | timechart span=1h limit=0 count by city

Now how can I calculate the mean activity volume per city?

And how to find the one's more than n standard deviations above the mean?

0 Karma
1 Solution

cmerriman
Super Champion

https://docs.splunk.com/Documentation/Splunk/6.5.0/Search/Findingandremovingoutliers
this is a doc on removing outliers.

this might get your your average and stdev. create an eval to find the difference for n standard deviations above the mean.

My search 
| timechart span=1h limit=0 count by city
|stats avg(count) as avg stdev(count) as stdev by city

View solution in original post

cmerriman
Super Champion

https://docs.splunk.com/Documentation/Splunk/6.5.0/Search/Findingandremovingoutliers
this is a doc on removing outliers.

this might get your your average and stdev. create an eval to find the difference for n standard deviations above the mean.

My search 
| timechart span=1h limit=0 count by city
|stats avg(count) as avg stdev(count) as stdev by city
Get Updates on the Splunk Community!

Detecting Remote Code Executions With the Splunk Threat Research Team

WATCH NOWRemote code execution (RCE) vulnerabilities pose a significant risk to organizations. If exploited, ...

Enter the Splunk Community Dashboard Challenge for Your Chance to Win!

The Splunk Community Dashboard Challenge is underway! This is your chance to showcase your skills in creating ...

.conf24 | Session Scheduler is Live!!

.conf24 is happening June 11 - 14 in Las Vegas, and we are thrilled to announce that the conference catalog ...