Skip to content

Instantly share code, notes, and snippets.

@iAnatoly

iAnatoly/Combining two retention poolicies in ine graph (grafana, influxdb)

Created November 10, 2020 00:56
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save iAnatoly/2fff4a278f0949cb97fbbc35e3651231 to your computer and use it in GitHub Desktop.
Save iAnatoly/2fff4a278f0949cb97fbbc35e3651231 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Combining two retention poolicies in ine graph (grafana, influxdb)
SELECT temp *9/5+32
FROM
(SELECT median("temperature") AS "temp" FROM "weather" WHERE $timeFilter GROUP BY time(5m)),
(SELECT median("mean_temperature") AS "temp" FROM "year"."weather" WHERE $timeFilter GROUP BY time(1h))
GROUP BY "source" fill(null)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment