Blake Miner

The more I think about this, the more confused I become. ;-) > I am not sure that users really expect the interval to begin from the beginning of the...

Yeah, this is a little tricky, but honestly for most users, grouping by UTC time is going to be just fine (albeit a little confusing). I think that the long-term...

For those trying to read this issue and get the TLDR; version: Problem: - With SQL data sources, Grafana groups using UTC time. This can be a problem when you...

@Zarickan - you have precisely described the issue, and there is currently no "good" way to do what you want. > The problem seems to be that the grouping is...

> In my experience it makes the fact that things are stored in a different timezone completly transparent to the "user", they just work with the data as if it...

Here's another possible workaround if you want to hardcode the timezone to use for grouping: ```sql CONVERT_TZ(FROM_UNIXTIME( UNIX_TIMESTAMP(CONVERT_TZ(created_at, 'UTC', 'US/Eastern')) DIV ($__interval_ms / 1000) * ($__interval_ms / 1000) ), 'US/Eastern',...

@daniandl - Did you happen to test any of this code? Thanks!

Sorry, I do not understand the security vulnerability here. Could you please elaborate with a specific, working example? It is not clear to me how these gadgets help attackers leverage...

I see now. Thanks for clarifying!

Any thoughts on when this can get merged?