Energy usage one day

I’am just a beginner. I have settup Domoticz to read my energy usage whit the p1 port of my smart-meter. This data is send to influxdb. With Grafana i would like to see the daily consumption. For usage-2 i got the right value (usage 2 is between 7am - 23pm), for usage-1 is the value not right (usage-1 is between 23 pm - 7am). I tink this has something to do with the time.

I looks like

I would be great if someone could help me to fix this. :grinning:

I’ve found a solution when i GROUP BY time(1d, -2h) the values are right.
But is there also a solution like GROUP BY time(1d), TZ(“Europe/Amsterdam”)