percentile

statistics

Calculates the p-th percentile

Syntax

percentile(array|dataframe, p)

Parameters

array|dataframe (array or dataframe)

The data to calculate percentile from

p (number)

The percentile to calculate (between 0 and 1)

Returns

number

The value at the specified percentile

Examples

95th percentile response time
Input:
.response_time | percentile(0.95)
Output:
980
99th percentile revenue
Input:
.revenue | percentile(0.99)
Output:
125000

The percentile() function calculates the value at a specified percentile (p-th percentile) in your data. Percentiles divide the data into 100 equal parts.

Usage

Use percentile() for performance analysis, service level objectives (SLOs), and identifying threshold values in distributions.