I can’t get my data to display in the right time. I’m not sure why, but I get a 2hour gap in the start of the graph, while the data is available in MySql:
What also is very strange is that 2 graphs with exactly the same structure have different time offsets. As you can see the pressure graph latest datapoint is 10:55, while the solar latest datapoint is 12:25. In MySQL the times are exactly the same:
Query for the pressure graph:
SELECT datetime AS "time", pressure FROM weather_stats WHERE $__timeFilter(datetime) ORDER BY datetime
Query for the Solar graph:
SELECT datetime AS "time", solar FROM solar WHERE $__timeFilter(datetime) ORDER BY datetime
The pressure (upper graph) is stored in MySQL like this:
And the Solarpanel information is stored like this:
As you can see, the date & time are exactly the same, but in the graph the solar panels are 2 hours ahead!
I’ve changed the timezone in grafana several times (Defaul/local browser/UTC), but that doesn’t change anything.
The time on the grafana server (MySQL is also running on that server):
Mon Jun 17 11:02:20 CEST 2019
The time on my laptop (browser time):
ma 17 jun 2019 11:02:20 CEST (Dutch notation)
I’m using Grafana v6.2.2
I just can’t figure out what is going on. Can anyone help me?