Hi,
I need help with a code for R script. I need to use Arima.
I have 3 years of sales data on month level, for X number of store and Y number of categories.
I need to create a forecast per store, per category for the next 3 months (on month level), and I need the data to be written to a table so that I can make measures using this data.
I can get it to run for one store, one category, but I need R to somehow do a loop, so that I get the forecast for each store and each category. So, when finished with the first category for Store 1, I need it to do the same for category 2 - Store 1. When it is done with all categories for Store 1, it needs to move on to store 2 and do the same for all categories.
Example of data:
Month | Store Name | Category |
01.2018 | Store 1 | Category 1 |
01-2017 | Store 1 | Category 1 |
01-2016 | Store 1 | Category 1 |
01.2018 | Store 1 | Category 2 |
01-2017 | Store 1 | Category 2 |
01-2016 | Store 1 | Category 2 |
01.2018 | Store 2 | Category 1 |
01-2017 | Store 2 | Category 1 |
01-2016 | Store 2 | Category 1 |
Thank you in Advance.
/Kristina
