FORECAST_LINE
FORECAST_LINE([Count of Records], LAST([Count Of Records]))Syntax
FORECAST_LINE(numerical chart dimension, end)
Shows the forecast line for defined numerical chart dimension and end.
numerical chart dimension: Any numerical chart dimension used for the chart.
end: Any numerical constant or aggregation created against numerical chart dimension used for the chart.
Use cases
Forecast Line
Shows the forecast line annotation.
Source: History
History records related to production flow of implementing super hero protective suite feature
| Start Date | End Date | Status |
|---|---|---|
| 03 Jan 2018 00 | 10 Jan 2018 | In Development |
| 10 Jan 2018 00 | 13 Jan 2018 | Laboratory Testing |
| 13 Jan 2018 00 | 15 Jan 2018 | In Development |
| 15 Jan 2018 00 | 18 Jan 2018 | Battlefield Testing |
Chart BAR
X: DAY([Start Date])
Y: RUNNING_SUM(COUNT([Row Number]))
Annotation: FORECAST_LINE([RUNNING_SUM(Count of Records)], MEDIAN([RUNNING_SUM(Count of Records)]))
| DAY(Start Date) | RUNNING_SUM(Count of Records) |
|---|---|
| 3 Jan 2018 | 1 |
| 10 Jan 2018 | 2 |
| 13 Jan 2018 | 3 |
| 15 Jan 2018 | 4 |