How to sum every fields in a sub document of MongoDB?

by

You have made the classical mistake to have arbitrary field names. MongoDB is “schema-free”, but it doesn’t mean you don’t need to think about your schema. Key names should be descriptive, and in your case, f.e. “S2” does not really mean anything. In order to do most kinds of queries and operations, you will need to redesign you schema to store your data like this:

_id:...
Segment:[
    { field: "S1", value: 1 },
    { field: "S2", value: 5 },
    { field: "Sn", value: 10 },
]

You can then run your query like:

db.collection.aggregate( [
    { $unwind: "$Segment" },
    { $group: {
        _id: '$_id', 
        sum: { $sum: '$Segment.value' } 
    } } 
] );

Which then results into something like this (with the only document from your question):

{
    "result" : [
        {
            "_id" : ObjectId("51e4772e13573be11ac2ca6f"),
            "sum" : 16
        }
    ],
    "ok" : 1
}

More Related Contents:

  1. Does MongoDB’s $in clause guarantee order
  2. $lookup on ObjectId’s in an array
  3. Mongodb sort inner array
  4. Return only matched sub-document elements within a nested array
  5. Converting string to date in mongodb
  6. Check if every element in array matches condition
  7. MongoDB nested lookup with 3 levels
  8. How to aggregate sum in MongoDB to get a total count?
  9. MongoDB : Aggregation framework : Get last dated document per grouping ID
  10. MongoDB Full and Partial Text Search
  11. Matching ObjectId to String for $graphLookup
  12. Rounding to 2 decimal places using MongoDB aggregation framework
  13. What’s the $unwind operator in MongoDB?
  14. Mongodb aggregation lookup with conditions
  15. How to get back the Original document back after aggregation
  16. Mongo sort on a calculated condition
  17. Find all duplicate documents in a MongoDB collection by a key field
  18. MongoDB lookup when foreign field is an array of objects
  19. MongoDB: Calculate dwell time between every status value change
  20. Search on multiple collections in MongoDB
  21. MongoDB – The argument to $size must be an Array, but was of type: EOO / missing
  22. Remove Duplicates from MongoDB
  23. $skip and $limit in aggregation framework
  24. How to access overall document count during arithmetic aggregation expression
  25. How to deal with the timezone issue when storing dates in utc using mongod?
  26. Mongodb Aggregation Framework | Group over multiple values?
  27. Sum in nested document MongoDB
  28. count array occurrences across all documents with mongo
  29. Mongodb concat int and string
  30. Return actual type of a field in MongoDB

Leave a Comment