[{"Type":"A","Attributes":[{"Date":"2021-10-02","Value":5},{"Date":"2021-09-30","Value":1},{"Date":"2021-09-25","Value":13}]},{"Type":"B","Attributes":[{"Date":"2021-10-01","Value":36},{"Date":"2021-09-15","Value":14},{"Date":"2021-09-10","Value":18}]}]

db.collection.aggregate([{"$project":{"maxDateValue":{"$max":{"$map":{"input":"$Attributes","in":{"Date":"$$this.Date","Value":"$$this.Value"}}}},"Type":1}},{"$project":{"Date":"$maxDateValue.Date","Value":"$maxDateValue.Value"}}])