Splunk Search

Average of session duration

keshab
Path Finder

search SessionID="*" | stats range(_time) AS Session_Duration_sec by SessionID

I got the each session duration using the above command. Now how do I calculate the average of all those session duration??

Tags (1)

hjwang
Contributor

if you only wanna show final result , just

SessionID="*" | stats range(_time) AS Session_Duration_sec by SessionID | stats avg(Session_Duraion_sec)

else if you wanna append to first result

SessionID="*" | stats range(_time) AS Session_Duration_sec by SessionID | append [ search SessionID="*" | stats range(_time) AS Session_Duration_sec by SessionID | stats avg(Session_Duraion_sec)]

Here I think the Splunk should expand some calculating functions to add rows like addcoltotals to summarize the table results. If some of this have been existed, please let me know. Thanks!!

0 Karma

kristian_kolb
Ultra Champion

just pipe it through stats again

| stats avg(Session_Duration_Sec)

/kristian

0 Karma
Get Updates on the Splunk Community!

Detecting Brute Force Account Takeover Fraud with Splunk

This article is the second in a three-part series exploring advanced fraud detection techniques using Splunk. ...

Buttercup Games: Further Dashboarding Techniques (Part 9)

This series of blogs assumes you have already completed the Splunk Enterprise Search Tutorial as it uses the ...

Buttercup Games: Further Dashboarding Techniques (Part 8)

This series of blogs assumes you have already completed the Splunk Enterprise Search Tutorial as it uses the ...