percentile

percentile(T.a : number; b : number) 🡒 number, aggregator

Returns the value below which the given percentage of observations in the group of observations falls. The second argument must be between 0 and 1 (inclusive).

table T = with
 [| as A |]
 [| 0 |]
 [| 0 |]
 [| 1 |]
 [| 2 |]

show summary "" a1a4 with
 percentile(T.A; 0.25)
 percentile(T.A; 0.50)
 percentile(T.A; 0.75)
 percentile(T.A; 1.0)

See also