Splunk Search

Calculate avg excluding the min and max times

carlpier
Explorer

Hello,
I am looking for a way to calculate the avg excluding the occurrence with the time_min and time_max
Here is the simple base search:
index="nbdrest-performance" sourcetype="PerfNBDCustomTSV" | chart count min(ETms) max(ETms) avg(ETms) by Service | sort count | reverse
Any help would be greatly appreciated.
Thanks in advance!

Tags (2)

fdi01
Motivator

index="nbdrest-performance" sourcetype="PerfNBDCustomTSV" | chart avg count by Service | sort by count

or

index="nbdrest-performance" sourcetype="PerfNBDCustomTSV" | stats count avg by Service | sort by count

0 Karma
Get Updates on the Splunk Community!

Index This | When is October more than just the tenth month?

October 2025 Edition  Hayyy Splunk Education Enthusiasts and the Eternally Curious!   We’re back with this ...

Observe and Secure All Apps with Splunk

  Join Us for Our Next Tech Talk: Observe and Secure All Apps with SplunkAs organizations continue to innovate ...

What’s New & Next in Splunk SOAR

 Security teams today are dealing with more alerts, more tools, and more pressure than ever.  Join us for an ...