backup energy data to grafan, power, gas etc.

[swa72]

power gas solar schreibtisch entfeuchter

by month by week by day by hour

[swa72]

Solar

• solar_energy_today
• solar_energy_last_hour

[swa72]

Power

• smlreadertotalenergyconsumption group by day
• smlreadertotalenergyconsumption group by hour

[swa72]

gas

• gasverbrauch
• gaszähler can be ignored

mal ausprobieren die x werte aus gasverbrauch long time zu speichern nach h.

[swa72]

Clean energy data with https://community.home-assistant.io/t/energy-management-full-data-reset/332618/4 Also https://community.home-assistant.io/t/energy-management-in-home-assistant/326854/455

Energy power is meta ID 150

SELECT * FROM statistics WHERE metadata_id = 150;

deleted all data where state and sum are drastically different (4 lines on October 30th).

[swa72]

Also check retention policies with the following doc https://alex3305.github.io/home-assistant-docs/add-ons/influxdb-downsampling/