Database
[{"timestamp":ISODate("2024-01-01T00:00:00Z"),"schema":"1.0.0","value1":3,"value2":5},{"timestamp":ISODate("2024-01-01T01:00:00Z"),"schema":"1.2.0","value1":-10,"value2":1}]
Query
db.collection.aggregate([{"$set":{"month":{"$month":"$timestamp"},"absValue1":{"$abs":"$value1"},"absValue2":{"$abs":"$value2"}}},{"$setWindowFields":{"partitionBy":"$month","sortBy":{"absValue1":-1},"output":{"value1Rank":{"$rank":{}}}}},{"$setWindowFields":{"partitionBy":"$month","sortBy":{"absValue2":-1},"output":{"value2Rank":{"$rank":{}}}}},{"$match":{"$expr":{"$or":[{"value1Rank":1},{"value2Rank":1}]}}}])