Hello Everyone,
Looking for some guidance in time series forecasting with the attached data-set example
Weekly Subclass Forecasting
I want to forecast both net sales and net quantity at the subclass level weekly, utilizing 104 weeks of historical data
I want to use ARIMA and ETS and forecast the weekly value (but i'm currently having trouble with ETS populating in my current workflow) & also compare both the models using TS Compare.
I need assistance in creating a batch macro that will organize my data by subclass and forecast off of only that subclass data, but I really am having trouble creating a batch macro to do this.
I found a dated thread here: Solved: Re: Time Series Forecasting - Alteryx Community but it doesn't allow me to re-do the batch macro in any of the examples that were given.
Also is there an easy way to output the data results into Excel?
Any assistance you can provide would be greatly appreciated.
