Database
[{"name":"a","locale":"en-GB","insertion_date":{"$date":"2024-04-03T07:00:00.000Z"}},{"name":"b","locale":"en-GB","insertion_date":{"$date":"2024-04-03T07:00:00.000Z"}},{"name":"c","locale":"es-GT","insertion_date":{"$date":"2024-04-03T07:00:00.000Z"}},{"name":"x","locale":"es-GT","insertion_date":{"$date":"2019-01-02T01:00:00.000Z"}},{"name":"y","locale":"en-GB","insertion_date":{"$date":"2019-01-02T01:00:00.000Z"}},{"name":"z","locale":"en-GB","insertion_date":{"$date":"2019-01-02T01:00:00.000Z"}}]
Query
db.collection.aggregate([{$setWindowFields:{sortBy:{insertion_date:-1},output:{rank:{$denseRank:{}}}}},{$match:{rank:1}}])