> For the complete documentation index, see [llms.txt](https://docs.fabricplan.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.fabricplan.com/planning-sheets/how-tos/forecast-data-to-predict-future-trends/generate-forecasts-from-statistical-data.md).

# Generate Statistical Forecasts using PREDICT feature

Statistical forecasting uses historical data to identify trends, seasonality, and other statistical patterns to generate forecasts automatically without requiring manual calculations. The Predict feature enables forward-looking analysis by estimating future values from historical observations.

It supports configuration of confidence interval, seasonality, growth factor, algorithm selection, and hierarchy evaluation methods (Top-Down or Bottom-Up), allowing forecasts to be generated across planning hierarchies. Forecast results can be reviewed in both graphical and tabular formats.

### How forecasting works

The Predict feature uses the selected cell of the measure as a time series. It analyzes historical data within the selected historical date range and generates estimated values for the selected forecast period.<br>

During forecasting, the system considers the following characteristics of the time series:

* **Level:** The underlying baseline value of the series.
* **Trend:** A sustained upward or downward movement over time.
* **Seasonality:** A repeating pattern that occurs at regular calendar or operational intervals.
* **Past-value relationships:** The extent to which previous observations help explain future values.
* **Past-error relationships:** The extent to which previous forecast errors improve future predictions.

### Prerequisites

Before running a statistical forecast, ensure the following:

* A forecast measure exists with either blank initial values or prepopulated values.
* The planning sheet contains sufficient historical data.
  * For monthly data, at least **24 months** of historical data are required.
  * For quarterly data, at least **24 quarters** of historical data are required.
  * Some forecasting algorithms require **36 or 48 historical periods** to produce more reliable forecast results.

### Configure statistical forecasts

1. Create a planning model by assigning **row** fields, **column** fields, and measures under the **value** field.

Consider the model in the following image.

<figure><img src="https://257222532-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FUtolck8kt8atqxFPsEBn%2Fuploads%2F0kSgIMowT7XnovasNIr2%2F1.%20Configuring%20Model.png?alt=media&amp;token=f4aba449-5285-480b-8771-18cad43afa4e" alt=""><figcaption></figcaption></figure>

2. Create a new forecast measure (for example, *2026 Forecast*) by selecting the required forecast period through December 2026.

<figure><img src="https://257222532-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FUtolck8kt8atqxFPsEBn%2Fuploads%2FAtzJfoS8iepMmThy8Hzc%2F2.%20Forecast%20measure.png?alt=media&amp;token=665c6977-11b2-4718-88c3-2e3223f7a59e" alt=""><figcaption></figcaption></figure>

3. Select the *All Row Total* cell of the *2026 Forecast* measure.
4. Navigate to **Model,** Select **Predict**.

<figure><img src="https://257222532-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FUtolck8kt8atqxFPsEBn%2Fuploads%2FUa4GMqf22yUNbTXrlou8%2F3.%20Predict%20Option.png?alt=media&amp;token=026c8511-512c-48c4-9340-191c4f305583" alt=""><figcaption></figcaption></figure>

***Row Selected** represents the hierarchy member for which the forecast will be generated.*\
***Measure Selected** is used as the historical input series, and forecast values are written into this measure.*

*These fields are automatically populated based on the selected planning sheet cell. Selecting another visible cell updates the selected row and measure in the Predict panel.*

*Lock the selection to prevent choosing another cell from changing the selected row or measure.*

<figure><img src="https://257222532-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FUtolck8kt8atqxFPsEBn%2Fuploads%2F8zobvdvIpYdhrkqxoFwl%2F4.%20Locking%20Row%20and%20Measure%20selection.png?alt=media&amp;token=54d789d3-65f7-43c1-b79b-3dde55efc23d" alt=""><figcaption></figcaption></figure>

5. Specify the date ranges used for forecasting.

***Historic Data Range** specifies the historical periods used to build the statistical model. By default, all closed periods are selected.*\
***Forecast Date Range** specifies the future periods for which forecasts are generated. By default, all open periods are selected.*

*You can modify both ranges to suit your business requirements.*

{% hint style="info" %}
The forecast period can extend beyond the open period. This is useful when only a short open planning horizon exists (for example, Q1 only), but forecasts are required for a longer period to support planning and forecast validation.
{% endhint %}

<figure><img src="https://257222532-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FUtolck8kt8atqxFPsEBn%2Fuploads%2FQGImPMfrOI8TbUVyrqns%2F5.%20Assigning%20Period%20range.png?alt=media&amp;token=727df23a-e5df-46bf-ad1a-2c6d27a095eb" alt=""><figcaption></figcaption></figure>

6. Select an existing forecast profile or create a new one by selecting **More Options (⋯)**.

*A **Profile** is a saved collection of forecast settings that helps standardize forecast execution.*\
*Profile includes:*

* *Confidence (%).*
* *Growth Factor (%).*
* *Hierarchy evaluation.*
* *Negative-value handling.*
* *Algorithm choices.*
* *Seasonality choices.*

*You can create, duplicate, delete, or reset profiles. Use descriptive profile names so forecast configurations can be easily reproduced.*

<figure><img src="https://257222532-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FUtolck8kt8atqxFPsEBn%2Fuploads%2F2rCFH2D3gB2L1pNC02YB%2F6.%20Setting%20Profile.png?alt=media&amp;token=2e977480-5515-4360-946a-3230db4f9e73" alt=""><figcaption></figcaption></figure>

7. Set the **Confidence (%).**

***Confidence (%)** controls the requested width of the forecast confidence interval. It represents the probability that the actual value will fall within the predicted range.*\
*Typical confidence% choice include:*

* ***80%:** Produces a narrower confidence interval suitable for central planning.*
* ***90%:** A balanced confidence level for most business forecasts.*
* ***95%:** Produces a wider, more conservative confidence interval.*

8. Set the **Growth Factor (%).**

***Growth Factor (%)** applies a business adjustment to the statistical forecast. It also defines the expected rate at which the forecast values increase or decrease over time.*\
*Examples:*

* ***5%** increases forecast values to reflect an expected business uplift.*
* ***-5%** decreases forecast values.*
* ***0%** preserves the statistical forecast without adjustment.*

9. Assign the **Evaluation** method to.

***Bottom Up** generates forecasts at detailed hierarchy levels and aggregates them into higher-level totals.*

***Top Down** generates forecasts at higher hierarchy levels and distributes them into lower levels.*

10. Set **Round all negative values to zero** as

***Yes,** when the forecasted measure cannot be negative.*\
***No,** when negative values are valid for the business scenario.*

<figure><img src="https://257222532-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FUtolck8kt8atqxFPsEBn%2Fuploads%2FqbRiONUm1Ck2JxeWIv7P%2F7.%20Configuring%20forecast%20options.png?alt=media&amp;token=d82cdc29-8dbb-43de-8dae-fc9da8eb70e1" alt=""><figcaption></figcaption></figure>

11. Choose a forecasting **algorithm** that best matches the characteristics of your historical data.

The following forecasting algorithms are available:

* **Trend Decomposition with MSTL -** Breaks down complex data with multiple repeating patterns into simple parts so they are easier to handle.
* **Exponential Smoothing -** Focuses on smooth trends and clear, single-cycle seasons, giving more weight to recent data.
* **ARIMA -** Looks at recent spikes, drops, and lags to project where the trend is heading next.

For more information about forecasting algorithms, statistical models, and model orders, refer [here](/planning-sheets/concepts/forecasting/predict-statistical-forecasting-algorithm.md)*.*

12. Seasonality is a repeating pattern in data that occurs at regular time intervals, such as yearly or quarterly or both.\
    Choose **Set Seasonality** as:\
    ***Year**, when the pattern repeats on an annual cycle.*\
    ***Quater**, when the pattern repeats on an quarterly cycle.*\
    *Both when the pattern repeats on annual and quarterly cycle.*

{% hint style="info" %}
The seasonality will not display the last scale of time dimension
{% endhint %}

13. Select **Run Forecast** to generate forecast values.

<figure><img src="https://257222532-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FUtolck8kt8atqxFPsEBn%2Fuploads%2FsrWqUEV8PsxzFGx594YA%2F8.%20Setting%20Algorithm.png?alt=media&amp;token=47800880-a02e-4f19-a5b1-8dde64644a5f" alt=""><figcaption></figcaption></figure>

14. The forecast preview is available in both graphical and tabular formats:

* Historical values are displayed in **grey**.
* Forecast values are displayed in **green**.
* The shaded green band represents the selected confidence interval.

<figure><img src="https://257222532-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FUtolck8kt8atqxFPsEBn%2Fuploads%2F3ly0qqO3BPkDSFuMqsSb%2F9.%20Preview%20-%20Graphical%20format.png?alt=media&amp;token=572d95a4-931f-4e60-b61a-d5cf3542b0c8" alt=""><figcaption></figcaption></figure>

<figure><img src="https://257222532-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FUtolck8kt8atqxFPsEBn%2Fuploads%2FHlvxQs1I61OslnbWQjt6%2F10.%20Preview%20-%20Tabular%20format.png?alt=media&amp;token=ab4dca1e-1f52-43a2-8d4e-7af57b88b160" alt=""><figcaption></figcaption></figure>

15. If necessary, select **Reconfigure** or **Re-run Forecast** to adjust forecasting parameters and improve forecast accuracy.\
    When you are satisfied with the forecast, select **Save Forecast**.

<figure><img src="https://257222532-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FUtolck8kt8atqxFPsEBn%2Fuploads%2FQVSUHvDguS1x7rXioxw8%2F11.%20Save%20Forecast.png?alt=media&amp;token=fe63814e-bb72-4c66-95cd-10adad22594f" alt=""><figcaption></figcaption></figure>

16. You can also apply the forecast values to a planning scenario or export it to a CSV file.

<figure><img src="https://257222532-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FUtolck8kt8atqxFPsEBn%2Fuploads%2FT7bf39JVILzPdRMDsjYn%2F12.%20Other%20save%20options.png?alt=media&amp;token=98441839-9e24-4022-b082-bf56099c3fcf" alt=""><figcaption></figcaption></figure>

17. Forecasts are generated for the selected measure and row category. As the Bottom-Up approach is used, values are automatically aggregated to the parent levels.

<figure><img src="https://257222532-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FUtolck8kt8atqxFPsEBn%2Fuploads%2FhLqktmcdxfVQYex0OCzy%2F13.%20Forecasted%20value.png?alt=media&amp;token=029f115d-1041-47a1-aa6b-cb246b6a1825" alt=""><figcaption></figcaption></figure>

#### Choosing the right forecasting algorithm

Refer the below table for a summary or when you have a question as **"Which algorithm to choose?"**

<table data-search="false"><thead><tr><th>Data Pattern</th><th>Recommended Algorithm</th></tr></thead><tbody><tr><td>Stable data with no trend or seasonality</td><td>Simple Exponential Smoothing</td></tr><tr><td>Trend only</td><td>Holt's Linear Trend</td></tr><tr><td>Trend gradually weakens</td><td>Holt's Damped Trend</td></tr><tr><td>Trend with constant seasonal variation</td><td>Holt-Winters Additive</td></tr><tr><td>Trend with seasonal variation proportional to the level</td><td>Holt-Winters Multiplicative</td></tr><tr><td>Multiple seasonal patterns</td><td>MSTL</td></tr><tr><td>Non-seasonal data with autocorrelation</td><td>ARIMA</td></tr><tr><td>Seasonal data</td><td>SARIMA</td></tr><tr><td>Unsure which ETS model to use</td><td>Auto ETS</td></tr><tr><td>Unsure which ARIMA model to use</td><td>Auto ARIMA</td></tr></tbody></table>


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://docs.fabricplan.com/planning-sheets/how-tos/forecast-data-to-predict-future-trends/generate-forecasts-from-statistical-data.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.