Forecasting is a result manipulation that uses patterns in your data to predict future results. If you would like to view a 'what if' analysis or how results are affected by a change in data, see Creating a global variable.
Forecasting can only use values from date fields with at least two cycles of data. A cycle of data is period broken down into multiple values. For example, a year is broken down by month or week. On auto-mode, the forecast will recognize each year as a cycle, so you need two years of data to generate a forecast.
To add a forecast to your query
- In the Query Builder, click the Result manipulation icon ().
- Select the Forecast option.
- Check Calculate a forecast on the result box to open your forecasting options.
- Enter a path for your results. Your path indicates how the calculation is computed. The path should be where your date attributes are added.
- Select either the Additive trend and multiplicative season or Additive trend and additive season method options.
- Select the number of values to predict.
If you select the Custom option, you can specify the number of values. If you select Auto, Explore will automatically calculate a number based on your dataset.
- Select the values per cycle.
If you select the Custom option, you can enter a specific number of values. For example, for 12 months of data, you can select 6 values per cycle.
- When you are finished selecting values, click Apply.
- Select either a bar, column, area, line, or sparkline chart. Forecast results will not appear on any other chart types.