Skip to main content
Returns the specified percentile value in the column Category: aggregate Syntax:
Percentile([column], percentile)
Returns: Float Context Filtering: ✗ No

Parameters

NameTypeRequiredDescription
columncolumn✓ YesThe numeric column to calculate percentile
percentilenumber✓ YesThe percentile to calculate (0-1)
Allowed Column Types for column: INT, FLOAT, DECIMAL

Validation

  • Minimum parameters: 2
  • Maximum parameters: 2

Examples

Percentile([Score], 0.95)
Returns the 95th percentile score
Last modified on March 13, 2026