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
Legend

@codedtech ,

Try

|timechart avg(eval(if(volume==0,null(),volume))) as avg
---
What goes around comes around. If it helps, hit it with Karma 🙂

View solution in original post

renjith_nair
Legend

@codedtech ,

Try

|timechart avg(eval(if(volume==0,null(),volume))) as avg
---
What goes around comes around. If it helps, hit it with Karma 🙂
Get Updates on the Splunk Community!

Get ready to show some Splunk Certification swagger at .conf24!

Dive into the deep end of data by earning a Splunk Certification at .conf24. We're enticing you again this ...

Built-in Service Level Objectives Management to Bridge the Gap Between Service & ...

Now On-Demand Join us to learn more about how you can leverage Service Level Objectives (SLOs) and the new ...

Database Performance Sidebar Panel Now on APM Database Query Performance & Service ...

We’ve streamlined the troubleshooting experience for database-related service issues by adding a database ...