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)