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?