Forecasting

To install the Forecasting add-on:

1. Download the attachment.
2. Extract the .zip folder into the plugins folder. If the folder does not exist, create it prior to extracting the .zip file.
   For V7.1 and earlier: C:\Program Files\Sisense\PrismWeb\plugins
   For V7.2 and later: C:\Program Files\Sisense\app\plugins
3. Create a chart. In your dashboard, click New Widget and select Advanced Configuration.
   
4. Select the Column Chart from the chart types menu. Pick a datetime dimension for the CATEGORIES, and one or more measures under VALUES. The most common scenario is to add the same measure twice so that you can see the historical data as one series and then turn the second series into a trend line.
5. On the second measure, select the Settings menu to display the Regression option. This menu is set to None by default, but you can select a prediction method to use against the data series.
   
6. Define the time frame. The default view will predict future values based on the calendar year (see below). If you want to change this, click on the Settings menu for the widget (top right corner of the screen).
   
7. The following options are available:
   None – Show the trend for historical time periods only
   Calendar End – This option will depend on your date dimension’s level of aggregation
   Years – When viewing data at a yearly level, the next 5 years will be predicted out
   Quarters – When viewing data at a quarterly level, the add-on will predict through Q4 of the calendar year
   Months – When viewing data at a monthly level, the add-on will predict through Dec of the calendar year
   Days – When viewing data at a daily level, the add-on will predict through the last day of the month
   Next 3 – This option will predict out the next 3 time periods
   Next 6 – This option will predict out the next 6 time periods
   Next 12 – This option will predict out the next 12 time periods

References/Notes

Multiple regression lines on the same widget are supported.
Only one dimension on the x-axis (no hierarchies) is supported.
If your regression line is not smooth, it may be because there are gaps in the dates of your data. You can resolve this by turning on the Continuous Timeline option of the date dimension.

If you set a value in the widget, you should not toggle the value off. If you want to disable it, just delete it or set the regression to None and then toggle it off.

26 September 2019 – Fixed the issue with missing regression line after switching dashboard filters

26 September 2019 – Updated readme file