The Predictive Trend Line add-on displays linear, exponential, and logarithmic trend lines in your dashboard charts.

trend

The trend line allows an end user to predict future values/metrics based on historical data. See the referenced wiki page on the regression analysis for more information.

To add a predictive trend line to your charts:

  1. Download the attachment and unzip the contents into your C:\Program Files\Sisense\PrismWeb\plugins\ folder. If the plugins folder doesn’t exist, just create it. After those files have been unzipped there, you may also have to restart the web server.
  2. Create a chart. In your dashboard, click New Widget and select Advanced Configuration.
    advancedconfig
  3. 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.
  4. 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.
    settingdataseries
  5. 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).
    options
  6. 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.
    Continuous_Timeline.png
  • 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.