03 Nov 2020 08:32 AM - last edited on 16 Oct 2023 03:16 PM by random_user
I commented in https://community.dynatrace.com/spaces/483/dynatrace-product-ideas/idea/246168/rfe-9999-percentile-d... about percentile 100, by definition the largest value in an ordered list. Dynatrace supports it in USQL:
It does not seem to support it, at least in custom charts:
In custom charts, a maximum is supported in some graphs, so that's a good replacement.
How is percentile 100 supported in other places of the platform? Could it be treated in an uniform way? The same for percentile 0?
03 Nov 2020 09:38 AM
How about choosing MAX aggregation?
03 Nov 2020 02:31 PM
Yes, I really have always used MAX aggregation, and I referenced it in my comments. I also understand that it's a much more difficult calculation than plain simple MIN/MAX. But it would be great to have some uniformity in the platform... Also, I put in the question because of the RFE that I linked to, and I believe it would be great for it to be possible to handle floating point percentiles, like USQL.
03 Nov 2020 02:21 PM
I agree with Wolfgang. I would say:
0 Percentile = Min
100 Percentile = Max
50 Percentile = Median