Breakdown

This widget visualizes the division or distribution of your data in charts.

For example, you can display the average cycle time, grouped by customer type and city.

Add and configure the widget

Follow these steps:

  1. In your investigation or dashboard, click Add widget and select a widget.

    The widget configuration dialog opens. You define which data to display on the left, and preview this data on the right.

  2. Define the following:

    Option Mandatory Description
    Name no

    The name is displayed as the widget title.

    If you don't provide a name while configuring this widget, a name is set for you. In this case, if configured using metrics, the metric name is used for the default name. For other configuration types, the widget type is used as the default name.
    Description no

    The description is displayed as info text when users click in the widget.
    Widget type yes

    Choose an option:

    • Attribute

    • SIGNAL code

    • Metric

    Depending on the widget type, further configurations options can be available.

  3. Depending on the chosen widget type, continue with one of the following:

  4. To preview the result of your data selection, use the following options in the preview area on the right:

    • Preview - Display the chart or diagram with the data that's retrieved

    • Data view - Display the query result as a table

    • SIGNAL view - Display the SIGNAL query

    • Attributes - Display the available case and event attributes

    It depends on the configuration type which preview option is available. For example, attributes can only be displayed here when the widget is configured with SIGNAL queries or metrics.

  5. Click Save.

    The widget is added.

Configure with attributes

Configure the following:

Option Mandatory Description
Attribute inputs yes

Set the following:

  • Aggregation input, for example event or case attributes

  • Aggregation function:

    • SUM

    • COUNT

    • AVG

    • MIN

    • MAX

To add more attributes, click Add Input.
Group by yes Choose how to group the data, for example by case attributes.

Configure with a SIGNAL query

Configure the following:

Option Mandatory Description
SIGNAL query yes

Provide a SIGNAL query. A sample query is provided by default.

Read about the SIGNAL editor functions like autocompletion, color scheme, and error linting in section The SIGNAL code editor.
Chart type yes

Select a chart type in the preview area.

Vertical stacked bar chart is the default setting.

Read more in section Set chart type.

Configure with metrics

Configure the following:

Option Mandatory Description
Metric yes

Choose a metric.

The following applies:

  • You can select metrics with the status valid or invalid, and customize invalid metrics later if necessary.

  • Only metrics of the aggregation type over cases are available here. Read more in section Where to use metrics.

  • For a dual axis chart you need to select 2 metrics.
Group by yes Choose how to group the data, for example by case attributes.
Chart type yes

Select a chart type in the preview area.

Vertical stacked bar chart is the default setting.

Read more in section Set chart type.

Set chart type

Breakdown widgets configured with attributes can only display bar charts. For SIGNAL- and metric-based widgets, different chart types are available.

You can set the following chart types in the widget configuration dialog:

  • Column chart

    If the orientation is vertical, the values are vertically arranged on top of each other. If the orientation is horizontal, the values are arranged next to each other. The distribution of the values is represented by the bar stripes. The resulting bar represents the total value.

    Vertical orientation:

    Horizontal orientation:

  • Column chart

    Values are represented as vertical or horizontal bars.

    Vertical orientation:

    Horizontal orientation:

  • Tree map

    Hierarchical data is displayed as nested rectangles.

  • Pie chart

    Values are represented as pie slices to show relative sizes of data.

  • Dual axis chart

    The values of two attributes or metrics are displayed on one chart to illustrate the relationships between the values.

    You need to select two attributes or metrics in the widget configuration dialog, otherwise the chart can't be created.

    The bars represent the values of the first selected attribute or metric, the line graph represents the values of the second selected attribute or metric.

    To swap the representation, change the orientation from horizontal to vertical or vice versa.

    The average cycle time per case is represented as bars, the number of events as a graph. Both metrics are grouped by city.

  • Heat map

    For a heat map to be created, the following applies:

    • If the widget is configured with attributes, you need to select 1 attribute and 2 grouping options.

    • If the widget is configured with metrics, you need to select 2 metrics in the widget configuration dialog.

    • If the widget is configured with a SIGNAL query, you need to specify 2 dimensions in the query.

    Otherwise, the chart can't be created.

    The values of two metrics are represented by colored fields. This visualization type is helpful to identify patterns. The color scale represents the range between the minimum value and the maximum value. The value range can be reduced to any range of interest by moving the sliders.

    The range of values was reduced to 9-27 cases, using the bottom slider. Values outside this range aren't displayed.

  • Sankey chart

    You need to select two or more case attributes and one metric or a counted or summed case attribute that represents a quantity in the SIGNAL query, otherwise the chart can't be created.

    The flows based on selected attribute values are represented by links. The width of the links is proportional to the quantity or size of the flow.

    Hover over the diagram to display the value of the visualized quantity:

  • Table

    When you choose this chart type, the widget is turned into a SIGNAL table widget. Then, you can't turn it back into a Breakdown widget. Read more in section SIGNAL table.

    The values are represented in a table.

    You can group the table values with in the widget title. To ungroup, click .

    Ungrouped (default):

    Grouped by city:

