RUM DQL Queries

[Ganeshmete77]

Hi Team,

i have below user session queries, i am looking for similar queries in DQL.

"userActionDuration" : f'SELECT AVG(useraction.duration),useraction.name FROM usersession WHERE userType="REAL_USER" AND userevent.pageGroup="{pageGroup}" GROUP BY useraction.name'

"visuallyCompleteTime" : f'SELECT AVG(useraction.visuallyCompleteTime),useraction.name FROM usersession WHERE userType="REAL_USER" AND userevent.pageGroup="{pageGroup}" GROUP BY useraction.name'

"documentInteractiveTime" : f'SELECT AVG(useraction.documentInteractiveTime),useraction.name FROM usersession WHERE userType="REAL_USER" AND userevent.pageGroup="{pageGroup}" GROUP BY useraction.name'

Please help me with these DQL queries or share me any related document for reference.

[Tommaso_Fin]

Hi, you could start from something like this:

fetch user.events
| filter isNotNull(user_action.id)
| filter dt.rum.user_type == "real_user"
| summarize avg(duration), by:{user_action.id, user_action.name}

About the new duration metrics you can check here:

https://www.dynatrace.com/knowledge-base/core-web-vitals/

bye