[{"_id":1,"Requestor":{"Info":{"_id":"155","Name":"James"},},"JobStatus":{"_id":{"$binary":"RtegzGJrakmEWnS26ffviQ==","$type":"03"},"JobId":1,"Status":0,}},{"_id":2,"Requestor":{"Info":{"_id":"155","Name":"Fred"},},"JobStatus":{"_id":{"$binary":"RtegzGJrakmEWnS26ffviQ==","$type":"03"},"JobId":2,"Status":0,},},{"_id":3,"Requestor":{"Info":{"_id":"155","Name":"John"},},"JobStatus":{"_id":{"$binary":"RtegzGJrakmEWnS26ffviQ==","$type":"03"},"JobId":3,"Status":1,},},{"_id":4,"Requestor":{"Info":{"_id":"175","Name":"Mary"},},"JobStatus":{"_id":{"$binary":"RtegzGJrakmEWnS26ffviQ==","$type":"03"},"JobId":3,"Status":1,},}]

db.collection.aggregate([{$match:{"Requestor.Info._id":"155"}},{$group:{_id:null,Open:{$sum:{$cond:[{$eq:["$JobStatus.Status",0]},1,0]}},Closed:{$sum:{$cond:[{$eq:["$JobStatus.Status",1]},1,0]}},}}])