PercentileApprox

Description

PercentileApprox returns an approximate percentile value for a numeric field or expression.

Syntax

PercentileApprox(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

PercentileApprox(SalesAmount, 0.9)

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