[{"status":"RESOLVED","transactionId":"123abc","associatedId":"association-1","timestamp":"2022-01-01"},{"status":"RESOLVED","transactionId":"123abc","associatedId":"association-1","timestamp":"2022-01-02"},{"status":"NOT_RESOLVED","transactionId":"456xyz","associatedId":"association-1","timestamp":"2022-01-02"},{"status":"RESOLVED","transactionId":"456xyz","associatedId":"association-1","timestamp":"2022-01-02"},{"status":"RESOLVED","transactionId":"456xyz","associatedId":"association-1","timestamp":"2022-01-01"},{"transactionId":"456xyz","associatedId":"association-1","timestamp":"2022-01-01"},{"status":"NOT_RESOLVED","transactionId":"456xyz","associatedId":"association-2","timestamp":"2022-01-02"},{"status":"RESOLVED","transactionId":"456xyz","associatedId":"association-2","timestamp":"2022-01-02"},{"transactionId":"456xyz","associatedId":"association-2","timestamp":"2022-01-01"}]

db.collection.aggregate([{"$group":{"_id":{associatedId:"$associatedId",transactionId:"$transactionId"},"RESOLVED_TOTAL":{$sum:{"$cond":{"if":{$eq:["RESOLVED","$status"]},"then":1,"else":0}}},"NOT_RESOLVED_TOTAL":{$sum:{"$cond":{"if":{$eq:["NOT_RESOLVED","$status"]},"then":1,"else":0}}},"ABSENT_TOTAL":{$sum:{"$cond":{"if":{$eq:[null,{"$ifNull":["$status",null]}]},"then":1,"else":0}}},"GRAND_TOTAL":{$sum:1}}},{$sort:{"_id.associatedId":1,"_id.transactionId":1}}])