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!

Demo Day: Strengthen Your SOC with Splunk Enterprise Security 8.1

Today’s threat landscape is more complex than ever. Security operation centers (SOCs) are overwhelmed with ...

Dashboards: Hiding charts while search is being executed and other uses for tokens

There are a couple of features of SimpleXML / Classic dashboards that can be used to enhance the user ...

Splunk Observability Cloud's AI Assistant in Action Series: Explaining Metrics and ...

This is the fourth post in the Splunk Observability Cloud’s AI Assistant in Action series that digs into how ...