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.
- 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
- Then go to the Chart Designer - Forecasts and select the corresponding columns for your expected value, worst- and best-case
- 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