Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Dynamic grouping / contious serious

Shank
8 - Asteroid

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:

 

WeekGroup
Week 11 - 3
Week 21 - 3
Week 31 - 3
Week 44 - 6
Week 54 - 6
Week 64 - 6

  

If we are in 2nd week (Current week) then grouping should be

 

WeekGroup
Week 22 - 4
Week 32 - 4
Week 42 - 4
Week 54 - 7
Week 64 - 7
Week 7Week 4 - 7

 

4 REPLIES 4
ponraj
13 - Pulsar

Here is the sample workflow.  Hope this is helpful. 

 

Dynamic grouping contious serious - workflow2.PNGDynamic grouping  contious serious - Workflow.PNG

Shank
8 - Asteroid

@ponraj 

 

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

ponraj
13 - Pulsar

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

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

Shank
8 - Asteroid

@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

 

 

Labels