Energy Panel chart Energy usage and char Solar production no detail shown. Solar production (KWh) total out of HA GroWatt integration. On daily basis the total is only available after the Solar Inventor is connecting the grid. Currently this is about 6:00 AM. Current total (about 6400KWh), is only available from that time. So the Energy usage show the 6400KWh at 6:00 AM (every day), and the Solar productions shows -6400KWh at 0:00 AM and +6400KWh at 6:00AM. How can I create a template sensor/statistics without this behavior. The sensor should be selectable at the Energy dashboard (Solar production). Can somebody help me out?
This happend to me too. in one hour gets an amount of solar energy production like a nuclear power plant.
Today it stopped working until a few minutes ago.
I have measures that are not realistic. I’ve checked the data with the official portal of my inverter and on the source side (fronius app) it’s all correct.
I have to say that is not usual it don’t work fine. but breaks all statistics of year energy production/consumption
some picks…
This screenshot is for today on fronius app and is related to the first pic
Here is my configuration:
I start from the power in watt (“sensor.solar_production” below) produced by my solar panels, than I convert them into energy in “sensors.yaml”:
- platform: integration
source: sensor.solar_production
method: left
unit_prefix: k
name: solar_production_kwh
unique_id: solar_production_kwh
When I have that energy, I create in “utility_meter.yaml” a sensor (called “sensor.solar_production_hourly”) resetting every hour (you can do it daily, weekly, monthly… as you can also see I am using tariffs but this is not mandatory):
solar_production_hourly:
source: sensor.solar_production_kwh
name: Solar Production Hourly
cycle: hourly
tariffs:
- pleines
- creuses
This last sensor is the one that will appear in the energy dashboard…
If this is not appearing in the energy dashboard, check that you do not have an error in home-assistant.log or something to correct in the “development tools”–>“statistics”, sometimes the unit of measurement is not correctly set in the database and therefore the entity will not appear in the energy dashboard…
For me, it seems like you’re looking for a solution to create a template sensor or statistics that doesn’t reset daily and provides more reliable data for your energy dashboard. It’s a tricky issue, but I’m sure there’s a workaround out there.
While I don’t have a specific fix for you, I recently came across some solar panel installers who might have encountered similar challenges. They often share helpful tips and insights into optimizing solar setups and navigating technical issues like this. It could be worth reaching out to them for advice or suggestions on how to tackle the problem.
This kind of case happens to me every few days when the integration incorrectly reads data from the Fronius.
For example, instead of reading TOTAL_ENERGY = 49091.2, it reads 490.9, and then it effectively duplicates entries in the “statistics” and “statistics_short_term” tables.
The fix involves running an SQL command, for example:
UPDATE “statistics” SET sum = state WHERE metadata_id = 20 and sum <> state
and
UPDATE “statistics_short_term” SET sum = state WHERE metadata_id = 20 and sum <> state;