Hi guys, I’m having to offline-sensors for gas and water. But I read the meters periodically and put the values in a Excel file where I also created an interpolation to have daily figures.
I then imported those historical values into statistics
and they are pretty well shopwn in HA itself.
BUT, the energy dashboard doesn’t show them as I set the availability of the sensor to false
and it’s current value to none
since I don’t have an actual value. How can I convince HA to base it’s energy dashboard figures only on historical data?
The only other option I came up with is to set a dummy value on the sensor as current state, adapt it on every import to the latest value and remove those historicized dummy values from the database as they shall be replaced by my interpolated ones…
Anybody got a solution or an idea for this use case?