Your observation is valid, but it doesn’t mean that the graph is correct.
Not true.
The fact that everything doesn’t nett out is a different problem all together.
And that’s exactly what the graph shows. That your data does not net out.
There is no math required to display the usage of different energy sources on a graph.
We are in a realm of “simulation”, it is simulation of real data, yes. But still, graph is only simulating hourly usage from data provided/recorded.
Energy dashboard works per hour. Not per day, week, month, year or lifetime.
If the sensor values don’t net out it just means is that they don’t integrate the power values correctly.
But this is exactly what you need to correctly display the graphs.
The graph should still be correctly showing what I recorded
And the graph in fact does exactly that.
Shows very precisely exactly that what’s recorded.
No guessing. No assumptions.
but instead, some unnecessary calculation is performed which leads to some energy sensor values cancelling out
If you just want to see columnar graphs which just shows values of your sensor that’s not what’s the Energy usage graph is for. (It’s in the name that it shows usage)
It may be required for other calculations (e.g. Self-sufficiency) but not for the Energy Usage graph.
And that usage involves math operations too.
The sudden jump in the battery energy charged makes sense, because the value increased by a significant amount since the previous data point.
Yes but the data clearly shows that some of that sudden jump energy belongs to previous hour span because you did not recorded enough Grid Import from 19:00 to 20:00.
As I said Energy dashboard works on per hour basis thus won’t look for missing energy outside of that hour segment.
This would be already mentioned guessing and making assumptions.
That could be an issue with how the energy sensor integrates, loss of connection or whatever, but doesn’t impact the way the Energy usage is displayed.
Energy dashboard needs accurate data.
The spreadsheet uses the CSV data exported from the energy dashboard. Why does the dashboard not produce the same chart with the same data? Because it unnecessarily manipulates the data before rendering the chart.
Your graph is either just merge of all sensors (showing data from all sensors within single graph which means is not showing Energy usage) or does not provide view on per hour basis which is core of the Energy dashboard.
- Find the issue with your sensors, fix it and you will fix the graph too.
- I myself would change many things about how it works but the fact that the Energy dashboard doesn’t work the way you want it does not make it wrong. It works exactly as described. If you don’t agree with that you can propose a change or make a PR yourself.