# User Session Query Language for plotting response time

**URL:** <https://community.dynatrace.com/t/user-session-query-language-for-plotting-response-time/32682>\
**Category:** Real User Monitoring\
**Tags:** real-user-monitoring-classic, usql, user-sessions\
**Created:** [September 14, 2021, 11:20am UTC](https://community.dynatrace.com/t/user-session-query-language-for-plotting-response-time/32682 "2021-09-14T11:20:20Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![shashank\_b\_agra](https://avatars.discourse-cdn.com/v4/letter/s/35a633/32.png) [@shashank\_b\_agra](https://community.dynatrace.com/u/shashank_b_agra)\
**Post date:** [September 14, 2021, 11:20am UTC](https://community.dynatrace.com/t/user-session-query-language-for-plotting-response-time/32682/1 "2021-09-14T11:20:20Z")

</div>

Hi, I am trying to play the response time of various metrics like&nbsp;visuallyCompleteTime,&nbsp;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.

```markup
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](https://global.discourse-cdn.com/dynatrace/original/2X/7/7678a5bba27b6c09ed78cdb62d0dd27c04fc4fa5.png)

---

<div class="post-metadata">

**Author:** ![Christophe\_N](https://avatars.discourse-cdn.com/v4/letter/c/b5a626/32.png) [@Christophe\_N](https://community.dynatrace.com/u/Christophe_N)\
**Post date:** [September 17, 2021, 12:39pm UTC](https://community.dynatrace.com/t/user-session-query-language-for-plotting-response-time/32682/2 "2021-09-17T12:39:50Z")

</div>

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](https://global.discourse-cdn.com/dynatrace/original/3X/2/a/2a2cd4d0ab34be1bb19dc5552c434b0992a20d15.png)
