{"id":2720,"date":"2023-07-21T00:54:50","date_gmt":"2023-07-21T00:54:50","guid":{"rendered":"https:\/\/statorials.org\/id\/kelompok-mongodb-berdasarkan-jumlah\/"},"modified":"2023-07-21T00:54:50","modified_gmt":"2023-07-21T00:54:50","slug":"kelompok-mongodb-berdasarkan-jumlah","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/kelompok-mongodb-berdasarkan-jumlah\/","title":{"rendered":"Mongodb: cara mengelompokkan berdasarkan dan menjumlahkan"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan sintaks berikut untuk mengelompokkan dan menghitung di MongoDB:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>db.collection.aggregate([\n    { <span style=\"color: #ff0000;\">$group<\/span> : { <span style=\"color: #3366ff;\">_id<\/span> : \" <span style=\"color: #ff0000;\">$field_name1<\/span> \", <span style=\"color: #3366ff;\">count<\/span> :{ <span style=\"color: #3366ff;\">$sum<\/span> : \" <span style=\"color: #ff0000;\">$field_name2<\/span> \"}}}\n])<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa <span style=\"padding: 1px; border: 1px solid black;\">nama_bidang1<\/span> adalah bidang yang ingin Anda kelompokkan dan <span style=\"padding: 1px; border: 1px solid black;\">nama_bidang2<\/span> adalah bidang yang ingin Anda jumlahkan.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut memperlihatkan cara menggunakan sintaksis ini dengan <span style=\"padding: 1px; border: 1px solid black;\">tim<\/span> koleksi dengan dokumen berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>db.teams.insertOne({team: \" <span style=\"color: #008000;\">Mavs<\/span> \", position: \" <span style=\"color: #008000;\">Guard<\/span> \", points: <span style=\"color: #ff0000;\">31<\/span> })<\/strong>\n<strong>db.teams.insertOne({team: \" <span style=\"color: #008000;\">Spurs<\/span> \", position: \" <span style=\"color: #008000;\">Forward<\/span> \", points: <span style=\"color: #ff0000;\">22<\/span> })<\/strong>\n<strong>db.teams.insertOne({team: \" <span style=\"color: #008000;\">Rockets<\/span> \", position: \" <span style=\"color: #008000;\">Center<\/span> \", points: <span style=\"color: #ff0000;\">19<\/span> })<\/strong>\n<strong>db.teams.insertOne({team: \" <span style=\"color: #008000;\">Warriors<\/span> \", position: \" <span style=\"color: #008000;\">Forward<\/span> \", points: <span style=\"color: #ff0000;\">26<\/span> })<\/strong>\n<strong>db.teams.insertOne({team: \" <span style=\"color: #008000;\">Cavs<\/span> \", position: \" <span style=\"color: #008000;\">Guard<\/span> \", points: <span style=\"color: #ff0000;\">33<\/span> })<\/strong><\/pre>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 1: mengelompokkan berdasarkan dan menjumlahkan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan kode berikut untuk mengelompokkan berdasarkan kolom \u201cposisi\u201d dan menghitung jumlah poin untuk setiap posisi.<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>db.teams.aggregate([\n    { <span style=\"color: #ff0000;\">$group<\/span> : { <span style=\"color: #3366ff;\">_id<\/span> : \" <span style=\"color: #ff0000;\">$position<\/span> \", <span style=\"color: #3366ff;\">count<\/span> :{ <span style=\"color: #3366ff;\">$sum<\/span> : \" <span style=\"color: #ff0000;\">$points<\/span> \"}}}\n])\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Ini mengembalikan hasil berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>{ _id: ' <span style=\"color: #008000;\">Forward<\/span> ', count: 48 }\n{ _id: ' <span style=\"color: #008000;\">Guard<\/span> ', count: 64 }\n{ _id: ' <span style=\"color: #008000;\">Center<\/span> ', count: 19 }<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Ini memberitahu kita:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Pemain di posisi \u201cPenyerang\u201d memiliki total <strong>48<\/strong> poin.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Pemain dengan posisi \u201cPenjaga\u201d memiliki total <b>64<\/b> poin.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Pemain di posisi \u201cTengah\u201d memiliki total <b>19<\/b> poin.<\/span><\/li>\n<\/ul>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 2: kelompokkan berdasarkan dan tambahkan (lalu urutkan)<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan kode berikut untuk mencari jumlah poin untuk setiap posisi dan secara otomatis mengurutkan hasilnya dalam <strong>urutan menaik<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>db.teams.aggregate([\n    { <span style=\"color: #ff0000;\">$group<\/span> : { <span style=\"color: #3366ff;\">_id<\/span> : \" <span style=\"color: #ff0000;\">$position<\/span> \", <span style=\"color: #3366ff;\">count<\/span> :{ <span style=\"color: #3366ff;\">$sum<\/span> : \" <span style=\"color: #ff0000;\">$points<\/span> \"}}},\n    { <span style=\"color: #ff0000;\">$sort<\/span> : { <span style=\"color: #3366ff;\">count<\/span> : 1}} \n])\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Ini mengembalikan hasil berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>{ _id: ' <span style=\"color: #008000;\">Center<\/span> ', count: 19 }\n{ _id: ' <span style=\"color: #008000;\">Forward<\/span> ', count: 48 }\n{ _id: ' <span style=\"color: #008000;\">Guard<\/span> ', count: 64 }<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Hasilnya diurutkan berdasarkan poin dalam <strong>urutan menaik<\/strong> (dari yang terkecil hingga yang terbesar).<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan <strong>-1<\/strong> dalam argumen count untuk mengurutkan hasil dalam <strong>urutan menurun<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>db.teams.aggregate([\n    { <span style=\"color: #ff0000;\">$group<\/span> : { <span style=\"color: #3366ff;\">_id<\/span> : \" <span style=\"color: #ff0000;\">$position<\/span> \", <span style=\"color: #3366ff;\">count<\/span> :{ <span style=\"color: #3366ff;\">$sum<\/span> : \" <span style=\"color: #ff0000;\">$points<\/span> \"}}},\n    { <span style=\"color: #ff0000;\">$sort<\/span> : { <span style=\"color: #3366ff;\">count<\/span> :-1}} \n])\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Ini mengembalikan hasil berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>{ _id: ' <span style=\"color: #008000;\">Guard<\/span> ', count: 64 }\n{ _id: ' <span style=\"color: #008000;\">Forward<\/span> ', count: 48 }\n{ _id: ' <span style=\"color: #008000;\">Center<\/span> ', count: 19 }<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa hasilnya diurutkan berdasarkan titik dalam <strong>urutan menurun<\/strong> (dari terbesar ke terkecil).<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Anda dapat menemukan dokumentasi lengkap untuk <strong>$group<\/strong> <a href=\"https:\/\/docs.mongodb.com\/manual\/reference\/operator\/aggregation\/group\/\" target=\"_blank\" rel=\"noopener\">di sini<\/a> .<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan operasi umum lainnya di MongoDB:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/akun-terpisah-mongodb\/\" target=\"_blank\" rel=\"noopener\">MongoDB: Cara menghitung nilai berbeda dalam suatu bidang<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/grup-mongodb-berdasarkan-beberapa-bidang\/\" target=\"_blank\" rel=\"noopener\">MongoDB: Cara mengelompokkan berdasarkan beberapa bidang<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/kelompok-mongodb-berdasarkan-nomor\/\" target=\"_blank\" rel=\"noopener\">MongoDB: Cara mengelompokkan dan menghitung<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan sintaks berikut untuk mengelompokkan dan menghitung di MongoDB: db.collection.aggregate([ { $group : { _id : &#8221; $field_name1 &#8220;, count :{ $sum : &#8221; $field_name2 &#8220;}}} ]) Perhatikan bahwa nama_bidang1 adalah bidang yang ingin Anda kelompokkan dan nama_bidang2 adalah bidang yang ingin Anda jumlahkan. Contoh berikut memperlihatkan cara menggunakan sintaksis ini dengan tim [&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>MongoDB: Cara mengelompokkan dan menambahkan - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengelompokkan dan menjumlahkan di MongoDB, beserta contohnya.\" \/>\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\/kelompok-mongodb-berdasarkan-jumlah\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MongoDB: Cara mengelompokkan dan menambahkan - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengelompokkan dan menjumlahkan di MongoDB, beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/kelompok-mongodb-berdasarkan-jumlah\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-21T00:54:50+00:00\" \/>\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=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/kelompok-mongodb-berdasarkan-jumlah\/\",\"url\":\"https:\/\/statorials.org\/id\/kelompok-mongodb-berdasarkan-jumlah\/\",\"name\":\"MongoDB: Cara mengelompokkan dan menambahkan - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-21T00:54:50+00:00\",\"dateModified\":\"2023-07-21T00:54:50+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengelompokkan dan menjumlahkan di MongoDB, beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/kelompok-mongodb-berdasarkan-jumlah\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/kelompok-mongodb-berdasarkan-jumlah\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/kelompok-mongodb-berdasarkan-jumlah\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Mongodb: cara mengelompokkan berdasarkan dan menjumlahkan\"}]},{\"@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":"MongoDB: Cara mengelompokkan dan menambahkan - Statologi","description":"Tutorial ini menjelaskan cara mengelompokkan dan menjumlahkan di MongoDB, beserta contohnya.","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\/kelompok-mongodb-berdasarkan-jumlah\/","og_locale":"id_ID","og_type":"article","og_title":"MongoDB: Cara mengelompokkan dan menambahkan - Statologi","og_description":"Tutorial ini menjelaskan cara mengelompokkan dan menjumlahkan di MongoDB, beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/kelompok-mongodb-berdasarkan-jumlah\/","og_site_name":"Statorials","article_published_time":"2023-07-21T00:54:50+00:00","author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/kelompok-mongodb-berdasarkan-jumlah\/","url":"https:\/\/statorials.org\/id\/kelompok-mongodb-berdasarkan-jumlah\/","name":"MongoDB: Cara mengelompokkan dan menambahkan - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-21T00:54:50+00:00","dateModified":"2023-07-21T00:54:50+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengelompokkan dan menjumlahkan di MongoDB, beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/kelompok-mongodb-berdasarkan-jumlah\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/kelompok-mongodb-berdasarkan-jumlah\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/kelompok-mongodb-berdasarkan-jumlah\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Mongodb: cara mengelompokkan berdasarkan dan menjumlahkan"}]},{"@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\/2720"}],"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=2720"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2720\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2720"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2720"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2720"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}