Breakdown widgets have the following optional settings for the date range, the display, the grouping breakdown, and for the column contents. Not all options are available for all visualizations.

Important: This topic is not a guide to creating breakdown widgets. It is a guide to extra, optional settings that are common across breakdown widget types. FOR INSTRUCTIONS ON CREATING TIME SERIES WIDGETS, PLEASE SEE THE APPROPRIATE "CREATE" TOPIC:

The available settings depend on the selected visualization. The following example is for a Scorecard visualization.

Additional settings for breakdown widgets.

Date settings

Setting Description
Period Select the date range to display in the widget. Several options are available.
  • Select a specific time range. The default is 3m (3 months).
  • Select max to use scores up to the current date.
  • Select between and then fill in the From and To fields to define a time period.
The Period field is available only if you select Line, Columns and Total, or Stacked Column as the Visualization
Show date range selector Display a date range selector on the widget that enables users to change the selected period when viewing the widget on a dashboard.
Note:
  • Selecting a date range on a widget does not update the trend line.
  • If you combine a time series aggregation such as By month SUM with a date range selector, the user may see one more time period than they expect. The instance interprets a period such as 3m as 0-3 months and may show four months of scores.

Axis settings

Note: Axis settings are not available when Stacked column is the visualization.
SettingDescription
Y-axis title Specify a title to display on the vertical axis of the chart.
Y-axis from Specify the starting point for the range of values for the vertical axis of the chart.
Y-axis to Specify the ending point for the range of values for the vertical axis of the chart.
2nd Y-axis title Specify a secondary title to display on the vertical axis of the chart.
2nd Y-axis from Specify the starting point for a 2nd range of values for the vertical axis of the chart.

The 2nd Y-axis can be used if scores normally move between a limited range, but you have some exceptions that would otherwise distort the chart, such as a range of 40 to 60, with an exception of 1000.
2nd Y-axis to Specify the ending point for a 2nd range of values for the vertical axis of the chart.

Display settings

SettingDescription
Show target Display the target score, if defined. This field appears only if Previous period chart is not selected.
Show thresholds Display thresholds such as an all time high or an all time low. Thresholds appear only if they have been defined for this indicator.
Show data labels Display the score for each portion of the chart, such as for each slice of a pie chart.
Show trend Display the direction the indicator is moving. The trend is shown in a mini-chart on the dashboard.
Show confidence bands Display confidence bands in this chart. For information about how the confidence band is calculated, see Widget confidence bands.
Show forecast Display forecast data in the chart based on current trend data. Forecasting must be configured on the indicator.
Show comments Display comments added to data points in the chart.
Show visualization selector Display a choice list on the widget that enables users to change the selected visualization from a dashboard.
Note: You cannot select the Pivot Scorecard visualization from a dashboard. You must configure the widget record to use this visualization.
Show breakdown selector Display a choice list on the widget that enables users to change the selected breakdown from a dashboard. There must be more than 1 breakdown available for the widget for the breakdown choice list to appear.
Positive color When the Visualization is Treemap, select the color used to indicate a score moving in the desired direction, based on the indicator Direction value. If Color based on is set to Target, the positive color indicates values closer to the target.
Negative color When the Visualization is Treemap, select the color used to indicate a score moving in the wrong direction, based on the indicator Direction value. If Color based on is set to Target, the negative color indicates values further away from the target. This field is not available when Color based on is Score.
Show legend When the Visualization is Treemap, select this option to display a legend for the positive and negative colors.
Include elements without data in the legend Shows the breakdown name in the legend of the widget even when no records match the elements of the breakdown.

Breakdown settings

Setting Description
Breakdown on Y axis

Pivot Analytics Hub breakdown widgets display breakdown elements as the X axis and indicators as the Y axis by default. Select this check box to display breakdown elements as the Y axis and indicators as the X axis.
Show total If you selected Scorecard in the Visualization field, an extra row can be included in the breakdown chart showing the totals of all selected breakdowns.
Show bar Represent the score for each instance by a bar.

Element settings

SettingDescription
Elements filter Specify if only a certain subset of breakdown elements are available for this widget. By default all elements are available.

For example, elements of the breakdown Priority can be: Critical, High, Moderate, Low or Planning.
Manual elements Breakdown elements can be selected automatically or manually. Select the Manual elements check box to display the Widget Elements related list for adding elements. Clear the Manual elements check box to automatically use the elements that belong to the breakdown.
Show top x Show only the elements with the x highest scores, according to the Sort by field, to make the chart easier to read.

In case of ties, the first element listed in the scoresheet is shown. For example, if you have a widget where Show top x is 3 and the third-highest value for the Priority breakdown is tied between High and Moderate, the widget shows High, not Moderate.

Scoresheet with two elements tied for 3rd highest value.

Breakdown widget with Show Top x = 3 and the elements 2 - high and 3 - Moderate tied for third highest, with 2 - High showing.

The order in which the scoresheet lists elements depends on the table containing the elements. For example, for elements on the Choice [sys_choice] table, this order follows the value in the Sequence field. For elements on the Group [sys_group] table, the order is alphabetical based on the Name field.

Note: The top elements are selected from the most recent scores. If the widget has a line visualization, the top elements are still selected from the most recent scores, even if other elements have a higher average score across the timespan shown.
Percentages If you select No percentages, no score percentages are shown for the instances. If you select Percentage of elements, a score percentage is shown for each instance. For example, 6.4% of the total incidents are Critical, 11.8% are High, and so on.

Column settings

SettingDescription
Current score Display the score from the latest data collection.
Trend Display the direction the indicator is moving. The trend is shown in a mini-chart on the dashboard.
Multiple scores

Adds scores to the Analytics Hub. Select the number of additional scores to display in Number of periods. Select the length of each period in Period step. If Current Score is also selected, the Score column is counted as the most recent period and N-1 periods are added.
Change Display the change from the previous score.
Change % Display the percentage change from the previous score.
Target Display the target for the indicator if a target has been defined.
Gap Display the difference between the current and the target scores. Gap can be either positive (moving towards the target) or negative (moving away from the target).
Gap % Display the percentage difference between the current and target scores. Gap % can be either positive (moving towards the target) or negative (moving away from the target).

Latest score settings

Setting Description
Compare score with This tab is shown when the visualization type is Latest Score. Select Previous Score or Periods Back. You can specify any number of previous periods.