Customer by cohorts
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!
Solved! Go to Solution.
- Labels:
- Custom Tools
- Tips and Tricks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?
![](/skins/images/2A479D0ADEFDAA8078B5B9F489A80DDD/responsive_peak/images/icon_anonymous_message.png)