Splunk Search

Calculate average execution time for a known field

mhornste
Path Finder

Hi,

I'm having issues calculating the average execution time of an available field in Splunk. I have searched for some time now on Splunk Answers and tried a lot, but unfortunately couldn't find s.th. helpful.

The following search string lists the Execution Times of a specific function of my application for the selected time span:

index= otcs FunctionAction="ngd.folderview" | table ExecutionTime

I'd like to have an output of this FunctionAction with the average Execution time of the selected time frame of all values listed by the search string. I already did some tests like avg(ExecutionTime) and had some results as Single Value, but the average was not correct (I double checked with Excel: restricted the time span to have only a few values).

Could anyone point me to the right direction?

Thanks!

Tags (3)
0 Karma

woodcock
Esteemed Legend

Like this:

 index= otcs FunctionAction="ngd.folderview" | stats avg(ExecutionTime)
Get Updates on the Splunk Community!

Webinar Recap | Revolutionizing IT Operations: The Transformative Power of AI and ML ...

The Transformative Power of AI and ML in Enhancing Observability   In the realm of IT operations, the ...

.conf24 | Registration Open!

Hello, hello! I come bearing good news: Registration for .conf24 is now open!   conf is Splunk’s rad annual ...

ICYMI - Check out the latest releases of Splunk Edge Processor

Splunk is pleased to announce the latest enhancements to Splunk Edge Processor.  HEC Receiver authorization ...