Sort charts

You can sort data in column charts, pie charts, and dual axis charts. For that, select the value to sort and the sort order.

Sorting by either attribute, metric, group, or event depends on the widget configuration. For example, sorting by a metric is only possible if the widget is configured with a metric.

The following applies:

  • By default, charts aren't sorted, and data is displayed in random order.

  • When sorting is applied, the default sort order is as follows:

    • Numbers are arranged from high to low.

    • Text values are arranged is ascending alphabetical order (A-Z).

    • Date and time values are arranged from older to newer.

  • Sorting by variant isn't supported.

  • If the widget is configured with a SIGNAL query, the ORDER BY clause controls the sorting.

What you can do in the widget

Show or hide data groups

For data that's grouped several times, you can show or hide the groups in the widget. To do so, click the groups in the chart legend.

Drill down into data

Explore multidimensional data by navigating from one level down to a more detailed one. For this, you don't need to configure a new widget.

To drill down into your data, click in the widget and select an option. The result set is opened as a new widget.

The following options are available:

  • Break down by another attribute you select

  • View over time

  • View distribution

Which option is available depends on whether you have selected data in the widget.

Add a threshold

You can add a threshold to define boundaries for different regions of acceptance. You have the following options to set and visualize the threshold:

Follow these steps:

  1. Click in the widget, then Threshold.

    The threshold configuration dialog opens.

  2. Select the threshold option.

  3. Specify the value and a label for the threshold.

  4. You can re-assign the three available background colors. To do so, click the color bar and select the color. To swap the color assignment, click Swap color order.

  5. Confirm with Save.

    The threshold is added according to your settings.

When you add thresholds to a widget, you can link it to a Live Insights shape in SAP Signavio Process Manager. Read more in section Add Live Insights.

To remove a threshold, select None in the threshold configuration dialog.

Add a filter based on selected data

You can select one or more bars and use this selection to set a filter:

  1. Select the data.

    You can select a single bar, a range of bars, and several individual bars.

  2. Click in the widget and choose an option:

    • Filter investigation

    • Filter chapter

    • Filter widget

    You can include or exclude the selected data.

    The data is filtered.

Export data as CSV

To export the widget data, click in the widget and select Export as CSV. The file is saved to your browser's download folder.

The delimiter used is a comma.

Values for cycle time

Values for cycle time are always exported as milliseconds. If you need a different time format, you need to convert the milliseconds outside of SAP Signavio Process Intelligence.

Amount of data exported

By default, the widget displays no more than 500 rows of the data set. If this default limit is set, all the data obtained with the widget configuration is exported.

For widgets configured with a SIGNAL query, you can change the default limit value by customizing the LIMIT clause. Once you change the default limit, the appropriate amount of data is exported. This applies when you increase the limit, decrease it, or set it back to 500 rows.

If you again want to export all the data obtained with the widget configuration, you need to create a new widget.

Next steps

Creating an Insight for Investigations or Dashboards

Filter a widget