[{"createdAt":ISODate("2023-01-01T01:00:00.000Z"),"sEmailStatus":"Send"},{"createdAt":ISODate("2023-01-01T00:00:02.000Z"),"sEmailStatus":"Send"},{"createdAt":ISODate("2023-01-02T00:00:03.000Z"),"sEmailStatus":"Send"},{"createdAt":ISODate("2023-01-02T00:00:04.000Z"),"sEmailStatus":"Failed"},{"createdAt":ISODate("2023-01-03T00:00:05.000Z"),"sEmailStatus":"Send"}]

db.collection.aggregate([{"$group":{"_id":{"id":{"$dateToString":{"date":"$createdAt","format":"%Y-%m-%d"}}},"sent":{"$sum":{"$cond":{"if":{"$eq":["$sEmailStatus","Send"]},"then":1,"else":0}}},"failed":{"$sum":{"$cond":{"if":{"$eq":["$sEmailStatus","Failed"]},"then":1,"else":0}}}}},{"$project":{"_id":0,"date":"$_id.id","sent":1,"failed":1}}])