In IoTaWatt i’m sending folowing measurements: (along some other stuff )
- Verbruik: Watts = Fase1 + Fase2 + Fase3
- verbruikkWh: kWh = Fase1 + Fase2 + Fase3
- Export: kWh = (Fase1 abs + Fase2 abs + Fase3 abs + Fase1 + Fase2 + Fase3) ÷ 2 - (Fase1 + Fase2 + Fase3)
post interval is 10sec and bulk send 6
However if i compare them in grafana there is a big difference between the Total daily kWh directly from IoTaWatt and the one calculated in grafana: At 8PM: from IoTawatt: 19.96kWh vs 20.50kWh calculated.Earlier at the day the difference is bigger.
I’m using:
For the kWh calculated from Watt:
SELECT mean(“Watts”) FROM “iotawatt” WHERE (“ct” = ‘Verbruik’) AND $timeFilter GROUP BY time(1h) fill(null)
In options stat: “Total” and in Time range “now/d”
For the kWh from IoTaWatt:
SELECT sum(“kWh”) FROM “iotawatt” WHERE (“ct” = ‘VerbruikkWh’) AND $timeFilter GROUP BY time(1h) fill(null)
In options stat: “Total” and in Time range nothing (default 1h)
The dashboard is setup for “Today so far”.
The difference between the “export” is even bigger: 17.05kWh (from IoTaWatt) vs 10.33kWh calculated in grafana.
I use:
Calculated in grafana:
SELECT ( (ABS(mean(“Watts”)) + mean(“Watts”))/2 - mean(“Watts”) ) FROM “iotawatt” WHERE (“ct” = ‘Verbruik’) AND $timeFilter GROUP BY time(1h) fill(null)
In options stat: “Total” and in Time range “now/d”
From IotaWatt: the same type as Verbruik. (in IoTaWatt it’s calculated the same way)
Any idea’s what i’m doing wrong?