MongoDb sum query

Question

For example I have the following data in MongoDB:

{ "_id" : ObjectId("524091f99c49c4c3f66b0e46"), "hour" : 10, "incoming", 100}
{ "_id" : ObjectId("5240a045dbeff33c7333aa51"), "hour" : 11, "incoming", 200}
{ "_id" : ObjectId("5240a2ecda0d37f35c618aca"), "hour" : 12, "incoming", 300}

Now I want to query "SUM the number of incoming between 11 - 12" (the result should be 500), how could I do this using Mongo Shell?

Check out MongoDB's aggregation framework. In particular, take a look at $match, $group, and $sum. — llovett
– llovett, Commented Sep 23, 2013 at 22:29

jamshehan · Accepted Answer · 2013-09-24 15:27:32Z

128

As llovet suggested, the aggregation framework is the way to go. Here's what your query would look like:

db.CollectionNameGoesHere.aggregate({ $match: {
    $and: [
        { hour: { $gte: 11 } },
        { hour: { $lte: 12 } }
    ]
} },
{ $group: { _id : null, sum : { $sum: "$incoming" } } });

You can also shape the resulting document to only contain the sum by adding a $project operator at the end of the pipeline, like so:

{ $project: { _id: 0, sum: 1 } }

answered Sep 24, 2013 at 15:27

jamshehan

1,5011 gold badge10 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

DhanaLaxshmi Over a year ago

if i want all the fields how do i do it

Usman Iqbal Over a year ago

then dont use project

Sadme Rame Over a year ago

this returns list and can it return dict directly ?

yaya · Accepted Answer · 2019-08-30 20:15:20Z

9

Some examples if you use mongoose:

Calculate total sum of product prices :

Products.aggregate([ { $match: {} }, { $group:
  { _id : null, sum : { $sum: "$Price" } }
}])
.then(res => console.log(res[0].sum));

( { $match: {} }, can be removed. )

Sum of Product's prices in each category:

Products.aggregate([{ $group:
  { _id : '$Category', sum : { $sum: "$Price" } }
}])
.then(res => console.log(res));

edited Aug 30, 2019 at 20:15

answered Aug 30, 2019 at 19:56

yaya

8,3311 gold badge48 silver badges44 bronze badges

Collectives™ on Stack Overflow

MongoDb sum query

2 Answers 2

3 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related