Window

CUME_DIST

BigQuery

Menghitung cumulative distribution - proporsi baris dengan nilai kurang dari atau sama dengan baris saat ini.

Tipe hasil: FLOAT64Diperbarui: 7 Jan 2026

Syntax

SQL

CUME_DIST() OVER ([PARTITION BY partition_expression] ORDER BY sort_expression)

Parameter

ORDER BYexpressionwajib

Menentukan urutan

PARTITION BYexpressionopsional

Membagi data ke dalam grup (opsional)

Contoh Penggunaan

Cumulative Distribution

SQL

1 SELECT
2   name,
3   salary,
4   CUME_DIST() OVER (ORDER BY salary) as cumulative_dist,
5   PERCENT_RANK() OVER (ORDER BY salary) as percent_rank
6 FROM `project.dataset.employees`;

Perbandingan CUME_DIST vs PERCENT_RANK.

Hasil

name	salary	cumulative_dist	percent_rank
David	50000	0.25	0.0
Charlie	70000	0.50	0.333
Bob	90000	0.75	0.667
Alice	120000	1.0	1.0

Distribution Analysis

SQL

1 SELECT
2   product_id,
3   price,
4   CUME_DIST() OVER (ORDER BY price) as price_dist
5 FROM `project.dataset.products`
6 WHERE CUME_DIST() OVER (ORDER BY price) <= 0.5;

Produk di bawah median harga.

Fungsi Terkait

ROW_NUMBERRANKDENSE_RANKPERCENT_RANKNTILE

Kembali ke BigQuery Functions

1	SELECT
2	name,
3	salary,
4	CUME_DIST() OVER (ORDER BY salary) as cumulative_dist,
5	PERCENT_RANK() OVER (ORDER BY salary) as percent_rank
6	FROM `project.dataset.employees`;

1	SELECT
2	product_id,
3	price,
4	CUME_DIST() OVER (ORDER BY price) as price_dist
5	FROM `project.dataset.products`
6	WHERE CUME_DIST() OVER (ORDER BY price) <= 0.5;