topic Re: USQL duration/1000 doesnt give decimal value for seconds in Real User Monitoring

USQL duration/1000 doesnt give decimal value for seconds

SachinJindal — Sun, 12 Mar 2023 20:47:48 GMT

Hi Team,

i am not getting decimal value for the milliseconds time which is being converted into seconds.

Re: USQL duration/1000 doesnt give decimal value for seconds

DarkoA — Wed, 15 Mar 2023 15:20:08 GMT

Hey there,

I fear what you're encountering is a limitation of the USQL.
Because the value is returned as an integer value and is stored as ms (integers) in the database, when you perform a division, you're performing an integer calculation which will always round by default.
Don't think there is a workaround for this. Might need to make an RFE (request for enhancement) to see if Dynatrace should add some transformation function to the USQL to change the value from integer to float or double, so then it can be divided properly and have decimals displayed.

regards,
Darko

Re: USQL duration/1000 doesnt give decimal value for seconds

SachinJindal — Wed, 15 Mar 2023 17:31:52 GMT

Thanks Darko, have raised below one.

USQL duration/1000 doesnt give decimal value for seconds - Dynatrace Community