mongodb multiple aggregates in same query, each with total

Question

Trying to do aggregate group with more than one { $sum: '$total' }

db.transactions.aggregate([{$group: {_id: '$cashier', cost: {$sum: "$total"}}}, {$group:
{_id: '$deviceid', cost: {$sum: "$total"}}}  ])

When i use two aggregates, the second aggregate returns 0. Av tried to use $project but still i loose get zero.

Valijon · Accepted Answer · 2019-12-09 09:29:17Z

2

You need to use $facet

db.transactions.aggregate([
  {
    $facet: {
      cashier: [
        {
          $group: {
            _id: "$cashier",
            cost: {
              $sum: "$total"
            }
          }
        }
      ],
      deviceId: [
        {
          $group: {
            _id: "$deviceid",
            cost: {
              $sum: "$total"
            }
          }
        }
      ]
    }
  }
])

MongoPlayground

answered Dec 9, 2019 at 9:29

Valijon

13.2k4 gold badges40 silver badges74 bronze badges

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

2 Comments

Mbanda Over a year ago

Bravooh ! I have removed $project and now using $face. It works well. But just point of curiosity. Which of this 2 is reliable for heavy Load calls.

Valijon Over a year ago

The $facet pipeline stage would cause problem with the BSON Limit only.

Collectives™ on Stack Overflow

mongodb multiple aggregates in same query, each with total

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related