ssenart / home-assistant-gazpar

GrDF Gazpar meter integration for Home Assistant
MIT License
41 stars 9 forks source link

Energy dashboard - data not showing #67

Open francsoitv opened 3 days ago

francsoitv commented 3 days ago

First, thanks for your work!

I have setup this addon and It works, I receive all the data :

Capture d’écran 2024-10-13 à 10 08 52

But when I try to add it to the energy dashboard, nothing shows on the graph (0kWh every day, every month, ...)

I tried with the alias, both kWh and m3, nothing seems to enable the data ingestion

I don't see any logs that might help me..

HA 2024.10.0

ssenart commented 3 days ago

Hello, the data start to feed the energy dashboard from the time you set it up.

You won't get the past data.

C-Duv commented 3 days ago

Do you know any way to insert those old values manually?

francsoitv commented 2 days ago

Ok thanks! +1 i'd love to be able to get history

If that's of any help, it's possible for Linky (https://github.com/bokub/ha-linky)

C-Duv commented 2 days ago

Too bad ha-linky is not in Python, it would have been easy to mimic the feature.

francsoitv commented 2 days ago

So I'm trying to get the history myself, with these steps:

Capture d’écran 2024-10-14 à 09 51 16 Capture d’écran 2024-10-14 à 09 53 16

With metadata_id = the ID of sensor.gazpar in the statistics_metadata table Be careful to put everything in the same metrics, kWh only in my case. I had to average the m3<>kWh conversion so that I can use the total m3

I'm still struggling with the new data, it seems that there is confusion between state column (which should be differential) and sum column (which should be total)