PercentileDisc
The PercentileDisc function calculates the discrete kth percentile value for a column or group. It returns the percent of the total frequency under that number, demonstrating the relative position of the value compared to the entire set of data.
The PercentileDisc function is an aggregate function.
Aggregate functions evaluate one or more rows of data and return a single value.
In a table element, the aggregate is calculated for each grouping. For information on how to add a grouping with an aggregate calculation to a table, see Group columns in a table.
In a table with no groupings, the aggregate is calculated for each row. For information on how to calculate summary statistics across all rows in a table, see Add summary statistics to a table.
To learn more about using aggregate functions, see Building complex formulas with grouped data.
Syntax
PercentileDisc(column, k)
The function has the following arguments:
- column
- Required
- The column to search.
- k
- Required
- A number between
0and1, which corresponds to the percent of data below that number. 0 < k < 1
Example
PercentileDisc([Score], 0.7)If the column [Score] contains values 2, 4, 6, 8, and 10, returns 8 when used in a table summary.
Updated 13 days ago