[{"_id":ObjectId("5ec4e40a7c89c96c7c3818f0"),"lob":"DIGITAL_STORE","paymentMode":"NET_BANKING","pgStatus":"PG_SUCCESS","createdAt":ISODate("2020-05-20T08:02:18.566Z"),"updatedAt":ISODate("2020-07-22T18:57:29.915Z"),"updatedBy":"ONLINE_CHANNEL","_class":"com.airtel.payments.pg.commons.persistence.PgTransactionDetails"},{"_id":ObjectId("5ec4e40a7c89c96c7c3818f1"),"lob":"DIGITAL_STORE","paymentMode":"NET_BANKING","pgStatus":"PG_FAILED","createdAt":ISODate("2020-05-20T08:02:18.566Z"),"updatedAt":ISODate("2020-07-22T18:57:29.915Z"),"updatedBy":"ONLINE_CHANNEL","_class":"com.airtel.payments.pg.commons.persistence.PgTransactionDetails"},{"_id":ObjectId("5ec4e40a7c89c96c7c3818f2"),"lob":"DIGITAL_STORE","paymentMode":"NET_BANKING","pgStatus":"PG_FAILED","createdAt":ISODate("2020-05-20T08:02:18.566Z"),"updatedAt":ISODate("2020-07-22T18:57:29.915Z"),"updatedBy":"ONLINE_CHANNEL","_class":"com.airtel.payments.pg.commons.persistence.PgTransactionDetails"}]

db.collection.aggregate([{$group:{_id:{Lob:"$lob",Mode:"$paymentMode"},Success:{$sum:{$cond:[{$eq:["$pgStatus","PG_SUCCESS"]},1,0]}},Failed:{$sum:{$cond:[{$eq:["$pgStatus","PG_FAILED"]},1,0]}}}}])