Description
The Forecast Category node divides actuals data for multiple combo splits into buckets, based on total demand and demand variation.
Configuration Options
Basic Configuration Options
| Setting | Description\Parameters |
|---|---|
Split Columns |
The selected columns splits the data set over when calculating summary metrics. |
Sort By Columns |
Sort data rows by these columns. |
Target Column |
Actuals data column. |
Advanced Configuration Options
| Setting | Description |
|---|---|
High-Medium Demand Threshold |
Cutoff between demand categories. |
Medium-Low Demand Threshold |
Cutoff between demand categories. |
High-Medium Variation Threshold |
Cutoff between variation categories. |
Medium-Low Variation Threshold |
Cutoff between variation categories. |
Category Breakout
Each combo will be put into a bucket based on the total demand for that combo, and variation across periods of demand.
Total demand is calculated by summing all demand for the entire combo. The coefficient of variation is the ratio between the standard deviation of demand and the mean of demand.
There are nine possible buckets over 2 axes: high/medium/low demand, and high/medium/low variation.
This breakout is set by the thresholds set in the Advanced tab.
Actions
| Action | Description |
|---|---|
Preview |
Once the node is configured, the combined result set can be previewed at any time. |