03 Nov 2020 12:32 AM - last edited on 18 Oct 2022 03:16 AM by MaciejNeumann
I commented in https://answers.dynatrace.com/spaces/483/dynatrace-product-ideas/idea/246168/rfe-9999-percentile-dat... 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