Calculates the cumulative distribution of a value within a partition, representing the relative position of each row based on the specified column’s values.
Category: window
Syntax:
Returns: Float
Context Filtering: ✗ No
Parameters
Validation
- Minimum parameters: 1
- Maximum parameters: 1
Examples
Returns the cumulative distribution of sales values. If 80% of rows have sales values less than or equal to the current row’s sales, this returns 0.8.
Calculates what fraction of all scores are less than or equal to each row’s score. A result of 0.95 means the row is in the 95th percentile.
Result: varies (values between 0.0 and 1.0)
- PercentRank - Calculates relative rank as percentage
- Rank - Assigns rank with gaps
- DenseRank - Assigns rank without gaps
- RowNumber - Assigns sequential row numbers
- Ntile - Divides rows into groups
Last modified on March 13, 2026
