Database
[{"_id":"value","data":[{"d":"2022-05-16","v":10.06},{"d":"2022-05-18","v":9.11},{"d":"2022-05-20","v":7.06}],"name":"Vegeta"}]
Query
db.collection.aggregate([{$match:{"name":"Vegeta"/**input*/}},{"$project":{"_id":1,"name":1,"data":{"$filter":{"input":"$data","as":"data","cond":{"$lte":["$$data.d","2022-05-20"/**input*/]}}}}},{$project:{"_id":1,"name":1,"data":{$sortArray:{input:"$data",sortBy:{"d":-1}}}}},{$project:{"_id":1,"name":1,"data":{"$arrayElemAt":["$data",0]}}}])