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?
How about choosing MAX aggregation?
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.
I agree with Wolfgang. I would say:
0 Percentile = Min
100 Percentile = Max
50 Percentile = Median