[{"_id":{"$oid":"617f3f51f883fab2de3e7260"},"endDate":{"$date":"2021-11-07T23:59:59.000Z"},"startDate":{"$date":"2021-11-01T00:00:00.000Z"},"wastes":[{"timestamp":{"$date":"2021-11-01T01:00:58.000Z"},"duration":780},{"timestamp":{"$date":"2021-11-01T01:00:58.000Z"},"duration":1140},{"timestamp":{"$date":"2021-11-01T03:00:58.000Z"},"duration":540},{"timestamp":{"$date":"2021-11-01T07:00:58.000Z"},"duration":540},{"timestamp":{"$date":"2021-11-01T09:00:58.000Z"},"duration":960},{"timestamp":{"$date":"2021-11-01T09:00:58.000Z"},"duration":1140},{"timestamp":{"$date":"2021-11-01T15:00:58.000Z"},"duration":180},{"timestamp":{"$date":"2021-11-01T15:00:58.000Z"},"duration":540}]}]

db.collection.update({},[{$addFields:{maxDuration:{"$reduce":{"input":"$wastes","initialValue":null,"in":{"$cond":{"if":{$and:[{$eq:["$$this.timestamp",{"$date":"2021-11-01T01:00:58.000Z"}]},{$gt:["$$this.duration","$$value"]}]},"then":"$$this.duration","else":"$$value"}}}}}},{$set:{wastes:{$filter:{input:"$wastes",as:"w",cond:{$or:[{$ne:["$$w.timestamp",{"$date":"2021-11-01T01:00:58.000Z"}]},{$eq:["$$w.duration","$maxDuration"]}]}}}}},{"$unset":"maxDuration"}])