Create a stacked column visualization for a time series widget

To compare and sum the scores of several indicators, create a widget as a time series with a stacked column visualization.

Avant de commencer

Role required: pa_admin or admin

Pourquoi et quand exécuter cette tâche

Remarque :

This feature is part of the Core UI front end. It is not supported on Platform Analytics dashboards or UI Builder pages, except to a limited extent when migrated in compatibility mode. To build Platform Analytics components, see Data visualizations in Platform Analytics or Filters in Platform Analytics.

This feature is deprecated, meaning it is in maintenance mode and is no longer being augmented or changed. Only security fixes to this feature will be addressed.

To show the sum of scores of several indicators over time, and to show the relative contribution of each indicator to the sum, use a stacked column visualization.

In the following example, indicators for each regional sales center are stacked in columns to show both the total sales and the relative contribution of each region.

Figure 1. Stacked column visualization - time series

Procédure

1. Navigate to All > Performance Analytics > Widgets and click New.
2. In the Name field, give the widget a name that reflects the information being displayed.
3. In the Type field, select Time series.
   If you change the value of Type after you fill in other fields, those fields are cleared.
4. In the Visualization field, select Stacked Column.
5. In the Indicator field, select the main indicator for which you want to show scores.
6. Fill in any of the following fields:

   Field	Description
   Breakdown and Element	Only the scores that match the specified element of this breakdown are shown. Select values for both Breakdown and Element. Otherwise, only scores that are not associated with any element of the breakdown are shown. Remarque : Instead of specifying an element for the first-level breakdown, you can specify an elements filter in the Elements Settings tab. Use elements filters for creating personal visualizations. For more information, see Additional settings for time series widgets. Important : If the widget is for a formula indicator, all contributing indicators in the formula must support the breakdown. Otherwise an error message instead of a value appears in the widget on a dashboard.
   2nd Breakdown and Element	Drill down to a second level of breakdown and element, if a first-level breakdown and element have been specified. Remarque : Second-level breakdowns must be enabled on the indicator record, in the Collect breakdown matrix tab. Follow element must be disabled. Dashboard breakdowns count as one breakdown level of the two that are possible.
   Time series	Runs a function on the indicator scores for a specific time period, such as a 7-day sum or average. For more information, see Applying time series aggregations. Remarque : Business and fiscal calendars do not support time series aggregations. You cannot set a time series aggregation on a widget for an indicator that uses such a calendar.
   Previous period chart	Compares the scores of the main indicator in similar periods. The Column visualization works well for previous period charts. Also consider setting a Color scheme. Activating Previous Period Chart disables any secondary Widget Indicators.
   Label	Specifies a custom label for the main indicator.
   Color	A single color that applies only to the scores for the main indicator. This field overrides any color selected in Color scheme.
   Color scheme	A spectrum of colors for the scores for all indicators. If only one indicator is shown, only the first color is used. If you do not specify a color scheme, the default color scheme defined by the glide.ui.chart.default.colors property applies. You can create your own color scheme instead of using a provided color scheme. For more information, see Create a color scheme.

7. To have the widget follow the breakdown elements that are selected on a breakdown dashboard, follow these steps:
   1. Select Follow element.

      Selecting this option removes the ability to set a second breakdown and element on the widget.

   2. Facultatif : Set which of the available breakdowns to follow in Followed breakdown.
      Breakdown dashboards let you select a breakdown source and elements. However, an indicator can use more than one breakdown that is based on the same breakdown source. Use this setting to determine which of these breakdowns to apply in a breakdown dashboard.

      For example, the indicator Number of open incidents uses two breakdowns: Assigned to, and Opened by. Both breakdowns are based on the Users.Active breakdown source. Consider the case where you create a widget for this indicator and you have the widget follow elements on breakdown dashboards. You want the widget to display separate values for the elements of the Assigned to breakdown. Therefore, you select Assigned to in the field Followed breakdown.

   3. In Show multiple elements as, select whether to show each element separately or to show an aggregate of elements based on the indicator aggregation.
      Neither all widget visualizations nor all indicators support both aggregate and separate views. For automated and external indicators, only COUNT, SUM, MAX, and MIN data aggregations support aggregate views. COUNT DISTINCT and AVG do not. For more information, see Showing multiple elements separately or aggregated.
   Important :

   Do not specify a breakdown and element on the widget record when you want the elements for that breakdown to be selected on a breakdown dashboard. The element on the widget record overrides any elements selected on the breakdown dashboard for that breakdown.
8. Facultatif : Review the Settings tabs and change settings as desired.
   For more information, see Additional settings for time series widgets
9. Right-click the form header and select Save.
10. Add additional indicators in the Widget Indicators related list, giving each indicator the Stacked Column visualization.

Que faire ensuite

To view the widget, add it to a dashboard or a portal.

Concepts associés

• Performance Analytics widgets on Service Portal
• Considerations when creating a time series widget

Tâches associées

• Edit a responsive dashboard
• Add widget indicators