Histogram with Percentiles, Mode, Mean and Median

Hi,

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:

Cache(NonZero(Percentile(
Filter(
Descendants([Issue].CurrentMember, [Issue].[Issue]),
DateInPeriod(
[Measures].[Issue resolution date],
[Time].CurrentHierarchyMember
)),
CASE WHEN [Measures].[Issues resolved] > 0
THEN
NonZero(([Measures].[Days in transition status],
[Transition Status].[Fluxo Customer lead time],
[Status.Category].[Done],
[Time].CurrentHierarchy.DefaultMember))
END
, 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