Analyzing Trends in Widget Data

In widgets that show data over time, you can add trend lines and apply advanced analytic models to highlight tendencies in the data and get useful insights.
Dashboards tab - Widget trend line
  • This function is only available for area charts, bar charts, column charts, line charts, and polar charts.
  • Only time series with a single date dimension are supported. If the widget contains multiple data fields in the Categories section, this function is not available.
  • This function is not available if a sorting option is applied to the value fields included in the widget.
  • Using a Break by field is not supported.
  • Null values might disrupt the calculations of the models and affect accuracy.
To analyze trends in widget data:
  1. Click Dashboards tab, the Dashboards tab, and select a dashboard from the list.
  2. On the dashboard, go to the widget that you want to work with.
  3. Click Analyze It button, the Analyze It button, select Trend, and enable the Show Trend option.
    Dashboards tab - Analyze data

    If the widget includes multiple value fields, you must select the field that you want to analyze before enabling the Show Trend option.

  4. To customize the trend line settings, select Trend Settings.
    Dashboards tab - Trend settings
    • Under Trend Variable, you can see the value field that is analyzed for the trend line.
    • Under Trend Type, you can specify the type of trend line:
      Linear Trend
      Adds a straight line that shows if the trend is increasing or decreasing. A linear trend line is useful when the values are increasing or decreasing at a steady rate.
      Logarithmic Trend
      Adds a best-fit curved line that shows whether the data converges within time. A logarithmic trend line is useful when the rate of change in the data increases or decreases quickly and then levels out.
    • In the Compare To section, you can add a second trend line that lets you compare the current trend to data from a previous time period.

      Select a time period from the list and enable the Compare To option. Equivalent data must be available for the selected time period.

      For example, you can compare the trend for the daily number of jobs from this month with the trend from the previous month.

  5. To view information about the trend data, select Trend Information.
    Dashboards tab - Trend information

Once the trend line is added to the widget, you can click it at any time to open the Quick Settings dialog box and make any required changes.

You can also add trend lines from the Widget Designer. In the data panel on the left, hover over the value field that you want to analyze and click Analyze It button, the Analyze It button.