How do you group by week in a widget?
There is no option to group by 'week'. How can I group by week?
To normalize week representation, we offer various ISO WEEK aggregations. The ISO WEEKS notation starts on the first Thursday of the year.
To group by week you have multiple options: ISO WEEK, MONTH ISO WEEK, YEAR MONTH ISO WEEK. Each of these will group by ISO WEEK but with respect to different timeframes.
ISO WEEK: Values for the same ISO WEEK.
Month ISO WEEK: Values for the same ISO WEEK in the same MONTH.
YEAR MONTH ISO WEEK: Values for each ISO WEEK in each YEAR and MONTH.
Was this article helpful?