Returns the value of the tuple that is at a given percentile of a set.
Syntax
| Code Block |
|---|
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:
| Code Block |
|---|
Percentile(Filter( |
Descendants([Issue].CurrentMember, [Issue].[Issue]), |
[Issue].CurrentHierarchyMember.Get('Resolved at'), |
[Time].CurrentHierarchyMember) |
AND [Measures].[Issues resolved] > 0), |
[Measures].[Total resolution days], |
