I have this query:
`SELECT max("value") FROM "kWh" WHERE ("entity_id" = 'barn_water_tank_daily_default') AND $timeFilter GROUP BY time(1d)`
Shows this table:
Date | KWh Used |
---|---|
2019-09-21 | 3.65 |
2019-09-20 | 7.50 |
2019-09-19 | 7.38 |
2019-09-18 | 0.22 |
However, the 3.65 marked as 2019-09-21, is actually todays max reading 2019-09-22
doing a query directly against the influxdb via chronograf gets me the correct results
SELECT max("value") FROM "ha_house"."autogen"."kWh" WHERE time > :dashboardTime: AND "entity_id"='barn_water_tank_daily_default' group by time(1d)
what’s going on? how do i fix this?
Thanks!