Skip to content

Advanced Analytics - Forecasting

2 min read · Updated 3 Nov 2026

Forecasting is a technique that uses historical data to determine the direction of future trends. Exponential and Linear forecasting continue existing trend lines to project future forecast values. Scenario forecasting offers forecasting based on a specified growth amount, within a defined period.

  1. Trend-driven forecasting

  2. Scenario Forecasting

The properties panel includes settings which affect the forecast output, for example:

  • All data / custom range

    • All data draws the linear regression forecast using all data

    • Custom range draws the linear regression forecast, using a limited number of points in the data. This is best used when only the recent data points are relevant

  • Forecasted points

    • Sets how many points are included in the forecast. This number is related to the range of training/reference data available.

Forecasting settings panel with Sales selected, Linear type, All data, Forecasted points set to 5, and Show reference line ticked.

The Linear Regression forecast type looks at the relationship between two variables by plotting a line through the observed data, and works best when there is a relationship between the two variables (e.g. age and height, sales and advertising). For the forecast, you extend the line and continue the points that follow the regression line.

Line chart of Sales and Margin over time with a dashed forecast continuing the Sales line upward past a vertical reference line.

The exponential forecast option draws a curved line and continues the exponential trend line values. This is best used for

⚠ You cannot create an exponential trendline if your data contains zero or negative values

Line chart of Sales, Margin and Forecast with a dashed Forecast line rising steeply after the vertical reference line.

Scenario forecasting visualizes where growth is expected to be accumulated / compounded, allowing you to visualize month-on-month or year-on-year growth, typically for financial forecasts.

Growth is set per period and accumulates over time, for example, after 3 years at 10% interest year-on-year, $10,000 generates interest of $13,310.

Compound growth example with Initial Deposit $10000, Investment Time Span 3 and Estimated Rate of Return 10.00%, showing a Future Balance of $13,310.

Periods should be defined based on the level of data points, refer to the table below for examples.

Each data point represents

Points per period

1 day

7 = 1 week

30 = 1 month

365 = 1 year

1 Month

12 = 1 year

3 = 1 quarter

Forecasting settings panel with Sales, Growth Scenarios (%), Forecasted points 10, Points per period 1 and Expected Growth 10%.