topic Re: User Session Query Language - example in Real User Monitoring

User Session Query Language - example

Romanenkov_Alex — Thu, 14 Feb 2019 07:29:31 GMT

Hello,

Can anyone show to me example for such task:

I have action named "test" - key user action.

I need to get query to get value of (visuallyCompleteTime) for my action "test" for specific userid (test@test)

Thank you.

Regards,

Alexander

Re: User Session Query Language - example

David_Hauger — Thu, 14 Feb 2019 08:20:56 GMT

You could use:

SELECT starttime, visuallyCompleteTime FROM useraction WHERE name = "name" AND usersession.userId = "test@test"

to get all the different values.

Or, if they are too much:

SELECT AVG(visuallyCompleteTime), MIN(visuallyCompleteTime), MAX(visuallyCompleteTime), COUNT(*) FROM useraction WHERE name = "name" AND usersession.userId = "test@test"

to get some statistics on the visuallyCompleteTime

Re: User Session Query Language - example

Romanenkov_Alex — Thu, 14 Feb 2019 08:30:31 GMT

i changed userId to usersession.userId and it works.

Thank you.

Re: User Session Query Language - example

David_Hauger — Thu, 14 Feb 2019 09:15:53 GMT

ah, yes, of course - updated it in the query