Using forecasting to predict results


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. 

To use forecasting in your query
  1. In the Query Builder, click Result manipulation icon ().
  2. Select the Forecast option. A warning dialogue will appear to remind you that forecasting requires date-stamp fields and specific chart types. 

  3. Check Calculate a forecast on the result box to open your forecasting options. 
  4. Enter a path for your results. Your path indicates how the calculation is computed. The path should be where your date attributes are added.

  5. There are two method options you can choose from: Additive trend and multiplicative season or Additive trend and additive season

  6. 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. 
  7. 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. 

  8. When you are finished selecting values, click Apply.
  9. Select either a bar, column, area, line, or sparkline chart. Forecasted results will not appear on any other chart types. 
  10. Your results will reflect the forecast.
Have more questions? Submit a request


Please sign in to leave a comment.
Powered by Zendesk