[{"_id":1,"players":[{"team":"Arsenal","name":"Saka","distanceRan":8590},{"team":"Arsenal","name":"Aubameyang","distanceRan":9230}],"timestamp":129380193},{"_id":2,"players":[{"team":"Arsenal","name":"Saka","distanceRan":8590},{"team":"Ajax","name":"Aubameyang","distanceRan":9230}],"timestamp":129380193},{"_id":3,"players":[{"team":"Arsenal","name":"Saka","distanceRan":8590}],"timestamp":129380193}]

db.collection.aggregate([{"$set":{"players":{"$reduce":{"input":"$players","initialValue":{"team":null,"distances":[]},"in":{"$cond":[{"$and":[{"$or":[{"$eq":["$$this.name","Saka"]},{"$eq":["$$this.name","Aubameyang"]}]},{"$or":[{"$eq":["$$value.team",null]},{"$eq":["$$value.team","$$this.team"]}]}]},{"team":"$$this.team","distances":{"$concatArrays":["$$value.distances",["$$this.distanceRan"]]}},"$$value"]}}}}},{"$match":{"$expr":{"$eq":[{"$size":"$players.distances"},2]}}},{"$unwind":{"path":"$players.distances"}},{"$group":{"_id":null,"avgdistanceRan":{"$avg":"$players.distances"}}},{"$unset":["_id"]}])