# Get USQL duration results in Seconds or minutes

**URL:** <https://community.dynatrace.com/t/get-usql-duration-results-in-seconds-or-minutes/20309>\
**Category:** Real User Monitoring\
**Tags:** usql\
**Created:** [September 15, 2020, 4:04pm UTC](https://community.dynatrace.com/t/get-usql-duration-results-in-seconds-or-minutes/20309 "2020-09-15T16:04:16Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![service\_apms](https://avatars.discourse-cdn.com/v4/letter/s/c4cdca/32.png) [@service\_apms](https://community.dynatrace.com/u/service_apms)\
**Post date:** [September 15, 2020, 4:04pm UTC](https://community.dynatrace.com/t/get-usql-duration-results-in-seconds-or-minutes/20309/1 "2020-09-15T16:04:16Z")

</div>

Hello is there a way to get USQL duration results in Seconds or Minutes instead of “ms”

Thanks

---

<div class="post-metadata">

**Author:** ![ChadTurner](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/chadturner/32/161_2.png) [@ChadTurner](https://community.dynatrace.com/u/ChadTurner)\
**Post date:** [September 15, 2020, 6:52pm UTC](https://community.dynatrace.com/t/get-usql-duration-results-in-seconds-or-minutes/20309/2 "2020-09-15T18:52:51Z")

</div>

I dont think you can set that in the UI as it will automatically set it as ms/S/Min and so on. You do however have the flexibility to adjust this data in some of the custom charts.

---

<div class="post-metadata">

**Author:** ![alonso\_decosio](https://avatars.discourse-cdn.com/v4/letter/a/bbe5ce/32.png) [@alonso\_decosio](https://community.dynatrace.com/u/alonso_decosio)\
**Post date:** [September 15, 2020, 8:20pm UTC](https://community.dynatrace.com/t/get-usql-duration-results-in-seconds-or-minutes/20309/3 "2020-09-15T20:20:07Z")

</div>

You can modify the resolution of a metric in USQL by manually entering the conversion logic in your query.

 ![26632-screen-shot-2020-09-15-at-41111-pm.png](https://global.discourse-cdn.com/dynatrace/original/3X/9/c/9c4a35fd7dc4b146b9582bd2c8046a9161cefd78.png)

HTH

Alonso

---

<div class="post-metadata">

**Author:** ![service\_apms](https://avatars.discourse-cdn.com/v4/letter/s/c4cdca/32.png) [@service\_apms](https://community.dynatrace.com/u/service_apms)\
**Post date:** [September 16, 2020, 6:10am UTC](https://community.dynatrace.com/t/get-usql-duration-results-in-seconds-or-minutes/20309/4 "2020-09-16T06:10:22Z")

</div>

Great idea  
i think i’ll try that, thanks a lot

---

<div class="post-metadata">

**Author:** ![AskMe-Solutions](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/askme-solutions/32/33154_2.png) [@AskMe-Solutions](https://community.dynatrace.com/u/AskMe-Solutions)\
**Post date:** [July 19, 2021, 3:22am UTC](https://community.dynatrace.com/t/get-usql-duration-results-in-seconds-or-minutes/20309/5 "2021-07-19T03:22:22Z")

</div>

Dynatrace can use metric AVG and use mathematic?

“SELECT AVG(duration/1000) FROM usersession”

---

<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, 3:16pm UTC](https://community.dynatrace.com/t/get-usql-duration-results-in-seconds-or-minutes/20309/6 "2021-09-14T15:16:38Z")

</div>

[@AskMe-Solutions](https://community.dynatrace.com/user/30862)&nbsp; I’ve tried this but it doesn’t work for me. Have you found out any solution to this?

---

<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, 3:19pm UTC](https://community.dynatrace.com/t/get-usql-duration-results-in-seconds-or-minutes/20309/7 "2021-09-14T15:19:06Z")

</div>

[@alonso\_decosio](https://community.dynatrace.com/user/20403)&nbsp;This is great but the mathematics operation does not work in this case. for example the below 2 queries doesn’t work. do you have a solution for this?

```markup
SELECT name, startTime, AVG(duration/1000) as "Duration in Sec" FROM useraction

SELECT name, startTime, (duration/1000) as "Duration in Sec" FROM useraction
WHERE name = "loading of page /myPage" 
GROUP BY name, startTime, duration
This says - "Math Operations" can not be accessed when using "GROUP BY"!

```

---

<div class="post-metadata">

**Author:** ![pahofmann](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/pahofmann/32/17076_2.png) [@pahofmann](https://community.dynatrace.com/u/pahofmann)\
**Post date:** [October 14, 2024, 10:30am UTC](https://community.dynatrace.com/t/get-usql-duration-results-in-seconds-or-minutes/20309/8 "2024-10-14T10:30:58Z")

</div>

I stumbled over this today, is this really still not possible?

If I use AVG(DURATION) i can’t divide it to get seconds or minutes, so it displays a session time of 20712ms, which isn’t really great for readability.

---

<div class="post-metadata">

**Author:** ![Malaik](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/malaik/32/32673_2.png) [@Malaik](https://community.dynatrace.com/u/Malaik)\
**Post date:** [June 4, 2026, 1:20pm UTC](https://community.dynatrace.com/t/get-usql-duration-results-in-seconds-or-minutes/20309/9 "2026-06-04T13:20:54Z")

</div>

Hi

Did you get a chance to find a solution for that? (after this long time :-D)

I’m looking for similar view, as im not able to do mathematical calculation with distinct or aggregated data…

Thanks
