[{status:"INITIATED",_id:"6057e0013a3dec1d44a7d152",group:"dairy",location:"001",total_items:30,__v:0},{status:"INITIATED",_id:"6057e0013a3dec1d44a7d153",group:"dairy",location:"002",total_items:45,__v:0},{status:"INITIATED",_id:"6057e0013a3dec1d44a7d154",group:"dairy",location:"003",total_items:12,__v:0},{status:"NOT INITIATED",_id:"6057e0013a3dec1d44a7d155",group:"dairy",location:"004",total_items:50,__v:0},{status:"NOT INITIATED",_id:"6057e0013a3dec1d44a7d156",group:"drugs",location:"005",total_items:23,__v:0},{status:"NOT INITIATED",_id:"6057e0013a3dec1d44a7d157",group:"drugs",location:"006",total_items:76,__v:0}]

db.collection.aggregate([{"$group":{"_id":"$group","NOT INITIATED":{"$sum":{"$cond":[{"$eq":["$status","NOT INITIATED"]},1,0]}},"INITIATED":{"$sum":{"$cond":[{"$eq":["$status","INITIATED"]},1,0]}},}},{"$project":{"_id":0,"group":"$_id","INITIATED":1,"NOT INITIATED":1}}])