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

uSQL - format or round avg(duration) to 4 decimals

Conal_Buchanan1
Participant

A client has a uSQL query that they export via api and import to database.

The database rejects some floating point data from the raw json like 3411.3333333333335.

We would like to be able to change the query so that

 

select avg(duration)

 

formats to a column definition limit of say 4 decimal places.

Maybe I've missed it but is there a user session query equivalent to say something like?

 

select round(avg(duration), 4)

 

 

 

 

1 REPLY 1

ChadTurner
DynaMight Legend
DynaMight Legend

I don't see anything in terms of rounding. Granted in the data explorer we have the ability to add/remove decimal places. But that's not applicable in the USQL segment. https://www.dynatrace.com/support/help/platform-modules/digital-experience/session-segmentation/cust... 

 

Great candidate for an RFE tho! 

-Chad

Featured Posts