Database
[{_id:1,title:"ABCDEF",counter:200,values:[{a:4,b:4,date:ISODate("2023-02-21T00:00:00.000Z")},{a:2,b:4,date:ISODate("2023-02-25T00:00:00.000Z")}]},{_id:2,title:"ABCDEF",counter:300,values:[{a:4,b:4,date:ISODate("2023-02-21T00:00:00.000Z")},{a:2,b:4,date:ISODate("2023-02-25T00:00:00.000Z")}]},{_id:3,title:"ABCDEF",counter:200,values:[{a:4,b:4,date:ISODate("2023-02-21T00:00:00.000Z")},{a:3,b:4,date:ISODate("2023-02-25T00:00:00.000Z")}]},{_id:4,title:"ABCDEF",counter:200,values:[{a:4,b:4,date:ISODate("2023-02-21T00:00:00.000Z")},{a:2,b:4,date:ISODate("2023-02-20T00:00:00.000Z")}]}]
Query
db.collection.aggregate([{"$match":{"counter":{"$lt":201}}},{"$set":{"auxvalue":{"$arrayElemAt":[{"$sortArray":{"input":"$values","sortBy":{"date":-1}}},0]}}},{"$match":{"$expr":{"$gte":["$auxvalue.b",{"$multiply":["$auxvalue.a",2]}]}}},{"$project":{"auxvalue":0}}])