{"id":2393,"date":"2023-07-22T11:32:40","date_gmt":"2023-07-22T11:32:40","guid":{"rendered":"https:\/\/statorials.org\/id\/kelompok-mongodb-berdasarkan-nomor\/"},"modified":"2023-07-22T11:32:40","modified_gmt":"2023-07-22T11:32:40","slug":"kelompok-mongodb-berdasarkan-nomor","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/kelompok-mongodb-berdasarkan-nomor\/","title":{"rendered":"Mongodb: cara mengelompokkan dan menghitung"},"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_name<\/span> \", <span style=\"color: #3366ff;\">count<\/span> :{ <span style=\"color: #3366ff;\">$sum<\/span> :1}}}\n])<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa <span style=\"padding: 1px; border: 1px solid black;\">field_name<\/span> adalah bidang yang ingin Anda kelompokkan.<\/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;\">Guard<\/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 menghitung<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan kode berikut untuk mengelompokkan berdasarkan bidang \u201cposisi\u201d dan menghitung kemunculan 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> :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;\">Forward<\/span> ', count: 1 }\n{ _id: ' <span style=\"color: #008000;\">Guard<\/span> ', count: 3 }\n{ _id: ' <span style=\"color: #008000;\">Center<\/span> ', count: 1 }<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Ini memberitahu kita:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Posisi \u201cMaju\u201d muncul <strong>1<\/strong> kali.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Posisi \u201cPenjaga\u201d muncul <strong>3<\/strong> kali.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Posisi \u201cTengah\u201d muncul <strong>1<\/strong> kali.<\/span><\/li>\n<\/ul>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 2: mengelompokkan berdasarkan dan menghitung (lalu mengurutkan)<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan kode berikut untuk menghitung kemunculan 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> :1}}},\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;\">Forward<\/span> ', count: 1 }\n{ _id: ' <span style=\"color: #008000;\">Center<\/span> ', count: 1 }\n{ _id: ' <span style=\"color: #008000;\">Guard<\/span> ', count: 3 }\n<\/strong><\/pre>\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> :1}}},\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: 3 }\n{ _id: ' <span style=\"color: #008000;\">Forward<\/span> ', count: 1 }\n{ _id: ' <span style=\"color: #008000;\">Center<\/span> ', count: 1 }<\/strong><\/pre>\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\/kelompok-mongodb-berdasarkan-jumlah\/\" target=\"_blank\" rel=\"noopener\">MongoDB: Cara mengelompokkan berdasarkan dan menjumlahkan<\/a><br \/> <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><\/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_name &#8220;, count :{ $sum :1}}} ]) Perhatikan bahwa field_name adalah bidang yang ingin Anda kelompokkan. Contoh berikut memperlihatkan cara menggunakan sintaksis ini dengan tim koleksi dengan dokumen berikut: db.teams.insertOne({team: &#8221; Mavs &#8220;, position: &#8221; Guard [&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 menghitung - Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengelompokkan dan menghitung di MongoDB, termasuk 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-nomor\/\" \/>\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 menghitung - Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengelompokkan dan menghitung di MongoDB, termasuk contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/kelompok-mongodb-berdasarkan-nomor\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-22T11:32:40+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=\"1 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-nomor\/\",\"url\":\"https:\/\/statorials.org\/id\/kelompok-mongodb-berdasarkan-nomor\/\",\"name\":\"MongoDB: Cara mengelompokkan dan menghitung - Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-22T11:32:40+00:00\",\"dateModified\":\"2023-07-22T11:32:40+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengelompokkan dan menghitung di MongoDB, termasuk contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/kelompok-mongodb-berdasarkan-nomor\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/kelompok-mongodb-berdasarkan-nomor\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/kelompok-mongodb-berdasarkan-nomor\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Mongodb: cara mengelompokkan dan menghitung\"}]},{\"@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 menghitung - Statorial","description":"Tutorial ini menjelaskan cara mengelompokkan dan menghitung di MongoDB, termasuk 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-nomor\/","og_locale":"id_ID","og_type":"article","og_title":"MongoDB: Cara mengelompokkan dan menghitung - Statorial","og_description":"Tutorial ini menjelaskan cara mengelompokkan dan menghitung di MongoDB, termasuk contohnya.","og_url":"https:\/\/statorials.org\/id\/kelompok-mongodb-berdasarkan-nomor\/","og_site_name":"Statorials","article_published_time":"2023-07-22T11:32:40+00:00","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\/kelompok-mongodb-berdasarkan-nomor\/","url":"https:\/\/statorials.org\/id\/kelompok-mongodb-berdasarkan-nomor\/","name":"MongoDB: Cara mengelompokkan dan menghitung - Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-22T11:32:40+00:00","dateModified":"2023-07-22T11:32:40+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengelompokkan dan menghitung di MongoDB, termasuk contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/kelompok-mongodb-berdasarkan-nomor\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/kelompok-mongodb-berdasarkan-nomor\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/kelompok-mongodb-berdasarkan-nomor\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Mongodb: cara mengelompokkan dan menghitung"}]},{"@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\/2393"}],"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=2393"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2393\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2393"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2393"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2393"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}