Future Monthly Projection / Forecast Trend

ninogmiranda

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

TrevorS

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/ta-p/178481)

Thank you very much!