KNOWLEDGE BASE

Forecast Shows Horizontal Line


Published: 19 Apr 2013
Last Modified Date: 05 Apr 2017

Issue

When using forecasting is enabled, you get a flat trend line or horizontal line. 

Environment

Tableau Desktop

Resolution

To resolve this issue, modify the forecast model by specifying trend and seasonality. 
  1. In your view, right-click the forecast line, and select Forecast Forecast Options.
  2. In the Forecast Options dialog box, under Forecast Model, select Trend and season.

Cause

When Tableau's forecast model is enabled but cannot identify a seasonal pattern, Tableau cannot forecast future values and therefore is unable to apply a trend line.

Additional Information

When trend and seasonality is not specified in the forecast model, the summary may show the following:

Seasonal pattern: None (Searched for a seasonal pattern recurring every 12 Months)
Did this article resolve the issue?