topic Re: USQL in Real User Monitoring

USQL - the average of sessions in my application

natanael_mendes — Tue, 05 Dec 2023 08:25:21 GMT

Hello guys, how can i make a usql query to get the average of sessions in my application per day?

i cant find a fild to put in the AVG

Select AVG("missing field") from usersession

Re: USQL

cmonson — Mon, 04 Dec 2023 21:30:18 GMT

How does this work for you?

SELECT count(DISTINCT userSessionId), day(startTime) as "Day" FROM usersession GROUP BY Day

Re: USQL

Mizső — Mon, 04 Dec 2023 23:26:24 GMT

Hi @natanael_mendes,

Maybe the avg session duration is also interesting for your business:

SELECT AVG(usersession.duration), osFamily FROM usersession WHERE ((useraction.application='XXX' OR userevent.application='XXX' OR usererror.application='XXX')) GROUP BY osFamily

Best regards,

Mizső