I've been working through the HW work in the online book A little book of R for time series analysis, and have started testing with some "live" customer data. I have a dataset that looks like:
CustomerName | Sales 123456 $5,000 123456 $3,455 123456 $7,540 123456 $2,300 987654 $5,600 987654 $6,700 987654 $1,300 987654 $690
Where I have
Sales values by customer for the previous 60 months. There are ~200 customers for which I'm looking to generate a forecast. I'm able to generate a forecast for a single customer at a time, but I am having trouble finding guidance on how to run the forecast for the whole group of customers and output the results.
Ideally, the output would be the regular forecast output but with
CustomerID included like so:
CustomerID | Month | Point.Forecast | Lo.80 |Hi.80 | Lo.95 | Hi.95