Time Offset with $__unixEpochGroup

Hi,

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).

Query 1:

SELECT
ts/1000 AS “time”,
val
FROM ts_number
WHERE
id=47 and
$__unixEpochFilter(ts/1000)
ORDER BY ts

shows the values against time with correct time.

if try to summarize it with:

SELECT
$__unixEpochGroup(ts/1000,‘1d’,previous) as time,
avg(val) “test”
FROM ts_number
WHERE
id=47
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,

Domi