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

USQL duration/1000 doesnt give decimal value for seconds

SachinJindal
Helper

Hi Team,

 

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

SachinJindal_0-1678654047067.png

 

 

2 REPLIES 2

Rugiewit
Dynatrace Enthusiast
Dynatrace Enthusiast

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

SachinJindal
Helper

Featured Posts