at first Merry Xmas and stay healthy to all.
I got a problem with a Integral Query via InfluxDB in Grafana. I got a table with positive and negative power-values from my house-grid in Influx DB (time is in seconds, power in Watt). Positive is power that serve the provider, negative is the power that i sell to the provider from my PV-Installation. Now i want to separate the table in “power from provider” and “power to provider”, integrated and grouped for each day in kWh.
The way i tried for “power to provider” is:
so when look into the values for the last 7 days (time range in dashboard now-7d) the result is:
compared with the app from the pv-provider I have huge deviations for each day. So i tried several things to get the values closer with no success. What i found out is: Changing the time range in Panel to one specified day gives another result for the Integral.
I am wondered about that behaviour.
appreciated for any help that could solve my problem.