[{"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"}}},"status":{"$push":"$sEmailStatus"}}},{"$project":{"_id":0,"date":"$_id.id","sent":{"$size":{"$filter":{"input":"$status","cond":{"$eq":["$$this","Send"]}}}},"failed":{"$size":{"$filter":{"input":"$status","cond":{"$eq":["$$this","Failed"]}}}}}}])