Using Forecasts in Insights
After you created a Forecast, you can use its values in all your bar and line charts, in order to display your expected values for future time periods, as well as a confidence interval, which is based on your worst- and best-case forecast.
  1. 1.
    In order to display the forecast values in an insight, your first need to join the forecast values with your actual data on the respective date columns: This can be either done in the insight directly or in a transform, on which the insight depends on
  2. 2.
    Then go to the Chart Designer - Forecasts and select the corresponding columns for your expected value, worst- and best-case
  3. 3.
    If you choose to display the best-case as an area, you need to select a column for the worst-case as well, so that only the area between the best- and the worst-case scenario is filled. In this case, the line themselves will not be shown, but only the area and its set style
Copy link