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 on rows and columns 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.
- In the Query Builder, click Result manipulation icon ().
- Select the Forecast option. A warning dialogue will appear to remind you that forecasting requires date-stamp fields and specific chart types.
- 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.
- There are two method options you can choose from: Additive trend and multiplicative season or Additive trend and additive season.
- Select the number of values to predict. If you select the Custom option, you can specify the number of values. If not, BIME 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. Forecasted results will not appear on any other chart types.
- Your results will reflect the forecast.