Database

[{"_id":1,"cpyKey":"1","Max Devices":10,"run_date":ISODate("2022-01-01")},{"_id":2,"cpyKey":"1","Max Devices":10,"run_date":ISODate("2022-01-02")},]

Query

db.collection.aggregate([{"$sort":{"run_date":-1}},{"$group":{"_id":"$cpyKey","Max Devices":{"$last":"$Max Devices"}}},{"$sort":{"Max Devices":1}}])

Result