percentile

Calculates the specified percentile of a numeric column.

Spec

percentile(arg0, percentile_value)

Parameters

arg0 - A numeric column.
percentile_value - A double between 0 and 100.

Return Value

A double: the interpolated percentile value.

Example

datatable(val:double)[1.0, 2.0, 3.0, 4.0, 5.0]
| summarize median = percentile(val, 50)

median
3.0