Hey @vincent-benbria ! This is indeed a tricky issue. Unfortunately, there's no straightforward solution to that other than to have pre-aggregation per timezone. The reason for it, not all timezones have whole-hour shifts like IST so most of the time hourly granularity doesn't help, and minute one doesn't make sense. Even if we can reduce the timezone set to whole hour shifts daylight saving time becomes the next problem because it's different in each timezone.

If you have a lot of tenants most likely you want to consider grouping tenants in one pre-aggregation table and have pre-aggregations per timezone.

Yes, I do realize that there are half-hour timezones and such.

I am asking for the ability to specify which timezones is aggregated PER tenant, so that my Chinese tenant data is not also preaggregated for EST simply because I also have EST tenants.

@vincent-benbria I see what you're saying. Yeah. It makes sense to have an option to control it on a per-tenant level. I guess it should be done here:
https://github.com/cube-js/cube.js/blob/d143d4dda87a9fac4139fdf47f70b3cdc0b0009b/packages/cubejs-server-core/src/core/server.ts#L783

Looking forward to contributions here!

If you are interested in working on this issue, please leave a comment below and we will be happy to assign the issue to you.
If this is the first time you are contributing a Pull Request to Cube.js, please check our contribution guidelines.
You can also post any questions while contributing in the #contributors channel in the Cube.js Slack.