---
title: "AddForecast"
slug: "addforecast"
updated: 2023-03-20T11:28:39Z
published: 2023-03-20T11:28:39Z
canonical: "docs.datajet.app/addforecast"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.datajet.app/llms.txt
> Use this file to discover all available pages before exploring further.

# AddForecast

Calculates average for a specified range and extends it out over a specified number of rows

### Purpose

Use this function to:

- Calculate a forecast line from an incomplete data set
- Calculate sales forecasts

### Parameters

![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1679311448240.png)

| Parameter | Description |
| --- | --- |
| Column Name | The name of the output column |
| Data Column | The source column to use when calculating the AddForecast |
| Plot Axis | 0 / 1. Y-Axis to use when plotting graph. Default = 0 |
| Plot As | Bar / Stacked Bar / Line / Spline / RangeLow / RangeHigh / CSLow / CSHigh / CSOpen / CSClose Determines the graph style for the output column. |
| Plot | Y / N. Specifies whether measure’s output column should be plotted on graph. Default = Y |
| Popup Mode | Default / None / Extended |
| Prefix | £ / $ / E / % |
| Extending Method | Required. Determines the method that is used to extend the dimension column i.e., the X Axis for the resulting graph - Row : Dimension column is extended by filling in with the row number for the required number of rows. - Incrementing Integer : Dimension column is extended by starting at 1 and incrementing for each added row - Decrementing Integer : Dimension column is extended by starting at -1 and decreasing for each added row - Incrementing Date : Dimension column is extended by adding dates to the last date - Decrementing Date : Dimension column is decreasing by adding dates to the last date. Note this usually means that the forecast line will reverse on itself. |
| Required Rows | Required. Default = 90. |

### Examples

Decrementing Date

![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1679311358826.png)

#### Row

![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1679311416791.png)