topic Re: How to search average sessions started by hour? in Security

How to search average sessions started by hour?

Rapidz — Fri, 18 Feb 2022 17:59:37 GMT

Hey,

I am dealing with data from an app, and I am trying to figure out how to see what times of the day our app is most popular by hour. Im not sure how I can get an average of what times are popular of when users start the app.

If anyone could help, it would be greatly appreciated!

Heres the query I have been using to see users starting sessions:

index=app1 AND service=app AND logLevel=INFO AND environment=prod "message.eventAction"=START_SESSION

Thanks!

Re: How to search average Sessions started by hour

isoutamo — Fri, 18 Feb 2022 17:58:21 GMT

you could use e.g. timechart with span=1h or stats/chart and before it bin span=1h _time.

r. Ismo

Re: How to search average sessions started by hour?

richgalloway — Fri, 18 Feb 2022 18:00:43 GMT

Use a timechart to get the session counts for each hour. Then switch to the visualization tab to see the peaks.

index=app1 AND service=app AND logLevel=INFO AND environment=prod "message.eventAction"=START_SESSION | timechart span=1h count

Re: How to search average sessions started by hour?

somesoni2 — Fri, 18 Feb 2022 18:30:05 GMT

Try something like this to find top 5 hours based on session start

index=app1 AND service=app AND logLevel=INFO AND environment=prod "message.eventAction"=START_SESSION | bucket span=1d _time | stats count by _time | sort 5 -count

Re: How to search average sessions started by hour?

Rapidz — Fri, 18 Feb 2022 19:00:21 GMT

Hey,

Is there a way for I can see the average time by hour. Right now this just shows the times when users login. It would be super useful for I can know how many users on average use the app by X AM/PM.