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?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.