ExtendForecast
Extends a dated table with new future rows: it appends N periods past the last historical date, compounding the measure column forward at a growth rate, rather than adding a forecast column to existing rows. Other columns forward-fill from the last historical row, and setting a group column runs the projection separately for each group off its own last value. The result keeps the source table's shape and appears automatically as its own tab, history and forecast together.
Inputs
| Input | Accepts | Required |
|---|---|---|
Source | Table | Yes |
GrowthRate | Value (a single number) | Yes |
Periods | Value (a single number) | Yes |
Outputs
| Output | Produces |
|---|---|
Result | Table |
Settings
Typed in on the node or set by the assistant, not wired.
| Setting | Default | Notes |
|---|---|---|
DateColumn | — | The date column that orders the history and receives the future dates. |
MeasureColumn | — | The numeric column to project; its last historical value compounds forward at the growth rate. |
GroupColumn | — | Optional. Set to a category column (like Region) to forecast each group separately from its own last value. Leave blank for a single forecast. |
Step | Month | Spacing of the future dates: one of Day, Week, Month, Quarter, Year. Default Month. |
GrowthRate | 0.05 | Compound growth per step as a decimal; 0.03 means 3% per period at the chosen Step. Default 0.05. |
Periods | 12 | How many future rows to add (per group, when a group column is set). Default 12. |
Example
Your Revenue_Quarterly table runs through Q4 2025, ending at $3.2M. Set the date column to Quarter_End, the measure to Revenue, Step to Quarter, Periods to 4, and GrowthRate to 0.03. Four new rows appear dated Q1–Q4 2026, stepping $3.30M, $3.39M, $3.50M, $3.60M. If the table also has a Region column with three regions, set it as the group column and each region gets its own four forecast quarters from its own trajectory.
Tips
The growth rate is per step, not per year: 3% with a quarterly step is roughly 12.6% annualized. Wire a Slider into GrowthRate to drag the assumption while a LineChart of the result updates; once new actuals arrive, Actualize splices them over the forecast rows.