Analyzing Trends in Your Data

Applicable to Sisense on Linux and Microsoft Windows

Sisense enables you to add trend lines and apply advanced analytic models over a widget to highlight tendencies in your data and get insights quickly.

Sisense supports trend lines on all Column, Line, Area, and Bar charts. For any relevant widget, the Analyze It icon is displayed in the widget’s menu.

Note: If you're currently using the Forecast add-on for trend lines, perform the steps detailed in the section Migrating from the Forecasting Add-on before using trend lines in your dashboard.

Both Dashboard Designers and Viewers can interact with this icon to apply trend lines.

  1. Click Analyze It and then select Trend.
  2. Select the value that is analyzed by Sisense (if more than one value is displayed on the widget).
  3. Define the trend settings.

Sisense supports four different trend types.

Linear Trend: A linear trend line is a straight line that usually shows when values are increasing or decreasing at a steady rate.

Logarithmic Trend: A logarithmic trend line is a best-fit curved line that is used when the rate of change in the data increases or decreases quickly and then levels out.

Exponential Smoothing: An exponential trend line is a curved line that is most useful when data values rise or fall at increasingly higher rates. You cannot create an exponential trend line if your data contains zero or negative values. Sisense averages two spline regressors to reduce the noise in a time series when calculating this type of trend.

Local Estimates: Local Estimate models add trend lines according to the mean of a time series.

In addition, from the Trend Settings window, you can:

Adding Trend Lines to Widgets

To add a trend line to a widget:

  1. In the Sisense dashboard, click Analyze It on the relevant widget’s menu.
  2. Select Trend and then the relevant value.
  3. Enable Show Trend if it is disabled. If it is already enabled, select Trend Settings.
  4. Select the trend type. Only supported trend types are enabled. If your data does not support a trend type, you cannot select it. The trend line is added to your widget.
  5. Click Close.
    Your trend line is now added to the widget. You can right-click the trend to open the Quick Settings again to make any changes.

Enabling/Disabling Trend Cloud Models

There are two trend types available by default: Linear Trend and Logarithmic Trend. However, Administrators can add access to two additional trend types: Advanced Smoothing and Local Estimates. These types are not offered by default and need to be enabled by the Administrator on the Admin page because they require cloud access.

Note: Disabling Trend Cloud Models does not turn off the whole trend feature. Disabling this feature turns off Advanced Smoothing and Local Estimates, which require cloud access.

In the Admin page, under Feature Management, toggle the Trend Cloud Models switch to enable or disable the Exponential Smoothing and Local Estimates trend types.

Migrating from the Forecasting Add-on

If you're using the Forecasting add-on for trend lines, perform the following steps to switch to using native Forecasting and trend lines in Sisense:

  1. Disable the Forecasting add-on. For more information, see Sisense Add-ons. This removes the Forecast and Trend lines from any widgets on which the add-on was applied.
  2. Add trends to any relevant widget. See Analyzing Trends in Your Data.