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.

1 Like
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”,
…

1 Like
25

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

26

This fixed it for me! Thanks