14 Sep 202112:20 PM - last edited on 20 Sep 202109:36 AM by MaciejNeumann
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.