Tetap teratur dengan koleksi
Simpan dan kategorikan konten berdasarkan preferensi Anda.
Menampilkan nilai median dari kumpulan angka.
Contoh penggunaan
MEDIAN(Page Views)
Sintaks
MEDIAN( X )
Parameter
X - kolom atau ekspresi angka.
Catatan
X tidak boleh berupa kolom teragregasi atau hasil dari fungsi agregasi.
MEDIAN menampilkan nilai tengah jika X berisi jumlah nilai ganjil. Jika X berisi jumlah nilai genap, MEDIAN akan melakukan interpolasi antara dua nilai tengah.
Contoh
Contoh formula
Input
Output
MEDIAN(Page Views)
95
100
92
95
MEDIAN(Page Views)
100
95
97,5
Catatan
Untuk sumber data BigQuery, MEDIAN diterapkan menggunakan fungsi APPROX_QUANTILES BigQuery. Menerapkan MEDIAN ke data yang berasal dari BigQuery mungkin memberikan hasil yang sedikit berbeda daripada menerapkan MEDIAN ke data yang sama yang berasal dari jenis sumber data lain.
[[["Mudah dipahami","easyToUnderstand","thumb-up"],["Memecahkan masalah saya","solvedMyProblem","thumb-up"],["Lainnya","otherUp","thumb-up"]],[["Sulit dipahami","hardToUnderstand","thumb-down"],["Informasi atau kode contoh salah","incorrectInformationOrSampleCode","thumb-down"],["Informasi/contoh yang saya butuhkan tidak ada","missingTheInformationSamplesINeed","thumb-down"],["Masalah terjemahan","translationIssue","thumb-down"],["Lainnya","otherDown","thumb-down"]],["Terakhir diperbarui pada 2025-07-31 UTC."],[],[],null,["# MEDIAN\n\nReturns the median value from a set of numbers.\n\nSample usage\n------------\n\n`MEDIAN(Page Views)`\n\nSyntax\n------\n\n`MEDIAN( `\u003cvar translate=\"no\"\u003eX\u003c/var\u003e` )`\n\n### Parameters\n\n- \u003cvar translate=\"no\"\u003eX\u003c/var\u003e - a numeric field or expression.\n\nNotes\n\n- \u003cvar translate=\"no\"\u003eX\u003c/var\u003e cannot be an aggregated field or the result of an aggregation function.\n- `MEDIAN` returns the center value if \u003cvar translate=\"no\"\u003eX\u003c/var\u003e contains an odd number of values. If \u003cvar translate=\"no\"\u003eX\u003c/var\u003e contains an even number of values, `MEDIAN` will interpolate between the two center values.\n\nExamples\n--------\n\nNotes\n-----\n\nFor BigQuery data sources, `MEDIAN` is implemented using the BigQuery [APPROX_QUANTILES](/bigquery/docs/reference/standard-sql/approximate_aggregate_functions#approx_quantiles) function. Applying `MEDIAN` to data coming from BigQuery may return slightly different results than applying `MEDIAN` to the same data coming from other data source types.\n\nRelated resources\n-----------------\n\n- [Calculated fields](/looker/docs/studio/about-calculated-fields)\n- [Looker Studio function list](/looker/docs/studio/function-list)"]]
