15 Sep 2020 05:04 PM
Hello is there a way to get USQL duration results in Seconds or Minutes instead of "ms"
Thanks
Solved! Go to Solution.
15 Sep 2020 07:52 PM
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.
15 Sep 2020 09:20 PM
You can modify the resolution of a metric in USQL by manually entering the conversion logic in your query.
HTH
Alonso
16 Sep 2020 07:10 AM
Great idea
i think i'll try that, thanks a lot
19 Jul 2021 04:22 AM
Dynatrace can use metric AVG and use mathematic?
"SELECT AVG(duration/1000) FROM usersession"
14 Sep 2021 04:16 PM
@AskMe-Solutions I've tried this but it doesn't work for me. Have you found out any solution to this?
14 Sep 2021 04:19 PM
@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"!
14 Oct 2024 11:30 AM
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.