PercentileCont

📘
This function isn't compatible with all data platform connections. To check if your connection supports it, see Supported data platforms and feature compatibility.

The PercentileCont function calculates the continuous k^th 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 PercentileCont 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

PercentileCont(column, k)

The function has the following arguments:

column: Required; The column to search.
k: Required; A number between 0 and 1, which corresponds to the percent of data below that number.; 0 < k < 1

Example

PercentileCont([Score], 0.7)

If the column [Score] contains values 2, 4, 6, 8, and 10, returns 7.6 when used in a table summary.