21 Jun 2023 02:52 PM
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)
07 Aug 2023 04:12 PM - edited 07 Aug 2023 04:12 PM
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!