QUANTILE_APPROX

Syntax

QUANTILE_APPROX( value, quant )
        
QUANTILE_APPROX( value, quant
                         [ FIXED ... | INCLUDE ... | EXCLUDE ... ]
                         [ BEFORE FILTER BY ... ]
                       )

More info:

Description

Returns the approximate quant-level quantile (quant should be in range from 0 to 1).

Argument types:

  • value — Date | Datetime | Fractional number | Integer
  • quant — Fractional number | Integer

Return type: Same type as (value)

Data source support

ClickHouse 21.8, Files, Google Sheets, Yandex Documents.

Previous
QUANTILE
Next
STDEV