Support center for flex.bi version 4.0

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Current »

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)
    AND [Measures].[Issues resolved] > 0),
   [Measures].[Total resolution days],
   75
)

 

  • No labels