approx_percentile_rank()

Since 1.0.0

Estimate the percentile at which a given value would be located.

Samples

Estimate the percentile rank of the value 99, given a sample containing the numbers from 0 to 100.

SELECT
  approx_percentile_rank(99, uddsketch(100, 0.001, data::double precision))
FROM generate_series(0, 100) data;

approx_percentile_rank
----------------------------
        0.9900990099009901

Arguments

The syntax is:

approx_percentile_rank(
  value DOUBLE PRECISION,
  sketch UddSketch
) RETURNS DOUBLE PRECISION

Name	Type	Default	Required	Description
value	DOUBLE PRECISION	-	✔	the value to estimate the percentile of
sketch	UddSketch	-	✔	the uddsketch aggregate

Returns

Column	Type	Description
approx_percentile_rank	DOUBLE PRECISION	The estimated percentile associated with the provided value.