Discrepancy between Emporia totals and Vuegraf/Influx/Grafana totals.

[poorredneck]

Not sure what logs to include. Please let me know what logs if any are needed.

For all intensive purposes everything seems to work fine. No big missing chunks of time on any graphs, etc. Any who the totals from Influx/Grafana are consistently off.

This is the influx query:

SELECT sum("usage") / 3600 FROM "energy_usage" WHERE ("device_name" = 'House') AND $timeFilter

vuegraf Json:

{
"influxDb": {
"host": "XXX.XXX.XXX.XXX",
"port": 8086,
"user": "XXXXXXX",
"pass": "XXXXXXXXXXXXXXXXXX",
"database": "vue",
"reset": false,
"ssl_enable": false,
"ssl_verify": true,
"historyDays": 0
},
"accounts": [
{
"name": "House",
"email": "XXXXXXXXXXXXXXXXXXXXXXXXXXXX",
"password": "XXXXXXXXXXXXXXXXXXXXXXXXXXX",
"devices": [
{
"name": "House",
"channels": [
"Pool Heater",
"Pool Pump",
"Living Room/Lights",
"Pool Outlet",
"Water Heater",
"Dryer",
"Washing Machine",
"Hot Tub Outside Outlets Garage",
"Master Bedroom",
"Dishwasher",
"AC Heatpump",
"Blower Motor Emer Heat",
"Lorelei and Logan Bedrrom",
"Microwave",
"Kitchen Dining Outlets",
"Refrigerator"
]
}
]
}
]
}

[jertel]

See the last paragraph, specifically the last sentence, of #57 --> Perhaps you're summing duplicate data. It could also be possible that Emporia uses a different timezone boundary for daily aggregations than your Grafana queries.

[poorredneck]

Bingo! Detailed=True fixes it, for previous time periods. Throws off "current day" metrics but that I can live with that, as those panels I only pay attention to for previous days anyways.

Thanks!