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. You can use the PercentileDisc function on BigQueryPostgreSQL, Databricks, Snowflake, Redshift, MySQL, and AlloyDB connections.

Syntax

PercentileDisc(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

A Score column contains values 2, 4, 6, 8, and 10.

PercentileDisc(\[Score\], 0.7)

  • The discrete 70th percentile of the Score column is 8. If a candidate scores in the 70th percentile, they have scored higher than 70% of test takers, putting them in the top 30%

Related resources