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

using USQL how to show the duration in Seconds?

sureshKumarK
Helper

Hi, please let me know converting duration from ms to seconds is doable using USQL? since the results showing in ms it's not making sense while plotting the chart with Error count/user action count and duration on same axis. it would be nice if I can convert the duration to seconds.

 

y axis shows in millions (as duration is in ms)

2 REPLIES 2

JamesKitson
Dynatrace Guru
Dynatrace Guru

Idea is to be able to do this using mathematical operations which are available now but don't seem to be available for aggregate functions yet. Looks like it's planned to be included but no ETA.

https://www.dynatrace.com/support/help/shortlink/usql-info#mathematical-operations

Erin_Scot
Dynatrace Advocate
Dynatrace Advocate

Very late to this, but in case someone comes to this via a search, as I did: The math function does work now. I'm not certain when it was updated, but you can use something like "duration/1000/60," as shown above, and the system will do the math for you and put it in your results. 

Erin_Scot_0-1654109523759.png

 

Featured Posts