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)

1 REPLY 1

JamesKitson
Dynatrace Leader
Dynatrace Leader

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