[{"_id":1,"date":ISODate("2023-11-08"),"field":"A"},{"_id":2,"date":ISODate("2023-11-08"),"field":"B"},{"_id":3,"date":ISODate("2023-11-08"),"field":"C"},{"_id":4,"date":ISODate("2023-11-09"),"field":"B"},{"_id":5,"date":ISODate("2023-11-09"),"field":"C"}]

db.collection.aggregate([{"$group":{"_id":"$date","in_array":{$sum:{$let:{vars:{inputArray:["A","D","E"]},in:{"$cond":{"if":{"$in":["$field","$$inputArray"]},"then":1,"else":0}}}}},"not_in_array":{$sum:{$let:{vars:{inputArray:["A","D","E"]},in:{"$cond":{"if":{$not:{"$in":["$field","$$inputArray"]}},"then":1,"else":0}}}}},"count":{$sum:1}}}])