by(city) (temperature_celsius{country=" germany" }) SELECT city, AVG(value) FROM temperature_celsius WHERE \ country=" germany" GROUP BY city rate(errors{job=" foo" }[5m]) / rate(total{job=" foo" }[5m]) rate(errors.value, 5m) / rate(total.value, 5m) \ FROM errors JOIN total ON [...all label equalities...] \ WHERE errors.job=" foo" AND total.job=" foo" Richard Hartmann & Frederic Branczyk @TwitchiH & @fredbrancz