Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Alteryx tagging help

datausernyc0419
7 - Meteor

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:

  1. 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
  2. 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
    1. Year 1 growth = ARR for Time Period 13 divided by Time Period 1
    2. Year 2 growth = ARR for Time Period 25 divided by Time Period 13
    3. Year 3 growth = ARR for Time Period 37 divided by Time Period 25
    4. Year 4 growth = ARR for Time Period 49 divided by Time Period 37
    5. Year 5 growth = ARR for Time Period 61 divided by Time Period 49
    6. Year 6 growth = ARR for Time Period 73 divided by Time Period 61
    7. Year 7 growth = ARR for Time Period 85 divided by Time Period 73
    8. Year 8 growth = ARR for Time Period 97 divided by Time Period 85
    9. 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!

3 REPLIES 3
CoG
14 - Magnetar

Here you are!

ARR Solution.png

datausernyc0419
7 - Meteor

Thank you so much for the help here! 

 

I just ran this, but one question on the following years tag. I don't think it is dividing the right time periods currently. For example, Year 2 should be Time Period 25 divided by Time Period 13, but I think currently it is ending up taking Time Period 29 divided by Time Period 13 (similarly occurs for the following years). Any thoughts? 

 

  1. Year 1 growth = ARR for Time Period 13 divided by Time Period 1
  2. Year 2 growth = ARR for Time Period 25 divided by Time Period 13
  3. Year 3 growth = ARR for Time Period 37 divided by Time Period 25
  4. Year 4 growth = ARR for Time Period 49 divided by Time Period 37
  5. Year 5 growth = ARR for Time Period 61 divided by Time Period 49
  6. Year 6 growth = ARR for Time Period 73 divided by Time Period 61
  7. Year 7 growth = ARR for Time Period 85 divided by Time Period 73
  8. Year 8 growth = ARR for Time Period 97 divided by Time Period 85
  9. Year 9 growth = ARR for Time Period 109 divided by Time Period 97
CoG
14 - Magnetar

This is what the workflow is generating on my end, is this incorrect?

2023-11-12_ARR Solution2.png

Labels
Top Solution Authors