I'm attempting to retrieve multiple arguments from my MongoDB database. Currently, my code fetches the distinct values for dates and counts them. However, I am unsure how to include another argument to fetch a different set of distinct values and counts.
For instance:
Below is the output generated by my code:
[ { _id: '05-09-2019', count3: 1 },
{ _id: '06-09-2019', count3: 1 },
{ _id: '06-21-2019', count3: 1 },
{ _id: '06-30-2019', count3: 5 },]
My goal is to achieve the following result:
[ { _id: '05-09-2019', count: 1, branch: America, count2: 1},
{ _id: '06-09-2019', count: 1, branch: Germany, count2: 1},
{ _id: '06-21-2019', count: 1, branch: Philippines, count2: 1},
{ _id: '06-30-2019', count: 5, branch: Vietnam, count2: 1},]
Here is the snippet of code used to obtain distinct date values along with their counts:
router.get('/blooddonationarea', function(req, res) {
Blooddonation.aggregate([{$group: {_id : "$date" , count :{$sum:1}}},{$sort: {_id: 1}}],function(err, date) {
res.json({ success: true, date: date });
//console.log(date);
});
});
I attempted to add this after the [] section but it did not return any values at all
[{ $match: { branch: { $eq: 'Rizal' } } },{$group: {_id : "$date", count2: {$sum:1}}},{$sort: {_id: 1}}]
Here is an example document:
_id:5c1f47dd59cdd931f4ce98ae
blood_product_donated:"Whole Blood"
branch:"Rizal"
deferral_type:"permanent"
date:"10-22-2019"