Database
[{_id:ObjectId("62e0d2defd1a769bb8ad13bc"),at:ISODate("2022-03-27T11:56:00.000Z"),personIds:13355,productIds:["c3cc8b62-f9f7-4845-8585-effb1efd790d","af59b890-61b6-45a6-b2a1-32e16ba1a136",],},{_id:ObjectId("62e0d2defd1a769bb8ad13bd"),at:ISODate("2022-03-28T10:56:00.000Z"),personIds:13355,productIds:["c3cc8b62-f9f7-4845-8585-effb1efd790d","af59b890-61b6-45a6-b2a1-32e16ba1a136","dg59b890-gdb6-4ere-asdd-23e16ba123a4",],},{_id:ObjectId("62e0d2defd1a769bb8ad13dc"),at:ISODate("2022-03-29T22:57:00.000Z"),personIds:10347,productIds:["920ba4e4-8d51-4e87-b40a-5d3f7b78d3ba"],},]
Query
db.collection.aggregate([{"$project":{hours:{"$hour":"$at"},count:{$size:"$productIds"},at:1,personIds:1}},{"$match":{personIds:{$in:[13355,10347]},at:{$gte:ISODate("2022-03-28T00:00:00Z"),$lt:ISODate("2022-03-30T00:00:00Z")},hours:{$gte:10,$lte:22}}},{$group:{_id:null,count:{$max:"$count"}}},])