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!

Advanced Splunk Data Management Strategies

Join us on Wednesday, May 14, 2025, at 11 AM PDT / 2 PM EDT for an exclusive Tech Talk that delves into ...

Uncovering Multi-Account Fraud with Splunk Banking Analytics

Last month, I met with a Senior Fraud Analyst at a nationally recognized bank to discuss their recent success ...

Secure Your Future: A Deep Dive into the Compliance and Security Enhancements for the ...

What has been announced?  In the blog, “Preparing your Splunk Environment for OpensSSL3,”we announced the ...