Add a table widget

We can now add table widgets to the new dashboard. These widgets help us better analyze process data based on selected metrics in a tabular format. We can display the following types of tables:

  • Cases table: Displays the start time, end time, duration, and other performance statistics for each case in the process.

  • Case variant table: Displays the performance statistics for each grouped case variant in the process.

  • Case attribute table: Displays the performance statistics for each case attribute in the process.

  • Event attribute table: Displays the performance statistics for each event attribute in the process.

  • First touch statistics table: Displays the performance of the process based on who first handled a case and what activity was first performed.

To create a table in the new dashboard, click Add widgets > Table.

Table002

Cases table

Let’s imagine in our loan origination log, we wish to display a case table that shows which individual loans took the most time to complete.

Select the loan origination log and click Select logs.

Table003

This displays the Cases table.

Table004

We can add or remove columns from the displayed table. To specify the columns to display, click Add.

Table005

Select the columns.

Table006

We can also specify how the columns should be arranged. To sort the columns in order, click Sort by.

Table007

  • A to Z: Arrange the columns in alphabetical order

  • Z to A: Arrange the columns in reverse alphabetical order

  • Statistics first: Displays the statistics columns first before the case attribute columns.

  • Case attribute first: Displays the case attribute columns before statistics.

Once done, click Add to confirm the table columns.

Table008

At any point, we can remove a column by clicking the delete icon.

Table009

To display more rows or columns, increase the size of the table widget.

Table010

When in view mode, we can sort the table rows based on a column. In our case, we wish to display the longest cases first. Click View to exit edit mode.

Table011

To sort by duration, click the Duration column. Click Z to A to sort in descending order, displaying the longest cases first. We can also adjust the width of each column.

Table012

Case variants table

A case variants table groups cases by similar pathways and displays the metrics for each variant. Imagine we wish to display the most frequent pathways in the process and review their aggregated performance; we use the case variants table. In the Types dropdown, click Case variants.

Table013

This displays each case variant and its corresponding number of activity instances, cases, and average duration.

Table014

We can display more columns by clicking Add.

Table015

Select the columns to add and click Add.

Table016

To view the case variants with the most number of cases, go to the view mode and sort by Cases.

Table017

Case attribute table

A case attribute table displays the performance statistics of attributes in the process. Imagine we wish to display the percentage distribution of brokers used across all cases. Since “Broker” is a case attribute, click Case attribute as the table type.

Table018

In the Attribute dropdown, select the case attribute to display. In our case, we select Broker.

Table019

This displays the statistics of each broker, including the percentage of cases they appear in.

Table020

We can click Add to specify the statistics to display in the columns.

Table021

Select the statistics and click Add.

Table022

The table columns get updated based on what is selected.

Table023

Event attribute table

An event attribute table displays the performance statistics of event attributes in the process. Imagine we wish to create a table that displays which role performs the first activity in the loan process. Given that “Role” is an event attribute, select Event attribute as the table type.

Table024

In the Attribute dropdown, select the attribute to display. In our case, we select Role.

Table025

Since we only want to focus on the first event in the process, click the Data set dropdown.

Table026

  • All event values: All event instances are considered for computing the table statistics.

  • First event value: Only the first event instance is considered to compute the table statistics.

  • Last event value: Only the last event instance is considered to compute the table statistics.

To display the roles that perform the first activity, select First event values.

Table027

First touch statistics table

The first touch statistics table allows us to understand the process performance based on the first-touch activities and first-touch resources. We can add a first touch statistics table to the new dashboard. To add a first touch statistics table, add a table widget. In the Types dropdown, click First touch statistics.

Table028

This displays the table.

Table029

We can configure how the table is displayed.

  • All activities: Displays the performance statistics for each first-touch resource, separated by individual first-touch activities.

  • Aggregate: Displays the overall performance statistics for each first-touch resource, aggregating all their first-touch activities into a single row.

  • Both: Displays both the detailed activity-level statistics and the aggregated view together.

Table030

We can also select up to five first-touch activities. Click Add in the Activities component.

Table031

Select the first touch activities and click Add.

Table032

Click Update to update the table.

Table033

The table statistics are updated based on the first touch activities selected. Also, we can edit the table to include more columns. In the Columns component, click Add.

Table034

Select the columns to include and click Add.

Table035

Click Update to update the table. The table gets updated to include the added columns.

Table036

Design a table widget

We can design a table widget to include colors. To add colors, go to the Design tab.

Table037

We can decide whether to add the color to either the table header or its border. To add a color to both, select Header and Border.

Table038

Finally, select the color to use from the displayed colors.

Table039

We can also custom colors by entering its hex code.

Table040