DisclaimerPlease, proceed carefully following the tips published in this blog, specially when Main Power is involved. I'm not responsible for any damages caused by what is written in this blog.
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