topic "Single value" output on a User Session query in Real User Monitoring

"Single value" output on a User Session query

clc — Tue, 07 Feb 2023 11:36:16 GMT

Trying to make a couple of session queries but not really able to get the result we want.

We have one user action in which we would like to get a "single value" output on all of this user action which response time is between 2s and 5s.

We can not really get this output as a single value, any one that can help us in the right directino with this?

-Claus

Re: User Session Query

gilgi — Tue, 31 Jan 2023 13:58:37 GMT

The following Should work:

select avg(visuallyCompleteTime) from useraction where useraction.application = "APPLICATION NAME" and name = "USER ACTION NAME" and visuallyCompleteTime between 2000 and 5000.

If you don't get the relevant data, make sure it is actually documented. Also remeber that USQL is valid only for completed sessions.