cume_dist
Find the fraction of rows whose sort value is less than or equal to the current value.
Try an expression
In Formula, enter the expression and set Output type to DOUBLE.
Example input
- Row 1
id = 1, amount = 10 - Row 2
id = 2, amount = NULL - Row 3
id = 3, amount = 30 - Row 4
id = 4, amount = 30
Expression
cume_dist() OVER (ORDER BY amount)Result
Row 1: 0.25
Row 2: 1.0
Row 3: 0.75
Row 4: 0.75NULL means the value is missing.
Arguments and types
cume_dist([ORDER BY ordering])The result type can depend on the input types. See DuckDB for the full argument rules.
Things to know
ORDER BY defines the order used by the calculation; it doesn't sort the output table. Include a unique tie-breaker when row position matters. Window expressions belong in Formula and can't be entered directly in Filter.
Function metadata from DuckDB, used under the MIT license.