absolutely new in Grafana and Mysql, so sorry for that. i spent a lot of hours to find a solution in web for my problem with no success. I use the iobroker in a docker container for my smart home system. inside the broker runs the sql adapter which is writing values into my mysql database on my Syno-Nas. So far, everything works great. Try to request values from the db works fine, also the timeline seems to be correct. But if I try to group one value per 24h i will get a time offset of 1 h.
Comparison with same Dashboard settings and Same Value (Time in db ist till Epoch in ms, System Time is UTC+1).
ts/1000 AS “time”,
ORDER BY ts
shows the values against time with correct time.
if try to summarize it with:
$__unixEpochGroup(ts/1000,‘1d’,previous) as time,
group by 1
ORDER BY 1
the result is summarised from 1 to 1 istead of 0 to 0 hour.
does anybody have the same issue?
Thanks in Advance,