# Overview

The Grouped Forecast Processor uses multiple decision methods for creating arbitrary forecasts on grouped data series.

# Input

The processor has two input ports. The first input contains relevant data, training and test datasets are combine into one dataset and each type is referred to by a signal column. The second input is currently not used, it can be connected to some arbitrary data (e.g. empty table).

Note that the relevant input data should contain one grouping column.The models and forecasts will be computed for every group separately.

# Configuration

The available forecasts methods are the following (links for further information are also provided):

Decision/Regression trees are automatically selected depending on the type of the dependent column: text, timestamp and integer columns lead to a decision tree, double and numeric columns lead to a regression tree.__Decision tree:____Linear regression:__Computes statistical metrics over the given training sets and uses these measures as forecast values, e.g. by using "Average" as forecast function, all to-be-forecasted data will have the average of the training dataset as forecasted value.__Arithmetic forecasts:__Fits an AR(I)MA (Autoregressive (Integrated) Moving Average) or AR(I)MAX (AR(I)MA with exogenous regressors) model, where the latter includes exogenous variables that must be provided by the user as additional attributes. An AR(I)MA model is determined by an intercept, the number of autoregressive coefficients (p), the number of moving average coefficients (q) and the differencing order d. Moreover, the user can select if the model includes an intercept or a trend. For ARIMAX models with differencing order d > 0 and exogenous regressors, the intercept is interpreted as a stochastic trend, also called drift.__ARIMAX forecasts:__Boosting is an ensemble technique in which the predictors are not made independently, but sequentially.__Gradient boosting:____SVM forecasts:__Uses first order Hidden Markov Models (HMM) for sequence labeling. Each group determined by the grouping column is assumed to have multiple sequences of which some are marked with the training signal. The transition, emission and initial probabilities are estimated using maximum likelihood estimation.__Hidden Markov Models:__

# Output

The input dataset is forwarded to the output port, an additional column for every used forecast method is added along with the forecasted values for the dependent variable. When the "Output forecast only" toggle is checked, the output will only contain the forecasted test data (specified by the signal column). Otherwise, the forecasts are also done on the training data.

# Example

In this example, the iris dataset is used along with an additional column called "signal" specifying whether the corresponding line is used for training or testing. The forecasted variable is the "petal_width" and the result is grouped by the variable "variety".

## Workflow

given that the second input for the grouped forecast processor is irrelevant, we use the invalid rows result from thedata table loadprocessor as input.

## Example Input

## Example Configuration

## Result

The previous result could be associated to theForecast Method Selectionprocessor as first input, the goal is to try different forecasting methods and choose whatbestfits our dataset.

# Related Articles

Decision Tree Regression Forecast Processor

Decision Tree Classification Forecast Processor

Random Forest Classification Forecast Processor

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Feedback sent

We appreciate your effort and will try to fix the article