I am currently happily runnig
Hass.io on my RaspberryPi Zero W.
Because I like graphs, i switched to MariaDB as my database so I can create some dashboards with Grafana. The Pi Zero does not support InfluxDB and i use Grafana in the Cloud.
Now the only problem I’m facing is that in Grafana, the values from all entities are -02:00 hours off. While it is 3pm in Berlin, the current values are displayed at 1pm.
When i use Squirrel to access my MariaDB, i used commands like
I get the correct time of 3pm
SELECT TIMEDIFF(NOW(), UTC_TIMESTAMP);
I get 02:00 as a result, which is the correct offset.
But how can i tell Grafana to also use the correct time zone?
I tried playing with the time zone settings in Grafana (setting it to UCT, default, local-browser-time) but only changing it to UCT made a difference (offsetting even further).
This is an example of my temperature sensor in Grafana:
SELECT $__timeGroupAlias(last_updated,1m), avg(state) AS "Temp Wohzimmer" FROM states WHERE entity_id = 'sensor.temperature_wohnzimmer' GROUP BY 1 ORDER BY $__timeGroup(last_updated,1m)
Hass.io in the meantime displays graphs correctly without any offset.
What can i do to tell Grafana that the time values should all be shiftet 2 hours?
Can i somehow create a new column in my MariaDB that tells Grafana the shifted hours, without messing up the Graphs in
Any help is welcome
Greetings from Berlin