Creating a forecast… Particularly, choosing the right method to forecast… Depends quite a lot on the goals of the project, available data, how accurate it needs to be, whether external factors might influence the forecast, etc.
If you can provide a little more context to what you have at your disposal, someone can probably help you.
Like @Snowy said: it would be helpful if you could give us some more details.
Then. We had a somewhat similar discussion about the prediction of numeric targets (unemployment in the UK) here:
This resulted in a collection of workflows (please consider the whole workflow group):
Or this:
Then there is this collection about machine learning methods. In your case a regression model might be the right one. Or you might have to use something to predict based on time series (no collection for that, yet):
Often it does make sense to familiarise yourself with several methods and especially think about your business case and the data you have available and if what you want to find is somewhere in the data you have.
Basically its this competition, who I should solve with a linear regression and a loop.
The task is to predict the sales from each store for Juli 2015 (next 31 days).
We should only concentrate at the “train” and “test” data. I cant upload the both data because they are .csv-Data but you can have an access at the link I posted.
I tried to create a Workflow but somewhere there is an error. The Workflow is attached and a screenshot also.
I think a recursive loop is not necessary. The Workflow should be easy and understandable but also exactly as possible.
Can’t execute your flow as I don’t have the data but if you filter out the dates
$Date$<=“2015-06-30”
in your first row splitter then I am not sure why you do the same for the second spiltter
$Date$<=“2015-06-30” => TRUE