Solved! Go to Solution.
Hi @tcrowley128
If you are grouping by Country, are you sorting your data using a sort tool by country then by date prior to running it in to the TS Model Factory tool? Also, if the model is being run on the Country column, you may need to aggregate your data by Country by Month first as well if you have one January for Mexico and BMW and one January for Mexico and Porsche as an example.
Hi @BrandonB thanks for the suggestions! I tried to do both of those things but the period and sub periods are still off. Any other ideas?
This screen shot is what my data looks like after the aggregation and sort
The issue is that you have multiple rows for a given time period record based on the level of grouping that you are trying to run the models on. You have your grouping field set as Country in your TS Model Factory tool, but there are multiple values in the Group column for a given country. For example, row 1 is BMW in Canada for the month of April in 2015. Row 6 is Daimler in Canada for the month of April in 2015. When you feed this in with Country as the grouping field, you have multiple rows for April 2015 for Canada.
If you want to look at a sales forecast on the country level, you need to summarize saying group by month, group by country, group by date, group by year, and sum sales where the "Group" column is disregarded. I think what you might be looking to do is create models not only for the country but also the Group (BMW, Daimler, etc). If this is the case, maybe try creating a new column using the formula tool called Grouping Field and for your formula say [Country]+[Group] to create a new concatenated field. The idea is to then use this field as your grouping field in the TS Model Factory tool.
@BrandonB Thanks for the answer. I'll give it a try and let you know!
That worked! Thank you @BrandonB