Group by sum mongodb [duplicate]

by

You’re close, but you need to use a $sum operator to count the groupings:

db.users.aggregate([ { 
    $group: { 
        _id: "$status", 
        amt: { $sum: 1 }
    } 
} ] )

More Related Contents:

  1. Does MongoDB’s $in clause guarantee order
  2. Authentication failure while trying to save to mongodb
  3. Possibility of duplicate Mongo ObjectId’s being generated in two different collections?
  4. How to change the type of a field?
  5. MongoDB logging all queries
  6. Converting string to date in mongodb
  7. Querying internal array size in MongoDB
  8. MongoDB wildcard in the key of a query
  9. How to create a DB for MongoDB container on start up?
  10. How to access a preexisting collection with Mongoose?
  11. How to delete N numbers of documents in mongodb
  12. How do I query for distinct values in Mongoose?
  13. MongoDB field order and document position change after update
  14. MongoDB Full and Partial Text Search
  15. Difference between count() and find().count() in MongoDB
  16. How to insert an element to MongoDB internal list?
  17. Hierarchical queries with Mongo using $graphLookup
  18. Remove embedded document in a nested array of documents
  19. Find all documents within last n days
  20. Unable to create/open lock file: /data/mongod.lock errno:13 Permission denied
  21. Search on multiple collections in MongoDB
  22. Image returned from REST API always displays broken
  23. MongoDB: Server has startup warnings ”Access control is not enabled for the database”
  24. Mongo group and push: pushing all fields
  25. How to stop insertion of Duplicate documents in a mongodb collection
  26. Filtering embedded documents in MongoDB
  27. Remove multiple documents from mongo in a single query
  28. MongoDB on Ubuntu won’t start as a service, nothing in the log
  29. Mongodb concat int and string
  30. Query for a field in an object in array with Mongo?

Leave a Comment