Splunk Search

Plot average time between events.

picktheneedle
Loves-to-Learn

Can someone help me with the query to plot average time between events matching a field having certain value e.g msg="xyz"? The span is every 10 minutes. For e.g if events occurs 6000 times in 10 minutes, then average time between events is 600/6000 = 0.1 sec. 

Thanks

 

Labels (1)
0 Karma

gcusello
SplunkTrust
SplunkTrust

Hi @picktheneedle,

you have to filter events in the main search and then count the results in each span, something like this:

index=your_index msg="xyz"
| timechart span=10m count
| eval "Average (sec)"=count/600

to adapt to your real situation.

Ciao.

Giuseppe

0 Karma
Career Survey
First 500 qualified respondents will receive a $20 gift card! Tell us about your professional Splunk journey.

Can’t make it to .conf25? Join us online!

Get Updates on the Splunk Community!

Community Content Calendar, September edition

Welcome to another insightful post from our Community Content Calendar! We're thrilled to continue bringing ...

Splunkbase Unveils New App Listing Management Public Preview

Splunkbase Unveils New App Listing Management Public PreviewWe're thrilled to announce the public preview of ...

Leveraging Automated Threat Analysis Across the Splunk Ecosystem

Are you leveraging automation to its fullest potential in your threat detection strategy?Our upcoming Security ...