- last edited on by
MaciejNeumann
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)
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
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.
Featured Posts
