Hi there! I would like to add a table to my existing HA database, which is SQLite. My HA is installed on a RPI4 with attached SSD. The OS is setup and installed via the RPI imaging program, and use of HA has been so easy for my automations. The table would consist of the following columns: month …

I’m very confused why you aren’t using the built in energy tab that already does this exact comparison.

I was hoping not to have to go into why I didn’t use the Energy dashboard - it is related to the behaviour of the sensor linked to my power meter - it has spikes every so often (electrical-related) which skew the readings by a factor of 1000, and due to the fact that my helper could not be changed w…

[image] andyb23: I was hoping not to have to go into why I didn’t use the Energy dashboard - it is related to the behaviour of the sensor linked to my power meter - it has spikes every so often (electrical-related) which skew the readings by a factor of 1000, and due to the fact that my helper c…

I reported the issue here some time ago. [image] Daily resetting Helper has jumped to value of its source Configuration Hello. I have a daily resetting helper defined in my config file which uses a power meter sensor for its source. It always resets on a 00:05 cron. Toda…

[image] andyb23: Got zero responses That problem is very common, you likely would have gotten hits if you put it against the energy tag. Is this a template entity? If yes, post the template you’re using.

[image] andyb23: Tell me more, please! [image] SQL Instructions how to integrate SQL sensors into Home Assistant. You would get the history of your current sensor through SQL, average the value over the last month (Will require templating). That senso…

utility_meter: daily_power_meter_custom_helper: unique_id: "daily_power_meter_custom_helper" source: sensor.power_meter_reading name: "Daily Power Meter Import Custom Helper" cron: "5 0 * * *" this is what happens: [image]

What’s providing sensor.power_meter_reading, post that config

power_meter_reading: unique_id: "power_meter_reading" friendly_name: "Power Meter Reading" unit_of_measurement: "kWh" value_template: "{{ (states('sensor.reserve_energy_circuit_1')|float(0)) / 100 }}" icon_template: mdi:flash sensor.reserve_energy_circ…

Yep, there’s your problem. You’re using float(0) which will set the value to 0 when sensor.reserve_energy_circuit_1 is unavailable. This will make the sensor go unavailable when the source is unavailable, which will correct everything down the line. power_meter_reading: unique_id: "…

Looking to add & write to a new database table from within HA

Configuration

petro (Petro) April 4, 2025, 3:30pm 23

Here’s a guide from @anon11644107 showing the exact issue you’re running into if you still don’t believe me.