New to custom formulas need help updating

Questions & Answers
1

This is nit giving the correct 95% result

CatchException(
CASE WHEN [Measures].[95th Percentile] = 0 THEN 0
WHEN NOT IsEmpty([Measures].[95th Percentile]) THEN
[Measures].[95th Percentile] /
ConstantColumnValue(Sum(TotalRowsSet(), [Measures].[95th Percentile]))
END
)

Support gave me this but not clear how to apply

Percentile( Filter( Descendants([Issue].CurrentHierarchyMember, [Issue].[Issue]), [Measures].[YOUR MEASURE] > 0 ), [Measures].[YOUR MEASURE], 95 )

2

Hi @WGunkel
It seems like you’re trying to calculate the 95th percentile. I can’t comment on your percentile formula since the “95th Percentile” is not a predefined measure in eazyBI, which means the formula you provided is incomplete. From what you shared, it appears that your current formula is dividing the 95th percentile by the sum of all percentiles, which will not yield the correct 95th percentile value.

The formula I shared in the support email is a template where you need to replace [YOUR MEASURE] with the specific measure for which you want to calculate the 95th percentile.

For instance, if you’re calculating the 95th percentile of resolution days, your formula would look like this:

Percentile(
  Filter(
    Descendants([Issue].CurrentHierarchyMember, [Issue].[Issue]),
    [Measures].[Total resolution days] > 0
  ),
  [Measures].[Total resolution days],
  95
)

This formula:

  1. Filters all issues with total resolution days
  2. Calculates the 95th percentile of the “Total resolution days” measure
  3. Returns the value at that percentile

Kind regards,
Gerda // support@eazybi.com