[{"JobID":"Jobid1","TemplateName":"templateName","CampaignName":"campaignName","Channel":"channel","SentBy":"sentBy","SentFrom":"sentFrom","Sent":"2022-08-01","Delivered":"2022-08-01"},{"JobID":"Jobid1","TemplateName":"templateName","CampaignName":"campaignName","Channel":"channel","SentBy":"sentBy","SentFrom":"sentFrom","Sent":"2022-08-01","Delivered":"2022-08-01"},{"JobID":"Jobid1","TemplateName":"templateName","CampaignName":"campaignName","Channel":"channel","SentBy":"sentBy","SentFrom":"sentFrom"}]

db.collection.aggregate([{$group:{_id:"$JobID",SentCount:{$sum:{$cond:{if:"$Sent",then:1,else:0}}},DeliveredCount:{$sum:{$cond:{if:"$Delivered",then:1,else:0}}},ReadCount:{$sum:{$cond:{if:"$Read",then:1,else:0}}},FailedCount:{$sum:{$cond:{if:"$Failed",then:1,else:0}}}}}])