hi all, my data are from 2022/02/22 00:00~15:58, but I check the relative time ranges to latest 5 minutes (down picture), all the time was shifted 8 hours and had different values. How to adjust them with time and values matching?
what does your data look like in the DB? Why are you wrapping time_0 in UNIX_TIMESTAMP() functon?
I’m guessing that there is some collision happening between that and the timefilter macro. I would also check the raw query that each of these in generating and see how they differ…
Ya, I got it. After your suggestion, we make the time zone become consistent and then solve this problem.
1 Like