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

View solution in original post

renjith_nair
SplunkTrust
SplunkTrust

@codedtech ,

Try

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

View solution in original post

.conf21 Now Fully Virtual!
Register for FREE Today!

We've made .conf21 totally virtual and totally FREE! Our completely online experience will run from 10/19 through 10/20 with some additional events, too!