Showing results for 
Show  only  | Search instead for 
Did you mean: 

Is there an uniform support for percentile 100?

DynaMight Guru
DynaMight Guru

I commented in 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?

Antonio Sousa

Dynatrace Leader
Dynatrace Leader

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.

Antonio Sousa

Dynatrace Champion
Dynatrace Champion

I agree with Wolfgang. I would say:

0 Percentile = Min

100 Percentile = Max

50 Percentile = Median

Featured Posts