ha-puzzles / evcc-grafana-dashboards

Grafana Dashboards for EVCC
17 stars 2 forks source link

Falsche Berechnung für Autarkie und Eigenverbrauch im PV Today Verlaufschart #21

Closed cschlipf closed 1 month ago

cschlipf commented 3 months ago
image

Autarkie sollte hier eigentlich bei 100% sein.

cschlipf commented 3 months ago

Fix:

Netzbezug:

SELECT integral("subquery") /3600 FROM (SELECT mean("value") AS "subquery" FROM "gridPower" WHERE $timeFilter and value >=0 GROUP BY time(1m) fill(0)) WHERE $timeFilter GROUP BY time(15m) fill(0)

Eingespeist:

SELECT integral("subquery") /-3600 FROM (SELECT mean("value") AS "subquery" FROM "gridPower" WHERE $timeFilter and value <=0 GROUP BY time(1m) fill(0)) WHERE $timeFilter GROUP BY time(15m) fill(0)