"Single value" output on a User Session query

[clc]

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

[gilgi · Accepted solution]

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.