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!

Using Machine Learning for Hunting Security Threats

WATCH NOW Seeing the exponential hike in global cyber threat spectrum, organizations are now striving more for ...

Observability Newsletter Highlights | March 2023

 March 2023 | Check out the latest and greatestSplunk APM's New Tag Filter ExperienceSplunk APM has updated ...

Security Newsletter Updates | March 2023

 March 2023 | Check out the latest and greatestUnify Your Security Operations with Splunk Mission Control The ...