Thank you in advance for the help!
I have the attached dataset tagged by the following 4 attributes:
- Account ID = unique customer
- Month = month / year of customer data
- ARR = company ARR
- Time period = # of months since first joining (i.e., 0 = first month, 1 = 1 second month, etc.)
I am trying to do the following 2 tags in Alteryx, but have spent a few hours and have failed. Any workflow examples would be super great:
- I am trying to do a calc where for each Account ID, you divide their max time period by their Time Period = 1. For example, if an AccountID has 16 as their highest Time Period, the calculation would be their ARR for Time Period 16 divided by Time Period =1
- I am trying to calculate year over year growth rate for each account, so I want to add in the following tags based on the following calcs (but not all account IDs will have all of these figures since some accounts are only present for a few months
- Year 1 growth = ARR for Time Period 13 divided by Time Period 1
- Year 2 growth = ARR for Time Period 25 divided by Time Period 13
- Year 3 growth = ARR for Time Period 37 divided by Time Period 25
- Year 4 growth = ARR for Time Period 49 divided by Time Period 37
- Year 5 growth = ARR for Time Period 61 divided by Time Period 49
- Year 6 growth = ARR for Time Period 73 divided by Time Period 61
- Year 7 growth = ARR for Time Period 85 divided by Time Period 73
- Year 8 growth = ARR for Time Period 97 divided by Time Period 85
- Year 9 growth = ARR for Time Period 109 divided by Time Period 97
Workflow suggesting to get these done would be super appreciated -- thank you in advance!