This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I'm trying to forecast product sales for each of 66 products using two years worth of historic data. I have grouped the days up by weeks, and my weeks format is 1, 2, 3 , (a single number). The key thing is that , our working calendar starts on Friday, so this poses problems for any forecast.
I created my own week lookup and would like the ARIMA model to lookup my week column for the forecast.
When selecting ARIMA model, i must specify, my column for sales and a period to group by, I want to select week, but it wont work.
I've posted a snapshot of my data, in excel format, i have a unique identifier for product, but i haven't included that in the file.
If you mean it freezes, thats probably because you havn't aggregated your data to the correct level, so it's doing a forecast thinking it has 38,818 weeks of data in, which isn't the case and this is making alteryx go a bit crazy!
So make sure you use a summerize tool, and as mentioned if you then want a forecast per group then you must use the TS Factory tools on the gallery.