Skip to main content
Returns the discrete kth percentile value of a column Category: aggregate Syntax:
PercentileDisc([column], k)
Returns: Float Context Filtering: ✗ No

Parameters

NameTypeRequiredDescription
columncolumn✓ YesThe numeric column to search
knumber✓ YesPercent between 0 and 1
Allowed Column Types for column: INT, FLOAT, DECIMAL

Validation

  • Minimum parameters: 2
  • Maximum parameters: 2

Examples

PercentileDisc([Score], 0.7)
Returns the discrete 70th percentile
Last modified on March 13, 2026