Hi Everyone,
I'm new to Time Series and so need a little help. I am trying migrate some modelling in Excel to Alteryx, one in particular relates to modelling sales for Brand B based on the historical trended sales of Brand B. In excel I am able to use the coefficient of a time series of historical sales of brand A to model out what the sales of brand B should (theoretically) be. How do you do that in a Alteryx workflow?
In the attached workflow I want to perform the following:
1. run a timeseries forecast for brand A for period before brand B's launch (done)
2. use the coefficient from step 1 above to forecast brand A's sales for period after brand B's launch - how to do this?
3. use the coefficient from step 1 above to forecast brand B's sales for period after brand B's launch - how to do this?
thanks
Solved! Go to Solution.
Hi @LIOUJ ,
You just need to snaffle the coefficient values from the data, which comes out of the O output of the Time Series model as a blob. You can convert the blob and hack out the bits and pieces manually, or you can use a bit of R code ( that I borrowed from @AndrewKramer from THIS feed).
You should now have the following columns:
You can now add these to the second model.
Hope this helps,
M.