[{"_id":ObjectId("5c05984246a0201286d4b57a"),f:"x","_a":[{"_onlineStore":{}},{"_p":[{"pid":1,"s":{"d":{"t":[{id:1,"dateP":"2020-09-20"},{id:2,"dateP":"20200-09-20"}]},"c":{"t":[{id:3,"dateP":"20300-09-22"}]}}}]},{"_p":[{"pid":2,"s":{"d":{"t":[{id:1,"dateP":"20200-09-20",},{id:2,"dateP":"2022-09-20","tF":"N"}]},"c":{"t":[{id:3,"dateP":"20300-09-22"},{id:4,"dateP":"2022-09-23","tF":"N"}]}},h:"This is cleaned but it shauld not"}]},{x:2}]}]

db.collection.aggregate([{"$match":{"_a._p.s.d.t":{"$elemMatch":{"dateP":{"$regex":"^2022"},"tF":"N"}},"_a._p.s.c.t":{"$elemMatch":{"dateP":{"$regex":"^2022"},"tF":"N"}}}},{"$project":{"ap":"$_a._p"}},{"$project":{"docCount":{"$reduce":{"input":"$ap","initialValue":0,"in":{"$sum":["$$value",{"$reduce":{"input":"$$this","initialValue":0,"in":{"$sum":["$$value",{"$cond":[{"$and":[{"$reduce":{"input":"$$this.s.c.t","initialValue":false,"in":{"$or":["$$value",{"$and":[{"$eq":["$$this.tF","N"]},{"$regexMatch":{"input":"$$this.dateP","regex":"^2022"}}]}]}}},{"$reduce":{"input":"$$this.s.d.t","initialValue":false,"in":{"$or":["$$value",{"$and":[{"$eq":["$$this.tF","N"]},{"$regexMatch":{"input":"$$this.dateP","regex":"^2022"}}]}]}}}]},1,0]}]}}}]}}}}},{"$group":{"_id":null,"totalCount":{"$sum":"$docCount"}}}])