[{"email":"one@gmail.com","companyRegNo":105,"event":{"created":ISODate("2022-09-16T06:42:42.761Z"),"desc":"COMPLETED_APPLICATIONS","note":"Direct apply",}},{"email":"one@gmail.com","companyRegNo":247,"event":{"created":ISODate("2022-09-16T06:42:04.387Z"),"desc":"COMPLETED_APPLICATIONS","note":"",}},{"email":"one@gmail.com","companyRegNo":247,"event":{"created":ISODate("2022-09-16T06:42:42.761Z"),"desc":"COMPLETED_REVIEW","note":"Sent for review",}},{"email":"one@gmail.com","companyRegNo":105,"event":{"created":ISODate("2022-09-16T06:42:42.761Z"),"desc":"COMPLETED_REVIEW","note":"Data is complete",}},{"email":"one@gmail.com","companyRegNo":247,"event":{"created":ISODate("2022-09-16T06:42:04.387Z"),"desc":"COMPLETED_OFFER","note":"",}},{"email":"one@gmail.com","companyRegNo":227,"event":{"created":ISODate("2022-09-16T06:42:04.387Z"),"desc":"COMPLETED_APPLICATIONS","note":"",}},{"email":"two@gmail.com","companyRegNo":227,"event":{"created":ISODate("2022-09-16T06:42:42.761Z"),"desc":"COMPLETED_APPLICATIONS","note":"",}},{"email":"two@gmail.com","companyRegNo":105,"event":{"created":ISODate("2022-09-16T06:42:42.761Z"),"desc":"COMPLETED_APPLICATIONS","note":"Direct apply",}}]

db.collection.aggregate([{"$match":{"event.created":{"$gte":ISODate("2022-06-01T00:00:00.000Z")}}},{$group:{_id:"$companyRegNo",ReviewCount:{$sum:{$cond:[{"$or":[{$eq:["$event.desc","COMPLETED_REVIEW"]},{$eq:["$event.note","Sent for review"]}]},1,0]}},OfferCount:{$sum:{$cond:[{$eq:["$event.desc","COMPLETED_OFFER"]},1,0]}},ApplicationsCount:{$sum:{$cond:[{$eq:["$event.desc","COMPLETED_APPLICATIONS"]},1,0]}}}}])