topic Re: Session Duration in minutes in Getting Data In

Session Duration in minutes

JoeSco27 — Wed, 31 Jul 2013 19:24:05 GMT

I have a search that returns the "Avg Session Duration" by USER_ID. The results are coming back in minutes as long as the time being returned is less then 60 minutes. My problem is that when the "Avg Session Duration" goes over 1 hour the minutes no longer return properly.

This is my format, at the end of my search string, to have the response time come back in minutes.

< mysearch > | fieldformat "Avg Session Duration(minutes)"=strftime('Avg Session Duration(minutes)', "%M:%S")

I have tried to add %H and make the time format "%H:%M:%S" but the "Avg Session Duration" is still being returned wrong. Is there a way to return the "Avg Session Duration" in an hour, min, second format?

Re: Session Duration in minutes

cramasta — Wed, 31 Jul 2013 19:49:10 GMT

please provide example of how the minute field in the events look before 1 minute and after 1 minute

Re: Session Duration in minutes

Gilberto_Castil — Wed, 31 Jul 2013 20:13:54 GMT

This will likely do what you are looking for:

rename "Avg Session Duration(minutes)" AS avgSessionDuration 
| fieldformat avgSessionDuration=tostring(avgSessionDuration,"duration")

This has also been hacked in the past to make even prettier:

rename "Avg Session Duration(minutes)" AS avgSessionDuration 
| eval pretty_AvgSessionDuration = floor(avgSessionDuration/60)." Hours ".floor(floor(avgSessionDuration - (avgSessionDuration/60))/60)." Min"

Re: Session Duration in minutes

JoeSco27 — Thu, 01 Aug 2013 13:51:58 GMT

Thank you, this works perfectly

Re: Session Duration in minutes

reneedeleon — Tue, 15 Oct 2019 14:18:44 GMT

What if you wanted to add days?