Hi
I'm trying to build a simple forecast model based on certain categories. In addition, I want to be able to update this dynamically on a monthly basis.
Data
Stage | Start Date | Leave Date | Jan-20 | Feb-20 | Mar-20 | Apr-20 | May-20 | Jun-20 | Jul-20 | Aug-20 | Sep-20 | Oct-20 | Nov-20 | Dec-20 |
Actuals 1 | N/A | N/A | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | |||
Actuals 2 | N/A | N/A | 1 | 1 | 1 | 1 | 1 | 1 | ||||||
Actuals 3 | N/A | N/A | 1 | 1 | 1 | 1 | 1 | 1 | 1 | |||||
Actuals 4 | N/A | N/A | 1 | |||||||||||
Known Joiner | 10/15/2020 | N/A | 1 | |||||||||||
Known Leaver | 10/31/2020 | -1 | ||||||||||||
Open Role 1 | 10/15/2020 | |||||||||||||
Open Role 2 | 11/20/2020 |
Desired Output
Stage | Start Date | Leave Date | Jan-20 | Feb-20 | Mar-20 | Apr-20 | May-20 | Jun-20 | Jul-20 | Aug-20 | Sep-20 | Oct-20 | Nov-20 | Dec-20 |
Actuals 1 | N/A | N/A | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
Actuals 2 | N/A | N/A | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | |||
Actuals 3 | N/A | N/A | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | ||
Actuals 4 | N/A | N/A | 1 | 1 | 1 | 1 | ||||||||
Known Joiner | 10/15/2020 | N/A | 1 | 1 | 1 | |||||||||
Known Leaver | 10/31/2020 | -1 | -1 | -1 | ||||||||||
Open Role 1 | 10/15/2020 | 1 | 1 | 1 | ||||||||||
Open Role 2 | 11/20/2020 | 1 | 1 |
Thank you for your contribution to the Community!
To help make it easier for others to assist, it would be helpful to get some additional information on your process. Here's what we recommend you include in your reply:
* What Alteryx Version are you using?
* Do you have a Workflow with sample data you can share?
Posting for Fastest Possible Solution (https://community.alteryx.com/t5/Alteryx-Community-Resources/Posting-for-Fastest-Possible-Solution/t...)
Thank you very much!