Sales Forecast with recursive loop

[mlauber71]

@Patrick92 welcome to the KNIME forum

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:

Can KNIME be used to show the employment and unemployment rate in the UK from the year 2008-2018, showing the prediction for the next year?

I set up an environment that first transforms you data from 2008-2016 into a table that has the Area (region) as an ID since I understand that is the unit you would want to predict. [image] The Target is taken from 2017 “Emp UK percent”. If you want Unemployment you would have to change that. The years are transformed into columns, while the first year of the data becomes _0 and the year before that _1 and so on. [image] Then I construct a Test dataset using the data of past 9 years from …

This resulted in a collection of workflows (please consider the whole workflow group):

compare several regression models on historical unemployment data – mlauber71

Or this:

Unsupervised machine learning (gradient boosting regression)

I set up an example that should look like your data (if not feel free to adapt and inform). We have two years of data (from one city) and data from January and want to predict the coefficient for Feb 2020. [image] 2019 serves as training and 2018 as test data. You might have more complex settings with cross-validation if you want. And also since you have the data you might provide coefficients of some more past months. Each line represents its own time series so to speak. Of course, such a se…

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):

Machine Learning Meta Collection (with KNIME) – mlauber71

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.