How do I remove a forecast from a series?

Depending how you want to proceed, there are two main solutions:

  • You can remove the forecast values entirely from a series
  • You can keep the values and remove the forecast indicator for them

To remove forecast values entirely, use the following expression in Series list. It replaces forecast values with null and returns only the non-forecast values of the series.

if(isForecast(series), Null(), series)

To remove the forecast indicator from a series, use the following expression in Series list. It returns the series values as non-forecast values when the condition (the second parameter) is false.

FlagForecast(series, 0)

Forecast values are usually displayed in a different color on charts, so removing the forecast indicator will make the entire series be graphed in the same color.

For more information on forecast, click here: Add a forecast