topic Re: Get USQL duration results in Seconds or minutes in Real User Monitoring

Get USQL duration results in Seconds or minutes

service_apms2 — Tue, 15 Sep 2020 16:04:16 GMT

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

Thanks

Re: Get USQL duration results in Seconds or minutes

ChadTurner — Tue, 15 Sep 2020 18:52:51 GMT

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.

Re: Get USQL duration results in Seconds or minutes

alonso_decosio — Tue, 15 Sep 2020 20:20:07 GMT

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

HTH

Alonso

Re: Get USQL duration results in Seconds or minutes

service_apms2 — Wed, 16 Sep 2020 06:10:22 GMT

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

Re: Get USQL duration results in Seconds or minutes

AskMe-Solutions — Mon, 19 Jul 2021 03:22:22 GMT

Dynatrace can use metric AVG and use mathematic?

"SELECT AVG(duration/1000) FROM usersession"

Re: Get USQL duration results in Seconds or minutes

shashank_b_agra — Tue, 14 Sep 2021 15:16:38 GMT

@AskMe-Solutions I've tried this but it doesn't work for me. Have you found out any solution to this?

Re: Get USQL duration results in Seconds or minutes

shashank_b_agra — Tue, 14 Sep 2021 15:19:06 GMT

@alonso_decosio 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?

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"!

Re: Get USQL duration results in Seconds or minutes

pahofmann — Mon, 14 Oct 2024 10:30:58 GMT

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.