Set historical statistics manually

[Oliver.H]

Hi,

there is under developer tools the possiblity to set the statistics for a utility meter für a certain 5min interval somewhere in the past. I wonder if there is also a way to set the values for a whole month.

My scenario is: I recently started reading my digital energy meter via tasmota into my home assistant. But for the 4 years before I only read the value from my energy meter monthly into an excel file. So I wondered if there is a way how to set these montly values in home assistant so that I can already see the stats from the years and months before even though I created the sensors and stats just recently.

Kind regards

[maurcabezas (Mauricio Cabezas)]

Hello, I am looking for something similar. I would like to delete a specific historical point and add my own historical data taken manually from Excel. I think is possible adding manually to the database. Still I haven’t tried (I’m not at home) but it seems can works…

Modifying data in the database via script?

Just cause it took me a while to get this write i thought i would post so i can find it later when i forget. my bash script for removing 0.0 temperature/humidity entries from my sensors (which are all called “sensor.snX_temperature” “sensor.snX_humidity” ) #!/bin/bash HOST=‘mysql_server’ DB=‘HA_DB’ USER=‘username’ PW=‘password’ query=“delete from states where state = ‘0.0’ and entity_id like ‘sensor.sn%’” echo “$query” | mysql -h$HOST -D$DB -u$USER -p$PW

Besides to delete… I think also is possible add.

I will try during the day and if I manage I will write.