today I started using Grafana and everything went fine with the gauge. But then I wanted to implement a graph and my whole data is shifted for about 1 hour.
When I look into my MSSQL database I get to zero value on this timestamp:
But in Grafana it looks like this:
So it is shifted by exactly 1 hour. Does it convert my data with some time zone functions or anything like that?
Also the gauge got the right (newest) value and the graph not with the same query?!
So basically data that is 1 hour old gets used with the timestamp of current time but only in graph.
zeitstempel AS time,
taktleistung_ist AS IST_TAKT
WHERE maschine = ‘maschine1’ AND zeitstempel >= DATEADD(day, -7, GETDATE())
ORDER BY 1 DESC
I had to limit the data to 1 week because there are more than 1 million rows.
Thanks for answers in advance!