Timechart avg of values greater than 0

[codedtech]

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.

[renjith_nair · Accepted solution]

@codedtech ,

Try

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