Comments (8)
- Form Storage and To Storage are currently calculated from the power values via an integral function which is only an approximation of the energy used. I have not had time to document this and did not find the value which represents the energy as for local energy production. Currently 1 measurement a minute is in influx, I assume a lower deviation when the data is collected more frequently.
- I was also struggling with that that's why currently the Local Energy Production incorporates both from battery and solar panels (which is the provided value by the API) and it is also related to the inaccuracies of the From/To storage calculation. When the From/To Storage values would reflect the real values more accurately the calculation can easily be done within the transformation tab in Grafana. You would then have 5 queries which return the above mentioned values and do the calculation in transformation tab.
from fronius-grafana-dashboard.
Thanks for the praise and input. I will try to improve the accuracy and investigate how HA does the calculation. Have some time in summer to investigate that further. When there is an improvement I will post an update.
from fronius-grafana-dashboard.
- I see, I've changed every interval (except solar forecast ofc) to 10s yesterday. Just trying it out.
- OK I'll try to figure out further on that at the Weekend.
Thanks for your fast response
from fronius-grafana-dashboard.
Hi again,
In my opinion, reducing the interval does not result in any improvement but I am not sure.
I still have differneces in from Storage but Home Usage looks quite good.
I'll keep following it and look for a way to get more accurate values. After all, the Fronius integration of Home Assistant with the same API manages to get fairly accurate values. I don't yet understand the difference.
Thank you very much for your great work. Very much appreciate that.
BTW: Today was a niiice day for PV :-P
from fronius-grafana-dashboard.
@robotnikz Had some time to take a look at the queries for From Storage and To Storage there is a Group By clause which may have a negative effect on the precision if you still have the data available you may want to remove GROUP BY time(1s) fill(0)
and change select clause to integral("P_Akku", 1h)
in these queries and check if the situation improves. Thank you for your help.
Queries would look like for from storage
SELECT integral("P_Akku", 1h) FROM "autogen"."powerflow" WHERE ("P_Akku"::field >= 0) AND $timeFilter tz('${tz:raw}')
and for to storage
SELECT abs(integral("P_Akku", 1h)) FROM "autogen"."powerflow" WHERE ("P_Akku"::field <= 0) AND $timeFilter tz('${tz:raw}')
Here are some hints https://community.grafana.com/t/different-integral-results-by-changing-time-range/41007/11
from fronius-grafana-dashboard.
@chpro
Thanks! Will try that out and give feedback.
from fronius-grafana-dashboard.
This is the situation at 4p.m. today
Home Assistant: (same as mentioned in Fronius SolarWeb)
From/To Grid is great.
From Storage is always too high in Grafana, so from Storage.
from fronius-grafana-dashboard.
Hey again @chpro,
I tried to figure out how to solve the gap between Home Assistant and the Grafana queries but at the end I came back to your last proposed solution since I was unable to find a more accurate way to read all the data.
Update from yesterday.
Think that wont help you here, just as a last update here from my side. Will report back if I found a better solution.
Thanks for your work again. Enjoy the sun! :)
from fronius-grafana-dashboard.
Related Issues (9)
- Hint to use InfluxQL HOT 1
- After updating to Grafana v10.2.3 most values are not shown HOT 1
- Influxdb key method obsolete HOT 1
- Powerflow isnt working HOT 3
- Forecast API not working HOT 7
- Grafana Problem Energy Meters/Inverter Status HOT 3
- Database not found Error HOT 5
- Integration with Powerwall Dashboard HOT 2
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from fronius-grafana-dashboard.