quantileExactWeighted

    To get exact value, all the passed values ​​are combined into an array, which is then partially sorted. Each value is counted with its weight, as if it is present times. A hash table is used in the algorithm. Because of this, if the passed values ​​are frequently repeated, the function consumes less RAM than quantileExact. You can use this function instead of quantileExact and specify the weight 1.

    When using multiple quantile* functions with different levels in a query, the internal states are not combined (that is, the query works less efficiently than it could). In this case, use the function.

    Syntax

    Arguments

    • — Level of quantile. Optional parameter. Constant floating-point number from 0 to 1. We recommend using a level value in the range of [0.01, 0.99]. Default value: 0.5. At level=0.5 the function calculates median.
    • — Expression over the column values resulting in numeric , Date or .

    Returned value

    • Quantile of the specified level.

    Type:

    • Float64 for numeric data type input.
    • if input values have the DateTime type.

    Input table:

    Query:

    Result: