I've got this requirement in my lap for a while, and I couldn't find how to implement it anywhere.
I need to be able to yield an aggregation where it is possible to filter by a given quarter (from 1 to 4). For example:
My_Date_Field = 1 or 3 (the first or third quarter of the year, regardless the year itself).
I'm currently doing that when the data is been ingested, by creating a column with the quarter that the given date belongs to.
The problem with that is, I can't support time zone unless I create one dimension for each region around the word.
The problem is the same for the other mentioned dimensions.