Thank you for your feedback.
Form temporarily unavailable. Please try again or contact docfeedback@servicenow.com to submit your comments.
Versions
  • London
  • Kingston
  • Jakarta
  • Istanbul
  • Helsinki
  • Geneva
  • Store
Close

Create a stacked column visualization for a time series widget

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.

Before you begin

Role required: pa_power_user or admin

About this task

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
Four indicators for regional sales centers stacked in each column to show both the relative contribution and the sum of all regions

Procedure

  1. Navigate to 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. (Optional) Fill in any of the following fields:
    FieldDescription
    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.
    2nd Breakdown and Element Drill down to a second level of breakdown and element, if a first-level breakdown and element have been specified.
    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 Time series aggregations in scorecards and widgets.
    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.

    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 a spectrum cannot be applied, only the first color is used. You can create your own color scheme instead of using a provided color scheme.
    Follow element Applies only when this widget is placed in a "breakdown dashboard." Select this option for the widget to follow the element that the user selects interactively on the dashboard. See Using breakdowns on dashboards.

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

    Follow breakdown Breakdown dashboard configurations specify breakdown sources, not specific breakdowns. The same breakdown source can be used for multiple breakdowns. Therefore, select this option to set which of the possible breakdowns to follow.

    For example, consider the indicator Number of open incidents. This indicator uses two breakdowns: Assigned to, and Created by. Both breakdowns are based on the Users.Active breakdown source. You create a widget for this indicator and you select Follow element on this widget. You also need to select Follow breakdown and specify either the Assigned to or the Created by breakdown.

    This option is available only if Follow element is selected.

  7. (Optional) Review the Settings tabs and change settings as desired.
  8. Right-click the form header and select Save.
  9. Add additional indicators in the Widget Indicators related list, giving each indicator the Stacked Column visualization.

What to do next

To view the widget, add it to a dashboard.