[{"_id":ObjectId("5ef3b94d617c89736b7f4967"),"action":"started","process":"combined.js","name":"Product 2","location":{"branchId":"1"},},{"_id":ObjectId("5ef3b9850263df74c16a0819"),"args":["102","false","06-23-2020","true"],"action":"processing","process":"combined.js","name":"Product 2","location":{"branchId":"1"},},{"_id":ObjectId("5ef3b9b3e9109c75e19ead0e"),"action":"errored","process":"combined.js","name":"Product 2","location":{"branchId":"2"},}]

db.collection.aggregate([{$match:{}},{$group:{_id:{branchId:"$location.branchId",name:"$name"},started:{$sum:{$cond:[{$eq:["$action","started"]},1,0]}},processing:{$sum:{$cond:[{$eq:["$action","processing"]},1,0]}},errored:{$sum:{$cond:[{$eq:["$action","errored"]},1,0]}},completed:{$sum:{$cond:[{$eq:["$action","completed"]},1,0]}}}},])