How to do a forcast for multiple companies

IvanMtz

Hello Community 

I have a question is just that I need to do a forecast for each company that we do business I have a file that is as an example like this:

Company # |  Company Name |  Amount Paid | Payment Date |

11111111         Company 1                  10                10/08/2021

11111112         Company 2                  11                10/08/2021

11111111         Company 1                  15                10/08/2021

11111113         Company 3                  30                10/08/2021

11111111         Company 1                  10                10/08/2021

11111111         Company 1                  10                10/08/2021

11111112         Company 2                  11                10/08/2021

11111111         Company 1                  15                10/08/2021

11111113         Company 3                  30                10/08/2021

11111111         Company 1                  10                10/08/2021

With what tool I can do a forecast without filtering per company and do a forecast for each company.

Thank you in advance 

Have a nice weekend!

danilang

Hi @IvanMtz 

None of the Time Series tools allow you to group by.  You'll have to use a batch macro.  Here's the basic structure 

The control parameter modifies the Filter to select records for the current company and also modifies the Model Name attribute in the ETS tool so you'll be able to associate the values with the companies.

Note that the attached doesn't run as is, since your input data only has values for one date.

Dan 

GroupedForecast.yxzp