I’m using a MySQL table which holds my power consumption in kwh (this table is a result of the calculated average over 5 minutes), the datetime field is of the type ‘datetime’
In the table you can see there is a higher usage, above 2kwh between 8:45 and 9:05am
The selection query is:
SELECT UNIX_TIMESTAMP(datetime) as time_sec, CurrentUsage as value, location as metric FROM `Power-SUM` WHERE $__timeFilter(datetime) ORDER BY datetime ASC
When viewing ‘today’s’ view I do see the spike, and the rest of the data until the time of the snapshot (10:50)
However when selecting the ‘last x hours’ , I can see the start of the spike, but not the rest of the data.
I’m sure this has something to do with my timezone (Amsterdam, which is GMT+2 (CET), (but if I change the timezone in the preferences to UTC, it actually shifts the graph backwards with 2 hours, so then suddenly the spike is at 7am)