{"id":1694,"date":"2023-07-25T08:45:23","date_gmt":"2023-07-25T08:45:23","guid":{"rendered":"https:\/\/statorials.org\/id\/grup-kueri-google-sheet-menurut\/"},"modified":"2023-07-25T08:45:23","modified_gmt":"2023-07-25T08:45:23","slug":"grup-kueri-google-sheet-menurut","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/grup-kueri-google-sheet-menurut\/","title":{"rendered":"Kueri google spreadsheet: cara menggunakan grup menurut"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan sintaks berikut untuk mengelompokkan dan menggabungkan data dalam kueri Google Spreadsheet:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" string \" dir=\"auto\"><span class=\" default-formula-text-color\" dir=\"auto\">=<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">query<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">(<\/span> <span dir=\"auto\" style=\"color: #ff9900;\">A1:D12<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">,<\/span> \" <span style=\"color: #008000;\">select B, avg(D) group by B<\/span> \" <span class=\" default-formula-text-color\" dir=\"auto\">,<\/span> <span class=\"number\" dir=\"auto\" style=\"color: #3366ff;\">1<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">)<\/span><\/span>\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Dalam contoh ini, kita memilih kolom <strong>B<\/strong> dan <strong>D<\/strong> dalam rentang sel <strong>A1:D12<\/strong> . Kami kemudian mencari rata-rata kolom <strong>D<\/strong> , dikelompokkan berdasarkan kolom <strong>B.<\/strong> Kami juga menentukan <strong>1<\/strong> untuk menunjukkan bahwa ada 1 baris header di bagian atas kumpulan data.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Dalam contoh ini, kita menggunakan fungsi agregat <strong>avg()<\/strong> , namun kita dapat menggunakan salah satu fungsi agregat berikut:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>rata-rata()<\/strong><\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>jumlah()<\/strong><\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>menghitung()<\/strong><\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>menit()<\/strong><\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>maksimum()<\/strong><\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara mengelompokkan dan menggabungkan data dalam praktiknya.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 1: mengelompokkan dan menggabungkan berdasarkan kolom<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan rumus berikut untuk memilih kolom Tim dan Poin, lalu mencari rata-rata kolom Poin yang dikelompokkan berdasarkan Tim:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-16701 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/agg1.png\" alt=\"\" width=\"646\" height=\"432\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Ini memberitahu kita bahwa:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Rata-rata poin yang dicetak pemain Cavs adalah <strong>10,8<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Rata-rata poin yang dicetak pemain Celtics adalah <strong>12,7<\/strong> .<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Dan seterusnya.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 2: mengelompokkan dan menggabungkan berdasarkan beberapa kolom<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan rumus berikut untuk memilih kolom Tim, Konferensi, dan Poin, lalu mencari kolom Poin maksimum yang dikelompokkan berdasarkan Tim dan Konferensi:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-16702 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/agg2.png\" alt=\"\" width=\"677\" height=\"416\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Ini memberitahu kita bahwa:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Poin terbanyak yang dicetak oleh pemain mana pun di tim Cavs di Wilayah Timur adalah <strong>13,4<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Poin terbanyak yang dicetak oleh pemain mana pun di tim Celtics di Wilayah Timur adalah <strong>22,4<\/strong> .<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Dan seterusnya.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Bagaimana menghindari #VALUE! Kesalahan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Untuk menghindari #VALUE! kesalahan saat mengelompokkan dan menggabungkan data, pastikan setiap kolom yang disertakan dalam pernyataan <strong>pemilihan<\/strong> memenuhi salah satu kriteria berikut:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Memiliki fungsi agregasi yang diterapkan padanya.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Termasuk dalam <strong>kelompok berdasarkan<\/strong> pernyataan.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Selama setiap kolom dalam pernyataan <strong>pilih<\/strong> memenuhi salah satu kriteria ini, maka Anda dapat menghindari kesalahan #VALUE! kesalahan.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <a href=\"https:\/\/statorials.org\/id\/kueri-google-sheet-pilih-beberapa-kolom\/\" target=\"_blank\" rel=\"noopener\">Kueri Google Spreadsheet: cara memilih beberapa kolom<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/berisi-kueri-google-sheets\/\" target=\"_blank\" rel=\"noopener\">Kueri Google Spreadsheet: pilih baris yang berisi string<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/permintaan-kueri-google-sheets-diurutkan-berdasarkan\/\" target=\"_blank\" rel=\"noopener\">Kueri Google Spreadsheet: Cara Menggunakan Sortir Berdasarkan<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan sintaks berikut untuk mengelompokkan dan menggabungkan data dalam kueri Google Spreadsheet: = query ( A1:D12 , &#8221; select B, avg(D) group by B &#8221; , 1 ) Dalam contoh ini, kita memilih kolom B dan D dalam rentang sel A1:D12 . Kami kemudian mencari rata-rata kolom D , dikelompokkan berdasarkan kolom B. [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Kueri Google Spreadsheet: Cara Menggunakan Grup Berdasarkan \u2013 Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan fungsi GROUP BY di Google Sheets Query, dengan beberapa contoh.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/statorials.org\/id\/grup-kueri-google-sheet-menurut\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Kueri Google Spreadsheet: Cara Menggunakan Grup Berdasarkan \u2013 Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan fungsi GROUP BY di Google Sheets Query, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/grup-kueri-google-sheet-menurut\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-25T08:45:23+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/agg1.png\" \/>\n<meta name=\"author\" content=\"Benjamin anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Ditulis oleh\" \/>\n\t<meta name=\"twitter:data1\" content=\"Benjamin anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/grup-kueri-google-sheet-menurut\/\",\"url\":\"https:\/\/statorials.org\/id\/grup-kueri-google-sheet-menurut\/\",\"name\":\"Kueri Google Spreadsheet: Cara Menggunakan Grup Berdasarkan \u2013 Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-25T08:45:23+00:00\",\"dateModified\":\"2023-07-25T08:45:23+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan fungsi GROUP BY di Google Sheets Query, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/grup-kueri-google-sheet-menurut\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/grup-kueri-google-sheet-menurut\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/grup-kueri-google-sheet-menurut\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Kueri google spreadsheet: cara menggunakan grup menurut\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/id\/#website\",\"url\":\"https:\/\/statorials.org\/id\/\",\"name\":\"Statorials\",\"description\":\"Panduan anda untuk kompetensi statistik!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/id\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"id\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\",\"name\":\"Benjamin anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/\",\"url\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Benjamin anderson\"},\"description\":\"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya\",\"sameAs\":[\"http:\/\/statorials.org\/id\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Kueri Google Spreadsheet: Cara Menggunakan Grup Berdasarkan \u2013 Statorial","description":"Tutorial ini menjelaskan cara menggunakan fungsi GROUP BY di Google Sheets Query, dengan beberapa contoh.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/statorials.org\/id\/grup-kueri-google-sheet-menurut\/","og_locale":"id_ID","og_type":"article","og_title":"Kueri Google Spreadsheet: Cara Menggunakan Grup Berdasarkan \u2013 Statorial","og_description":"Tutorial ini menjelaskan cara menggunakan fungsi GROUP BY di Google Sheets Query, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/grup-kueri-google-sheet-menurut\/","og_site_name":"Statorials","article_published_time":"2023-07-25T08:45:23+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/agg1.png"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/grup-kueri-google-sheet-menurut\/","url":"https:\/\/statorials.org\/id\/grup-kueri-google-sheet-menurut\/","name":"Kueri Google Spreadsheet: Cara Menggunakan Grup Berdasarkan \u2013 Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-25T08:45:23+00:00","dateModified":"2023-07-25T08:45:23+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan fungsi GROUP BY di Google Sheets Query, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/grup-kueri-google-sheet-menurut\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/grup-kueri-google-sheet-menurut\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/grup-kueri-google-sheet-menurut\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Kueri google spreadsheet: cara menggunakan grup menurut"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/id\/#website","url":"https:\/\/statorials.org\/id\/","name":"Statorials","description":"Panduan anda untuk kompetensi statistik!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/id\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"id"},{"@type":"Person","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81","name":"Benjamin anderson","image":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/","url":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Benjamin anderson"},"description":"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya","sameAs":["http:\/\/statorials.org\/id"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1694"}],"collection":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/comments?post=1694"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1694\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1694"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1694"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1694"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}