The PercentileDisc function returns the discrete k-th percentile value for a column or group.


PercentileDisc(column, k)

Function arguments:

  • column (required) - The column of numbers to be searched.
  • k (required) - The percentile fraction between 0 and 1.


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

See Also

Was this page helpful?
Yes No