Aggregate Functions
-
Date Functions
-
Math Functions
-
Operators
-
Text Functions
-
Window Functions
-
PercentileDisc
Find the discrete k-th percentile value for a column or group.
Usage
PercentileDisc(<number>,<k>)
number (required) The column of numbers to be searched.
k (required) Percentile fraction between 0 and 1.
Examples
PercentileDisc([Score], 0.7)
- If the column values are 2, 4, 6, 8, and 10, the result would be 8.
