Over time

This widget displays activities in your process over time. For example, you can see cycle time over days and weeks, the amount of cases during a certain duration, or the volume of help requests.

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 Read more in the sections below.

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

   • Configure with attributes

   • Configure with a SIGNAL query

   • Configure with metrics

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
Aggregation inputs	yes	Set the following: Aggregation input, for example events or case attributes Aggregation function: SUM COUNT AVG MIN MAX
Interval	yes	Choose an option: Day Week Month Quarter Year
Group by	no	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. Line 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.
Interval	yes	Choose an option: Day Week Month Quarter Year
Group by	no	Choose how to group the data, for example by case attributes.
Chart type	yes	Select a chart type in the preview area. Line chart is the default setting. Read more in section Set chart type.

What you can do in the widget

Set chart type

Different chart types are available for SIGNAL- and metric-based widgets. Widgets configured with attributes can only display line charts.

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

• Line chart

  Values are displayed as a series of data points which are connected by straight line segments.

  View a line chart for the average number of reworks per case, per month

  Ungrouped:

  

  Grouped by city, by adding a grouping option in the widget configuration:

  

  You can also create line charts with SIGNAL queries that don't relate to time data. For example, you can render the amount of sales cases in cities. Read more in section SAP Signavio Analytics Language.

• Stacked area chart

  A stacked area chart is a line chart where the areas between each line and the line below are shaded with a color. When breaking down the values into groups, the groups are vertically arranged on top of each other. Each group has a different color.

  The top line shows the sum of all groups. When hovering over the chart, tooltips show the specific data values for each group.

  View a stacked area chart for the average number of reworks per case, per month

  Ungrouped:

  

  Grouped by city, by adding a grouping option in the widget configuration:

  

• Table

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

  The values are represented in a table.

  View a table for the average number of reworks per case, per month

  Ungrouped:

  

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

  Grouped by city:

  

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 break down the data, click in the widget. Select Breakdown by and an attribute.

  A new widget opens.

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:

• Line

  The threshold is displayed as a dashed line including the threshold value and label.

  View a widget with a threshold line and a label

  

• 2 regions

  Different background colors for the upper and lower region are assigned.

  View a widget with a threshold line, 2 regions, and a label

  

• 3 regions

  A second threshold can be set to define an upper and lower threshold. This results in three regions: Above the upper threshold, below the lower threshold, and between the thresholds.

  View a widget with 2 threshold lines with labels and 3 regions

  

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 data point or a range of data points and use this selection to set a filter:

1. Select the data.

2. Click in the widget and choose an option:

   • Filter investigation

   • Filter chapter

   • Filter widget

3. Click Include selection.

   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

Create an insight for an investigation

Filter a widget