How to aggregate sum in MongoDB to get a total count?

by

Sum

To get the sum of a grouped field when using the Aggregation Framework of MongoDB, you’ll need to use $group and $sum:

db.characters.aggregate([ { 
    $group: { 
        _id: null, 
        total: { 
            $sum: "$wins" 
        } 
    } 
} ] )

In this case, if you want to get the sum of all of the wins, you need to refer to the field name using the $ syntax as $wins which just fetches the values of the wins field from the grouped documents and sums them together.

Count

You can sum other values as well by passing in a specific value (as you’d done in your comment). If you had

{ "$sum" : 1 },

that would actually be a count of all of the wins, rather than a total.

More Related Contents:

  1. Get names of all keys in the collection
  2. How to filter array in subdocument with MongoDB [duplicate]
  3. MongoDB: Combine data from multiple collections into one..how?
  4. mongodb group values by multiple fields
  5. Multiple join conditions using the $lookup operator
  6. Conditional $sum in MongoDB
  7. Aggregate $lookup Total size of documents in matching pipeline exceeds maximum document size
  8. Get a count of total documents with MongoDB when using limit
  9. exclude fields in $lookup aggregation
  10. Mongodb Explain for Aggregation framework
  11. MongoDB aggregation comparison: group(), $group and MapReduce
  12. Add some kind of row number to a mongodb aggregate command / pipeline
  13. MongoDB group by array inner-elements
  14. Exception: can’t convert from BSON type EOO to Date
  15. Multiple Counts with single query in mongodb
  16. MongoDB sort documents by array elements
  17. Mongodb Aggregation Framework: Does $group use index?
  18. How to return array of string with mongodb aggregation
  19. How to return just the nested documents of an array from all documents
  20. Mongodb aggregation $group, restrict length of array
  21. Geospatial $near within current document field value
  22. Mongodb aggregation pipeline how to limit a group push
  23. MongoDB : aggregation framework : $match between fields
  24. Find documents whose array field contains at least n elements of a given array
  25. Generating a Structure for Aggregation
  26. MongoDB to Use Sharding with $lookup Aggregation Operator
  27. Export mongodb aggregation framework result to a new collection
  28. Mongodb, aggregate query with $lookup
  29. Return the last “true” value for each group
  30. MongoDB aggregate by field exists

Leave a Comment