Customer by cohorts

Hello! I am new to Alteryx and have a newbie. I am trying to do customer base calculation by cohort. M0 - customers who have just joined. M1 - customers who are 1 month old. M2 - 2 months old. Incoming number of customers is available for January. I need to populate yellow cells in Alteryx - number of customers in the coming month of February and March with a shift, i.e. customers who were M0 in January should become M1 in February and so on.

Please help me to figure out what tools to use. Thank you!

picture.PNG

Tips and Tricks

Custom Tools

Accepted answers

RolandSchubert

Hi @ValentinaZ ,

you can solve this using the Multi-Row Formula tool - you can address previous (or subsequent) cells. Group by option to move cells only within a country. To add a bit flexibility regarding order of rows, you can convert month names to month numbers and sort. I've attached a sample workflow. Hope this is helpful.

Best,

Roland

Cohort.yxmd

All comments

grossal

I'd convert the Month cell into a date cell, but you would need to have the information about the year for this to work properly. You could than use a formula tool and "DateTimeDiff([original_date], DateTimeNow() , "months") to calculate the difference in months.

RolandSchubert

Hi @ValentinaZ ,

Best,

Roland

Cohort.yxmd

ValentinaZ

It worked! Thank you very much!

Is there a way to refer to month name somehow instead of specifying how many lines above formula should look?

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703