I wanted to chart some of the data that I see in the Energy dashboard but I cannot find the sensors. I used to have Utility Meter in use for my different sensors but I thought that was not superfluous as the exact same info is shown in Energy anyway.
But can I access that data so I can display it in a different fashion?
E.g. each registered sensor has a daily consumption and I would like to see that in a time vs energy graph rather than in that horizontal one-day bar graph.
Is that possible? Especially since Utility Meter does not consider old data.
It’s probably not possible on the energi panel for individual devices.
What do you mean Especially since the Utility Meter doesn’t take old data into account?
The Utility Meter starts tracking/converting only from the moment it is created even though the sensor data it uses exists for the last werks and months.
But you cannot see Utility Meter results from any point before creation of the respective meter.
So, if sensor a started recording in January but it was not added to the Utility Meter config as a daily cycle until August, then I cannot see any daily cycle data prior to August.
If it wanted to, all data would be available to create daily data all the way back to the very first measurement of the sensor. But it doesn’t.
You still need the utility meters. The values displayed in the energy dashboard are generated from the LTS tables in the recorder database. So you can’t use those displayed values, e.g. the daily totals for devices without creating your own SQL sensors.
Because I would like to know how the daily consumption changed after I made some hardware settings adjustments. For that I need to see daily consumption before and after those adjustments. But I did not create the utility meter until after.
How far back does your recorder history go (10 days by default if you have not changed it)?
How long ago did you make the changes?
There is an SQL sensor that you could use to get an energy sensor’s state 10 days ago. This you could then feed to a utility meter to determine the daily energy 10 days ago. This will update in real time though. So you won’t see the final daily value until the end of the day.
My recorder records very select data but indefinitely.
So creating a single data point would not really be worth it. It would not help in comparing different settings (usually tested over multiple days to get decent statistics).
I may be mis-remembering, but don’t most dashboard cards then only access the MariaDB and not support getting long term info from influx? I vaguely recall that there was an issue using influx.
I am not a big fan of the grafana syntax and I do like my charts to be part of my dashboards.
While creating sensors is possible, it is the least attractive solution.
Manual creation means more maintenance work and more possible breaking changes. In that case it would even be easier to create charts that perform summations or evalutions directly (which I did not want to do unless absolutely necessary).
You’re using LTS if you’re using the energy dashboard.
Your only option is to create a sensor in some way, shape, or form. You cannot get the info you want out of the current implementation without making a new sensor.
