All eazyBI for Jira eazyBI for Confluence Private eazyBI

Percentile

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

Syntax

Percentile(Set_Expression, Numeric_Expression, Percentile_Numeric_Expression)

Arguments

Set_ExpressionMDX expression that returns a set.
Numeric_ExpressionMDX expression that returns a number.

Percentile_Numeric_Expression

MDX expression that returns a number from 0 to 100 representing a percentile.

Examples

The following example calculates 75 percentile of resolution days for resolved issues in a 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