21/06/2021

Home Automation System - OpenHAB 3 Migration - 15. Historical data check on InfluxDB/Grafana [Versione in italiano]

by Marco Lamanna

Fifteenth chapter related to my OpenHAB 2.5 to OpenHAB 3 migration.

After setting the data storage strategy of our migrated sonoff basic, using the retention policies and continuous queries on influxdb, let's check its effectiveness by viewing the data directly in the influxdb table and by creating a small dashboard on grafana.

In order to solve the limitation of openhab not being able to specify a different retention policy for each item, in addition to the classic continuous query that aggregates data on a higher timeframe, we write a particular query to manage the simple copy of data from a retention policy to another without making aggregations.

This video does not pretend to be a tutorial. The hope is that it will help someone.

Enjoy your viewing

[Open on YOUTUBE]