Skip to content

Instantly share code, notes, and snippets.

@Sidd27

Sidd27/mongo-unique-count.js

Created September 12, 2019 10:18
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save Sidd27/95720b965c35513276fd13987d86a974 to your computer and use it in GitHub Desktop.
Save Sidd27/95720b965c35513276fd13987d86a974 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
mongo-unique-count.js
db.getCollection('companydetails').aggregate([
{ "$group": {
"_id": { "$toLower": "$state" },
"count": { "$sum": 1 }
} },
{ "$group": {
"_id": null,
"counts": {
"$push": { "k": "$_id", "v": "$count" }
}
} },
{ "$replaceRoot": {
"newRoot": { "$arrayToObject": "$counts" }
} }
])
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment