Hi!
I’m wondering if it is possible to insert data in the statistics table. I’m storing the daily energy production and consumption for a few months but only started with the cost sensors last week. Given that I have all the production and consumption data, it is an easy call to calculate the costs.
However, I don’t know in which format I should add them to the database. My production and consumption sensors are total_increasing sensors which reset on daily basis but sums up since the first measurement ever in the statistics table.
Otherwise, I’m also interested in how the data is used in the Energy tab. Does it calculate the difference every time you open the dashboard? Since I don’t see hourly differences in the statistics table.
Hope to hear from you!