[{"collection":"experiments","count":20,"content":{"_id":{"type":"autoincrement","autotype":"int"},"experiment_name":{"type":"faker","method":"HackerNoun","maxDistinctValue":5},"run":{"type":"autoincrement","autotype":"int","start":1}}},{"collection":"metrics","count":100,"content":{"_id":{"type":"autoincrement","autotype":"int"},"experiment":{"type":"int","min":0,"max":20},"metric_name":{"type":"faker","method":"HackerAdjective","maxDistinctValue":8},"metric_value":{"type":"double","min":0.0,"max":50.0}}}]

db.metrics.aggregate([{"$match":{"metric_name":"auxiliary"}},{"$lookup":{"from":"experiments","localField":"experiment","foreignField":"_id","as":"experiment"}},{"$unwind":"$experiment"},{"$group":{"_id":"$experiment._id","metric_name":{"$first":"$metric_name"},"experiment_name":{"$first":"$experiment.experiment_name"},"max_run":{"$max":"$experiment.run"}}}])