[{"details":[{"_id":ObjectId("5e345493b341d550c626fa4f"),"salesManagerId":ObjectId("5e345231f974fb2074b3522e"),"createdAt":ISODate("2018-05-18T03:38:48.896Z"),"updatedAt":ISODate("2018-05-18T03:38:48.896Z")}],"createdAt":ISODate("2018-05-18T01:20:05.119Z"),"updatedAt":ISODate("2021-10-25T20:21:02.305Z"),},{"details":[{"_id":ObjectId("5e345493b341d550c626fa4f"),"salesManagerId":ObjectId("612cb021278f621a222087d7"),"createdAt":ISODate("2018-05-18T03:38:48.896Z"),"updatedAt":ISODate("2018-05-18T03:38:48.896Z")}],"createdAt":ISODate("2018-05-18T01:20:05.119Z"),"updatedAt":ISODate("2021-10-25T20:21:02.305Z"),},{"details":[{"_id":ObjectId("5e345493b341d550c626fa4f"),"salesManagerId":ObjectId("612f57184205db63a3396a9e"),"createdAt":ISODate("2018-05-18T03:38:48.896Z"),"updatedAt":ISODate("2018-05-18T03:38:48.896Z")},{"_id":ObjectId("5e345493b341d550c626fa4f"),"salesManagerId":ObjectId("612cb021278f621a222087d7"),"createdAt":ISODate("2018-05-18T03:38:48.896Z"),"updatedAt":ISODate("2018-05-18T03:38:48.896Z")}],"createdAt":ISODate("2018-05-18T01:20:05.119Z"),"updatedAt":ISODate("2021-10-25T20:21:02.305Z"),},{"details":[],"createdAt":ISODate("2018-05-19T01:20:05.119Z"),"updatedAt":ISODate("2021-10-25T20:21:02.305Z"),},{"details":[{"_id":ObjectId("5e345493b341d550c626fa4f"),"salesManagerId":ObjectId("5e345231f974fb2074b3522e"),"createdAt":ISODate("2018-05-19T03:38:48.896Z"),"updatedAt":ISODate("2018-05-18T03:38:48.896Z")}],"createdAt":ISODate("2018-05-19T01:20:05.119Z"),"updatedAt":ISODate("2021-10-25T20:21:02.305Z"),}]

db.collection.aggregate([{$group:{_id:{$dateToString:{format:"%Y-%m-%d",date:"$createdAt",},},A:{$sum:1,},B:{$sum:{$cond:[{$and:[{$isArray:"$details",},{$gt:[{$size:"$details",},0,],},],},1,0,],},},}},{$sort:{_id:-1,},},])