cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

USQL - the average of sessions in my application

natanael_mendes
Champion

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

Dynatrace Professional Certified
2 REPLIES 2

cmonson
Observer

How does this work for you?

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

Mizső
DynaMight Leader
DynaMight Leader

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ő

Certified Dynatrace Professional

Featured Posts