cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Get USQL duration results in Seconds or minutes

service_apms2
Participant

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


Thanks

6 REPLIES 6

ChadTurner
Guru

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.

-Chad

alonso_decosio
Dynatrace Advisor
Dynatrace Advisor

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

HTH

Alonso

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

Dynatrace can use metric AVG and use mathematic?

"SELECT AVG(duration/1000) FROM usersession"

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

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