All eazyBI for Jira eazyBI for Confluence Private eazyBI

Percentile

Returns the value of the tuple that is at a given percentile of a set.

Syntax

 Percentile( Set_Expression , Numeric_Expression , Numeric_Expression )

Arguments

Set_Expression
MDX expression that returns a set.
Numeric_Expression
MDX expression that returns a number.
Numeric_Expression
MDX expression that returns a number representing a percentile

Examples

The following example calculates 75 percentile of resolution days for resolved issues in period:

Percentile(Filter(
  Descendants([Issue].CurrentMember, [Issue].[Issue]),
    DateInPeriod(
      [Issue].CurrentHierarchyMember.Get('Resolved at'),
      [Time].CurrentHierarchyMember)
   ),
   [Measures].[Total resolution days],
   75
)

See Also

Example report: https://eazybi.com/accounts/1000/cubes/Issues/reports/146245-control-chart-cycle-time