Is there an uniform support for percentile 100?

[AntonioSousa]

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?

[wolfgang_beer]

How about choosing MAX aggregation?

[AntonioSousa]

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.

[dave_mauney]

I agree with Wolfgang. I would say:

0 Percentile = Min

100 Percentile = Max

50 Percentile = Median