Percentile

Description

Percentile returns the exact percentile value for a numeric field or expression.

Syntax

Percentile(value, percentile)

Parameters

Parameter	Required	Type	Description
value	Yes	Field or expression	Numeric values to evaluate.
percentile	Yes	Number	Percentile between 0 and 1.

Notes

Aggregate functions are commonly used in metric definitions and grouped query results.

Example

Percentile(SalesAmount, 0.9)

The expression returns the calculated result according to the current query context.