Histogram with Percentiles, Mode, Mean and Median


I would like to create a Histogram with Percentiles, Mode, Mean and Median.
I used the forum thread below to create the histogram:

I tried to use the topic below to create the Percentiles, but it didn’t work, as shown in the image:

The correct value of the 50th percentile is 5.

Hi @Kleber_Rocha,

Could you please send the formula you use for calculating the percentile?

Lauma / support@eazybi.com

Hi @lauma.cirule,

Here’s the formula:

Descendants([Issue].CurrentMember, [Issue].[Issue]),
[Measures].[Issue resolution date],
CASE WHEN [Measures].[Issues resolved] > 0
NonZero(([Measures].[Days in transition status],
[Transition Status].[Fluxo Customer lead time],
, 50 )

Hi @Kleber_Rocha,

I’m sorry, I can’t see where the problem could be quite yet. Could you please send exported report definition (Create reports) to support@eazybi.com? Add the link to this community post and notify that you discussed this with Lauma.

Lauma / support@eazybi.com