1 of 1 people found this helpful
I got it. Yes, those non-values for that specific product line is causing the issue.
I guess it can't build different models for different groups.
Have you tried forecasting one at a time? Looks like you have multiple data sets in the same window.
I have multiple product groups. Yes, it will forecast one at a time, but that isn’t useful. Nor can I get a total from the daily forecast.
The goal was to replace the manual process of our finance team from going to tableau to get data, to only extract it to excel, forecast and aggregate, and then publish an ugly excel document. If I can’t show an aggregate view of how our product lines are independently growing towards an EOM finish, with independent forecast models and a EOM total, there’s not much use for the forecasting module.
Thanks for helping. Just frustrated – this seems straight forward.