community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
#SANTALYTICS

The highly anticipated Alteryx Community tradition is back! We hope you'll join us!

Learn More

Cohort analysis in a crosstab

Meteoroid

Hello Comunity,

I would like the numbers in the blue thing to be where it is null so it follows the logic of the cohort analysis. If you do have any clue on how to perform this, please help.

 

Capture populated fields.PNG

 

 

This is how the raw data looks.

Picture1.png

Thanks!

Alteryx
Alteryx

Hi there

 

Prior to crosstabbing your data (I assume you are referring to the Value column - in the Crosstab tool itself to populate the values), you just need a formula in a Formula tool to check if the Value column is null, then populate the Value column with the ACC_NO_START DATE Value.

 

Then you can crosstab as you would 

Meteoroid

Hello I used this formula:

 

IF IsNull([Row-1:Value])
and [Row-1:ACCT_NO_START DATE]=[ACCT_NO_START DATE]
and [Row-1:Card Start Date (2)]=[Card Start Date (2)]
and [Row-1:COMPANY]=[COMPANY]
and [Row-1:ACCOUNT_TYPE]=[ACCOUNT_TYPE]

THEN [ACCT_NO_START DATE]
ELSE [Row+1:Value]+1
ENDIF

 

But it just worked for the first rows, then, it does not:

Capture.PNG

Labels