SkyDesk Reports enables you to effectively predict your future data trends, using its forecasting feature. Forecasting in SkyDesk Reports is based on powerful forecasting algorithms which analyze your past data deeply and come up with the best forecast for the future. You can set up a forecast in a chart using a very simple set up process, without worrying about the underlying complexity.
This document will help you to learn how forecasting works in SkyDesk Reports and how you can easily set up the same in your charts.
- What is Forecasting?
- What are the chart types that support Forecasting?
- How do I setup Forecasting in my chart?
- Can I set up forecasting over multiple Y-Axis?
- Forecast option is not available in my Chart settings, why?
- How Does Forecasting work in SkyDesk Reports?
- The forecasted points shown in the chart are different to the shared users. Why?
- The underlying data and drill down options are not available for forecasted data points. Why?
- I could not find "Forecast" option in chart settings. Why?
- Already configured forecasting settings are not available now. Why?
- I have configured forecasting for my chart. But it says, "Forecasting is disabled as the data is completely ignored". Why?
- I have configured forecasting for my chart. But it says, "Forecasting is disabled as there is not enough data to identify pattern". Why?
- I have configured forecasting for my chart. But it says, "Forecasting is disabled as there are more than 40% empty values". Why?
- I have configured forecasting for my chart. But it says, "Column cannot be forecast as more than 5 data points is required". Why?
Forecasting is a process of predicting the future based on the past data trend. SkyDesk Reports forecasting is based on powerful forecasting algorithms which analyzes your past data deeply and comes up with the best forecast for the future.
SkyDesk Reports supports forecasting for the following chart types.
- Line Chart
- Bar Chart
- Stacked Bar Chart
- Scatter Chart
- Area Chart
- Stacked Area Chart
- Combo Charts (without Bubble Chart).
You can set up forecasting using the Chart Settings page. To set up forecasting in a chart, follow the below steps.
- Open the Chart in which you want to set up the forecast. Refer here to know forecasting is available for the chart.
- Click the Settings icon. The Charts Settings page will open.
- Open the Forecast tab.
- Click Add Forecast. All the possible Y-axis series to be forecasted will be listed.
- Select the Y-axis series to be forecasted. The forecast setting will be displayed.
- In the Forecast Length, select the number of points to be forecasted.
- In the Ignore Last, select the number of points to be ignored from the past starting from the current point.
- Specify the legend title for the forecasted data series in the Legend Name.
- Specify the Formatting to be applied to show the forecasted data points.
- Click Apply. The forecasted series will be added to the chart.
The forecasted data series will be listed as a Legend Item in the chart. This allows you to view or remove the forecasted points in the chart easily.
Yes, you can set up forecasting over multiple Y-Axis in a chart.
Forecasting will be enabled when it matches certain conditions, which are briefed below:
- The chart type should be any one of the following:
Line Chart, Bar Chart, Stacked Bar Chart, Scatter Chart, Area Chart, Stacked Area Chart, Web Chart, Combo Charts.
- The X-axis of the chart should be a TIME series or NUMBER series.
- Charts should have only one dimension column in X-axis: Forecasting will be enabled only when the chart has a single dimension column (in X-axis). If the chart contains Text, Color, Size or Tooltip, then forecasting will not be enabled.
- Atleast one aggregate function should be present in Y-axis: Forecasting can be applied over the aggregate function alone. if all the Y-axis series in the chart contain advanced summarizing options like running total, then forecasting will not be enabled.
- If the chart is filtered with a numeric column, then forecasting will be disabled. The forecasting based on filtered data might give inaccurate results, hence forecasting is disabled.
SkyDesk Reports offers a powerful forecasting engine which predicts future data points based on past data. The forecasting engine offers a range of customizations such as number of units to be forecasted, number of data points to be ignored in the past data and the formatting to be applied over the forecasted data points.
The following points describe how the forecasting engine works in SkyDesk Reports:
- The forecasting engine analyses past data points.
- Based on the past data, the forecasting engine will identify the periodicity using auto-correlation method.
- Then it computes the seasonality, trend and randomness using the past data.
- By iterative processing, the forecasting engine fine-tunes the computed seasonality, trend and randomness.
- The engine runs linear, logarithmic and exponential regressions and identifies the data series falls under linear, logarithmic or exponential.
- The accuracy of the predicted results will be verified using Hindcasting. Hindcasting is the process of predicting the past data points and verify the same with the actual points.
- Once all verifications are done, the forecasting engine produces the final forecasted points
The chart could have been shared with different filter criteria to the shared users. Number of past data points available in the shared data could very for different shared users, hence the forecasted points are different for shared users.
The forecasted points will not have underlying data generated for each of the forcasted data points. Hence, View Underlying Data and Drill Down options will not be available for forecasted data points.
This could happen when the forecast constraints are not met. Please refer to the constraints specified.
This could happen when the design of the chart has been modified, which does not match the forecast constraints.
3. I have configured forecasting for my chart. But it says, "Forecasting is disabled as the data is completely ignored". Why?
This could happen if you had set to ignore all the past data points from "Ignore Last" setting.
4. I have configured forecasting for my chart. But it says, "Forecasting is disabled as there is not enough data to identify pattern". Why?
This could happen when there is no sufficient data produced to forecasting engine to come up with forecasted data points.
5. I have configured forecasting for my chart. But it says, "Forecasting is disabled as there are more than 40% empty values". Why?
When the past data points provided to the forecasting engine has more null values, the forecasted points might be inaccurate. To avoid this, the forecasting engine will discard the process when the null values are more than 40% in the given data.
6. I have configured forecasting for my chart. But it says, "Column cannot be forecast as more than 5 data points is required". Why?
To produce an accurate forecast, the data points to be considered for forecasting should be more than 5 points. Try changing the time series in X-axis to a more granular function which may result in more data points. For example, If the existing time series is Year, then change to Month & Year.