[{_id:ObjectId("612c6d30a6f18312d1338386"),details:[{salesManagerId:ObjectId("112c6d30a6f18312d1338386")},{salesManagerId:ObjectId("122c6d30a6f18312d1338386")},{salesManagerId:ObjectId("132c6d30a6f18312d1338386")}],createdAt:ISODate("2021-09-01T11:23:25.184Z")},{_id:ObjectId("612c6d30a6f18312d1338387"),details:[{salesManagerId:ObjectId("142c6d30a6f18312d1338386")},{salesManagerId:ObjectId("152c6d30a6f18312d1338386")}],createdAt:ISODate("2021-09-02T11:23:25.184Z")},{_id:ObjectId("612c6d30a6f18312d1338388"),details:[],createdAt:ISODate("2021-09-02T11:23:25.184Z")}]

db.collection.aggregate([{"$group":{"_id":{year:{$year:"$createdAt"},month:{$month:"$createdAt"},day:{$dayOfMonth:"$createdAt"}},"Sales":{"$sum":1},"Own Sales Volume":{"$sum":{$cond:[{$and:[{$isArray:"$details"},{$gt:[{"$size":"$details"},0]}]},1,0]}}}}])