Alteryx Designer Desktop Discussions

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

VERY VERY Urgent help required Please

Swaraj8565
7 - Meteor

Hi 

This is a cohort chart the repetition depends on the divide number 

Attached the Image of the workflow.

ProductDivide JanFebMarchApr
A2Jan1   
A2Feb12  
A2Mar 23 
A2Apr  34

 

Very urgently required please help

 

Input table is 

ProductDivideJanFebMarApr
A21234

 

Hoping for a best possible earliest response

 

16 REPLIES 16
danilang
19 - Altair
19 - Altair

Hi @Swaraj8565 

 

You said "Nowadays we need the use of cohort everywhere"  What is "Cohort"? can you send me a link? Are you referring to cohort analysis?

 

Dan 

Swaraj8565
7 - Meteor

This is an example of cohort

 

Requesting you again to give me the solution workflow if any for this problem 

 

INPUT:

 

ProductDivideJanFebmarApr
A41234
B31234
C21234

output should be 

ProductDivideJanFebmarApr
A41   
A412  
A4123 
A41234
A4 234
A4  34
A4   4
B31   
B312  
B3123 
B3 234
B3  34
B3   4
C21   
C212  
C2 23 
C2  34
c2   4

 

 

danilang
19 - Altair
19 - Altair

@Swaraj8565 

 

Post what you have so far, and I'll help you through it.

 

Dan

huynv96
9 - Comet

Oh, sorry, I did not consider divide column. Here is solution

Change Generate Row (4) value 4 with your month on input2.PNG

Output:

1.PNG

Swaraj8565
7 - Meteor

Hey

 

Thanks a lot 

for giving your valuable time for solving my problem.

 

Thanks again 

 

Regards

Swaraj

Swaraj8565
7 - Meteor

Swaraj8565_0-1582480989772.png

Hey @danilang

Its not working out in cross tab request you to kindly help

 

Please

danilang
19 - Altair
19 - Altair

Hi @Swaraj8565 

 

Good work.  You were very close.  Delete the recordID and Group By [Product] and [Divide] in the Multi row.  Change the Summarize to count distinct month names and add a group by on RowCount in the Cross tab

 

nw.png

 

Dan

Labels