Hi,
I’m resampling energy (kw) data at 60 minute intervals to get the following bar chart.
However, as you can see, the resampling is over a 24 hour period and the timestamps returned show the end of the sampling period. i.e. data between 00:00 and 01:00 (midnight and 1am) shows as 01:00… This is a problem because we never get to see data between 23:00 and 00:00
It’s almost like I have to shift everything back one hour… I have tried with expressions but can’t seem to isolate time. Can anyone help me with this please.
SQL:
SELECT time,energy_pos_balanced,serial FROM "Sensor Data" WHERE serial = 'xyz' and time BETWEEN '${__from:date:iso}' AND '${__to:date:iso}'
ORDER BY time
Data coming from SQL:
"Time","B 10000000ea20043b"
2024-05-24 00:00:00,
2024-05-24 01:00:00,1092
2024-05-24 02:00:00,1094
2024-05-24 03:00:00,1099
2024-05-24 04:00:00,1101
2024-05-24 05:00:00,1104
2024-05-24 06:00:00,1134
2024-05-24 07:00:00,1770
2024-05-24 08:00:00,3860
2024-05-24 09:00:00,6777
2024-05-24 10:00:00,7143
2024-05-24 11:00:00,6234
2024-05-24 12:00:00,6485
2024-05-24 13:00:00,6371
2024-05-24 14:00:00,6641
2024-05-24 15:00:00,5560
2024-05-24 16:00:00,5405
2024-05-24 17:00:00,6166
2024-05-24 18:00:00,4293
2024-05-24 19:00:00,4288
2024-05-24 20:00:00,4403
2024-05-24 21:00:00,4494
2024-05-24 22:00:00,4578
2024-05-24 23:00:00,4811
