How do you group by week in a widget?
Question Description:There is no option to group by 'week'. How can I group by week?
Answer:
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?