USQL - the average of sessions in my application

[natanael_mendes]

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

[cmonson · Accepted solution]

How does this work for you?

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

[Mizső · Accepted solution]

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ő