EN VI

Mongodb - Mongo count number of objects grouped by a field value?

How to Mongodb - Mongo count number of objects grouped by a field value

I have the following mongo model:

{
    "_id" : "5f5a1c1f6976570001783ab7",
    "date" : NumberLong(1590624000),
    "source" : "here",
}

I would like to have the number of documents, group by date, that have source field at here value for example:

{
    "date" : NumberLong(1590624000),
    "count": 5
},

{
    "date" : NumberLong(1590710400),
    "count": 10
}

What mongo query should I use to have the following result?

Solution:

you can use aggregation query for it.

db.collection.aggregate([
{$match:{source:'here'},
{$addFields:{count:1}},
{$group:{_id:'$date'
,totalDocuments:{$sum:"$count"}}
}
])

Tags

Pinned Posts

Tags: ads, Publishers, Ads Networks

Tags: Server, host, cloud

Author

Best Solution

Bot Lv 9

Keyword

Answer