percentile_rank

This function calculates the percentile rank for each non-null value in a single-valued numeric or date column. Percentile ranks are assigned based on the relative position of each value in the sorted column, with results ranging [0, 1). Null values are preserved and do not affect the ranking. The function does not support multi-valued columns.

percentile_rank(input: number, {
    "param": value,
    ...
}) -> (output: number)