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

User Session Query Language for plotting response time

shashank_b_agra
Organizer

Hi, I am trying to play the response time of various metrics like visuallyCompleteTime, networkTime, serverTime for some of my key user actions. What i want to do is create a chart where the average response time is plotted on Y-axis and time on X-axis so that I can compare how is it looking over the day.

I have tried one query but it's not giving me the results what i expected. Any advice or help is appreciated. 

 

 

SELECT DATETIME(startTime, "HH:mm", "5m") as Buckets,  AVG(visuallyCompleteTime), MIN(visuallyCompleteTime), MAX(visuallyCompleteTime), AVG(ser) FROM useraction
WHERE name IN ("loading of page /myPage")
GROUP BY Buckets

 

This query is giving me below chart but it's not what I want.

shashank_b_agra_0-1631618357147.png

 

1 REPLY 1

Christophe_N
Frequent Guest

Hi Shashank,

 

Maybe Data Explorer will make thing easier for you , you will have data in real time for all actions and not average by 5-min timerange ?

You can graph it easily ,splitted by key user action

 

Unless you really want to group data from multiple days on specific timeslot : if yes, your solution seems to be fine by your USQL Request.
What do you expect more than that's in your graph ?

 

Christophe_N_0-1631882187858.png