Hi All,
I need to create a new column to group weeks dynamically i.e., current week + 2 weeks.
can some one help how can we do this in alteryx.
for example if we are in week 1 (Current week) then grouping should be as below:
Week | Group |
Week 1 | 1 - 3 |
Week 2 | 1 - 3 |
Week 3 | 1 - 3 |
Week 4 | 4 - 6 |
Week 5 | 4 - 6 |
Week 6 | 4 - 6 |
If we are in 2nd week (Current week) then grouping should be
Week | Group |
Week 2 | 2 - 4 |
Week 3 | 2 - 4 |
Week 4 | 2 - 4 |
Week 5 | 4 - 7 |
Week 6 | 4 - 7 |
Week 7 | Week 4 - 7 |
Solved! Go to Solution.
Grouping will be 50-52 if it starts from week 2
Grouping will be 52-54 if it starts from week 1
@ponrajThank You.
but for example if we are in week 52.2018 then it should group 52 + 2 that will be 52.2018 - 2.2019
i tired fixing it using if formula is there any better way where i can achieve it