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.
I appreciate you trying! Hopefully someone else will be able to chime in with some ideas.
1 Like
jrucker
23
Turns out the problem also extends to alerts. I’m getting alerts several hours too late.
Any ideas are appreciated
Try SELECT
UNIX_TIMESTAMP(date) AS “time”,
…
1 Like
@jrucker did you ever figure this out? I am having the exact same issue.
This fixed it for me! Thanks