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!

See just what you’ve been missing | Observability tracks at Splunk University

Looking to sharpen your observability skills so you can better understand how to collect and analyze data from ...

Weezer at .conf25? Say it ain’t so!

Hello Splunkers, The countdown to .conf25 is on-and we've just turned up the volume! We're thrilled to ...

How SC4S Makes Suricata Logs Ingestion Simple

Network security monitoring has become increasingly critical for organizations of all sizes. Splunk has ...