Weird timezone problems

Grafana Dashboards
21

ew . maybe it can’t fit what you want: 7 days worth of data but you still want to see the last 7 hours?

I am out of ideas.

side point in your query

date as time,
  weather_attribute as metric,
  measurement value

to remove the word measurement.

22

I appreciate you trying! Hopefully someone else will be able to chime in with some ideas.

23

Turns out the problem also extends to alerts. I’m getting alerts several hours too late.
Any ideas are appreciated

24

Try SELECT
UNIX_TIMESTAMP(date) AS “time”,
…

25

@jrucker did you ever figure this out? I am having the exact same issue.

26

This fixed it for me! Thanks