Could not complete Forecast in Line Chart in TIBCO Spotfire client with error "Forecast - Holt-Winters calculations require the data points to be spaced at equal distances."
Article ID: KB0071683
Updated On:
| Products | Versions |
|---|---|
| Spotfire Analyst | All |
Description
When you add or edit a Holt-Winters forecast from the Lines & Curves page of the Visualization Properties dialog (only available for some visualization types), or by right clicking and enabling Forecast, the following error message is seen, "i" informational alert next to viz title:
If you show markers, you see that the x-axis has all months and there is not data for all months. This is caused by setting x-axis mode as "Show filtered range", while there are missing values for some of the months.
Forecast - Holt-Winters calculations require the data points to be spaced at equal distances.
If you show markers, you see that the x-axis has all months and there is not data for all months. This is caused by setting x-axis mode as "Show filtered range", while there are missing values for some of the months.
Issue/Introduction
Could not complete Forecast in Line Chart in TIBCO Spotfire client with error - "Forecast - Holt-Winters calculations require the data points to be spaced at equal distances."
Resolution
Go to:
- Properties > X-axis > Columns: Settings > Axis Mode: Categorical > Categories. Change that from "Show filtered range" to "Show filtered values".
- Properties > Appearance > Time Series: Check "Compensate for missing values" . You may need to change the y-axis to something like Count([AnyColumn]). This option allows you to have all 12 months of every year on the x-axis, if that is what is desired.
Additional Information
Doc: Curve Fit Models > Holt-Winters Forecast
Feedback
Yes
No
Powered by
