How to do multiple count in a single query in MongoDB?

Question

So I have this code:

db.collection.find( { sex: 'Male' } ).count()

and what I want to do is also count sex: 'Female' at the same time instead of

db.collection.find( { sex: 'Male' } ).count()
db.collection.find( { sex: 'Female' } ).count()

Is there a way to do it in a single query? Because I am generating a pie chart based on their length. Any help would be much appreciated.

Possible duplicate of Multiple Counts with single query in mongodb — Ashh
– Ashh, Commented Nov 9, 2018 at 5:15

Diego Costa · Accepted Answer · 2017-03-20 07:08:21Z

9

db.collection.aggregate([
    {"$group" : {_id:"$sex", count:{$sum:1}}}
])

answered Mar 20, 2017 at 7:08

Diego Costa

1114 bronze badges

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

1 Answer 1