topic Re: using USQL how to show the duration in Seconds? in Real User Monitoring

using USQL how to show the duration in Seconds?

sureshKumarK — Mon, 26 Apr 2021 15:09:43 GMT

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)

Re: using USQL how to show the duration in Seconds?

JamesKitson — Tue, 28 Apr 2020 22:10:33 GMT

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

Re: using USQL how to show the duration in Seconds?

Erin_Scot — Wed, 01 Jun 2022 18:53:25 GMT

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.