The PercentileCont function calculates the continuous k-th percentile value for a column or group.


PercentileCont(column, k)

Function arguments:

  • column (required) - The column of numbers to search.
  • k (required) - Percentile fraction between 0 and 1.

Interpolation is done between adjacent values if needed.


PercentileCont([Score], 0.7)
  • Calculates the 70th percentile of the Score column. If the column values are 2, 4, 6, 8, and 10, the result would be 7.6.

Related Functions

Was this page helpful?
Yes No