VELOCITY_FORECAST(FIRST([Count Of Records]), 0, 5)


VELOCITY_FORECAST(start point, goal value, velocity per day)

Shows the forecast line from specified start point based on custom velocity.

start point: FIRST/LAST aggregation that specifies a point on the chart to start forecast from.

goal value: Aggregation or number which set end of forecast.

velocity per day: A number greater than 0 which shows daily velocity.

Use cases

Velocity Forecast

Shows the forecast when all work will be done based on custom velocity (1 task per day).

Source: History

History records related to production flow of implementing super hero protective suite feature

Start DateEnd DateStatus
03 Jan 2018 0010 Jan 2018In Development
10 Jan 2018 0013 Jan 2018Laboratory Testing
13 Jan 2018 0015 Jan 2018In Development
15 Jan 2018 0018 Jan 2018Battlefield Testing

Chart LINE

X: DAY([Start Date])


Annotation: VELOCITY_FORECAST(LAST([RUNNING_SUM(Count of Records)]), LAST([RUNNING_SUM(Count of Records)]) + 5, 1)#### Annotation: LAST([RUNNING_SUM(Count of Records)]) + 5


DAY(Start Date)RUNNING_SUM(Count of Records)
3 Jan 20181
10 Jan 20182
13 Jan 20183
15 Jan 20184