Aggregating by day and respecting timezones

[Henjoe_Gutierrez]

Hello,

I wonder if you found solutions for this.
I am using influxQL at V1.8 and posted a question similar to this.

InfluxDB OSS 1.8 invalid data for different sampling

Hi All, I just actually notice that there is some discrepancy that I have seen in my influxDB 1.8, I just noticed it in my grafana dashboard. So here is a scenario. I tried to view a Trend graph of same measurement from my influxdb to my grafana. I add 2 queries for the same measurement, one is group by time (1d) and the other is group by (1h). Using the “first” selector in both queries, here is what I have notice. The value of my hourly (1h) at exactly 8 am is the same as the value of 1day…