Dynamic grouping / contious serious

[Shank]

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

[ponraj · Accepted solution]

Here is the sample workflow.  Hope this is helpful. 

[Shank]

@ponraj 

how to fix when we are in week 52 it should be 52 + 3 that is week 3 

[ponraj]

Grouping will be 50-52 if it starts from week 2

Grouping will be 52-54 if it starts from week 1

[Shank]

@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