I tried the instructions from : Influxdb (1.8) setup - ONE continuous query for WHOLE database but didn’t got very far.
CREATE DATABASE “home_assistant” WITH DURATION 4380h0m0s REPLICATION 1 SHARD DURATION 168h NAME “6M_raw”
influxdb retention policy conflicts with an existing policy
So I created this from InfluxDB (add-on)
then this step:
CREATE CONTINUOUS QUERY “6M_raw-2y_5m” ON “home_assistant” BEGIN SELECT mean(value) AS value INTO “home_assistant”.“2y_5m”.:MEASUREMENT: FROM “home_assistant”.“6M_raw”././ WHERE time < now() -4380h0m0s GROUP BY time(5m), END
Request failed with status code 400
then gave up ;-(