Splunk Search

Timechart avg of values greater than 0

codedtech
Path Finder

I'm building a time chart of avg daily backup volume, and I need to exclude entries where volume = 0. The reason being is that 0 skews my averages something awful.

0 Karma
1 Solution

renjith_nair
SplunkTrust
SplunkTrust

@codedtech ,

Try

|timechart avg(eval(if(volume==0,null(),volume))) as avg
Happy Splunking!

View solution in original post

renjith_nair
SplunkTrust
SplunkTrust

@codedtech ,

Try

|timechart avg(eval(if(volume==0,null(),volume))) as avg
Happy Splunking!
Get Updates on the Splunk Community!

Splunk Cloud | Empowering Splunk Administrators with Admin Config Service (ACS)

Greetings, Splunk Cloud Admins and Splunk enthusiasts! The Admin Configuration Service (ACS) team is excited ...

Tech Talk | One Log to Rule Them All

One log to rule them all: how you can centralize your troubleshooting with Splunk logs We know how important ...

Splunk Security Content for Threat Detection & Response, Q1 Roundup

Join Principal Threat Researcher, Michael Haag, as he walks through: An introduction to the Splunk Threat ...