Linear regression - datefield input

uhoelker

Dear all,

I'm aiming to do a simple linear regression but I struggle to properly input my data. I have the following fields:

Year (Integer)
Month (Integer)
KPI (Double; will help to forecast the Target KPI)
Target KPI (Double)

See below a snippet of the input data:

input data.JPG

What I did so far is:

Lin Reg.JPG

As you can see the fields 'Year' and 'Month' are treated individually. Instead, I'd like to create a combined date field such as yyyy-mm-01 and use this as a predictor together with the field 'KPI'.

However, when I do this, the newly created date-field doesn't show up in the predictors menu.

In Tableau, where this work is done in the background, the result looks quite nice:

Can someone please point me in the right direction to create my regression based on the 2 predictors 'Date' and 'KPI'?

Many thanks in advance

input data.JPG

Predictive Analysis

Accepted answers

OllieClarke

@uhoelker as @alexnajm says you'll want to use a time series tool (ARIMA or ETS) to do a time series prediction most likely.

However, you can combine the Year and Month fields to create a new numeric field with a formula like: