Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
The Expert Exam is now live online! Read about the specifics and what it took to bring it to life in the blog by our very own Elizabeth Bonnell!

Cohort analysis in a crosstab

Highlighted
6 - 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!

Highlighted
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 

Highlighted
6 - 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