Where are the data stored from powercalc when using a fixed sensor

[ernst10]

Hi,
I first want to say that powercalc is a really super tool.

But i do have some question on it.
I used now powwercalc to run a fixed sensor to have the data from a electrical heater. It worked perfectly and showed me the daly weekly and monthly and year data consoludated.
after my SD card has crashed i set up a new HA and brought back a backup. Unfortunatelly all LTS before crash are gone. I need to add that i have setup InfluxDB parallel to the internal SQLite default database for LTS data saving. Nothing from the powercalc data have been stored in Influx. All other data generated from HA are in Influx.
Question now have i done a mistake on setup or how data are transformed to Inlux.
Perhaps they are first sent to Influx after standard Retension time of HA. If yes, how could this be forced as there are 10 days retension time by default.
is there a way to get the history back or how to manually add the last data to get a somehow complete history again.
By the way. After restore of default HA database SQlite only the Dayly and the fixed energy point show up in Overview. How to get the other data "points" back as well, even when they are now empty?

Yes i know lot of writing but i think a short story will not fit the issue.

Many thanks
Ernst10

[bramstroker]

@ernst10 Unfortunate you had a crash. I also started with an SD card and raspberry PI first 2 months in HA journey, but quickly realised I should run another way. Using Intel NUC with SSD for 3 years now, and never failed a minute. rocksolid.

Anyways all the LTS statistics are saved in statistics table in SQLite DB. Just like any other entity which data is aggregated hourly by HA.
When you have lost data and you want to recover somehow you should have a look into inserting in that table.

Not sure why HA didn't restore that data as it is the most important data stored in Sqlite DB.

Hope this helps.

Btw, I am also using MariaDB, which is also more reliable and a bit faster than the default Sqlite.
You may also have a look into using that to prevent any recurring issues in the future.

[ernst10]

@bramstroker

Many thanks again,

Last question. I added a new powercalc sensor where power summery, weekly monthly and daily now present again. But what surprise without any data.
How can i add data manually to this states to get a more or less statistic again
ernst10

[bramstroker]

I'm not sure about that question. daily, weekly sensors powercalc creates are the same as you would so using the utility meter helper of HA: https://www.home-assistant.io/integrations/utility_meter/
The state of this sensor will be updated whenever a cycle passes (i.e. once a day, once a week). When you have created a new powercalc entity, than there will not be magically any historical data, but the utility meters will start calculating from then on.
This data will be saved in states, statistics and statistic_short_term tables, as every other entity state of HA entity.

[bramstroker]

Or do you mean weekly, monthly, daily charts in the energy dashboard?
These are calculated on the fly directly from LTS (statistics table).
But same applies for this one, if you don't have historical data in that table than there will be no historical charts.

[ernst10]

Thanks a lot
I will mark this as answered now

Ernst10