- Release notes
- Before you begin
- Getting started
- Integrations
- Managing access
- Working with process apps
- Creating apps
- Loading data
- Uploading data
- Retrieving the SQL Server database parameters
- Setting up a SQL Server account for data upload using an extractor
- Loading data using Theobald Xtract Universal
- Customizing process apps
- Data transformations
- TemplateOne app template
- Purchase to Pay app template
- Order to Cash app template
- Basic troubleshooting guide
Working with dashboards and charts
Process apps use data to visualize and analyze the actual end-to-end process, with all variants and relevant key performance indicators (KPIs). A process app consists of multiple dashboards, visualizing different parts of the input data.
Charts are dashboard items that are used to visualize data on a dashboard. For example a process graph, a bar chart, or a cross-analysis table.
A chart usually contains information about a specific part of the process, e.g. case information or event information. A dashboard can contain multiple charts. See illustration below.
Charts can have different layouts so that various aspects of the process can be shown.
On the left side, two tabs are available that each contain different charts. In the above example, the Details tab and the Trend tab. The right side contains one chart, the process graph.
The KPI bar at the top of the dashboard displays the most important KPIs. KPIs are measurable values used to gauge performance of specific properties over time. KPI is an abbreviation for Key Performance Indicator.
KPIs enable you to check the progress and quality of the process on a regular basis. The goal is to determine if everything is going as expected. If deviations are found, you can do a more detailed analysis and take action to improve or change the process.
Below is a description of the elements.
Element |
Description |
---|---|
|
Black numbers represent the figures of the selected period. |
|
Up arrow numbers represent the positive difference compared to the previous period. |
|
Down arrow numbers represent the negative difference compared to the previous period. |
Metrics can be used to measure the performance of your process. Metrics are used to compute the value for each category, e.g. the number of cases, or the percentage of cases. For example, in the Analysis - End to end dashboard in Purchase-to-Pay the initial value is Number of items. If you select a different metric in the metric selector, the value for each of the categories in the dashboard is modified.
In most dashboards and charts, Event throughput time and Event cycle time metrics are available.
The Event throughput time is the time it takes to execute the event and is calculated as the duration between the Event end and the previous Event end. In this case, any waiting time between the execution of the preceding events is also included in the Event throughput time. The Event cycle time is the actual time it takes to execute the event and is calculated as the duration between the Event start and the Event end. In this case, waiting time is not taken into account.
Event cycle time is only available when both event_start and event_end are defined in your dataset, and is calculated as the time between event_start and event_end. In this case, event_start must be defined for all events. (event_start is only taken into account if every record in the dataset contains a not-null value.) The transition waiting time is calculated as the duration between the evend_end and the event_start of the next event.
The data in charts is displayed based on categories and selections. Selecting a category determines by which field the records in the dashboard are categorized. For example, in the Analysis - End to end dashboard in Purchase-to-Pay the initial value is Number of items. This means all the cases on the dashboard are categorized by number of items.
If you select a different category in the selector, the data in the dashboard changes.
Since dashboards can contain multiple charts, some charts are smaller than others. You can resize the charts by using the horizontal and/or vertical splitters. See the animation below.
You can also resize the columns of a bar chart. See the animation below.
If you want to have a closer look at a chart, you can click the Full-screen button to enlarge the chart and view it in full-screen mode. You can click the Exit full-screen button to reduce the chart to its normal size. See the illustration below.
To enlarge the view on the dashboard, you can select the icon to hide the menu on the left. The button is a toggle button. If you select it again, the menu on the left is displayed.
Selections in the dataset allow you to zoom in on a specific part of the dataset based on the information displayed in the dashboards. Selections can be triggered by dragging your mouse or clicking on the graphs and charts. When you apply a selection, a filter is created and the data in the dashboard is changed according to the selection.
Follow these steps to create a filter based on a selection in the chart.
- Click on a chart and drag to make a selection. The selection is highlighted in the chart.
- Right-click to open the context menu.
- Select Filter -> Filter by selected values from the menu.
When you select a period in a trend chart a Custom period filter is created based on the selection. When you select a range in a distribution chart, a filter is added to the Advanced filter panel.
You can also use data selections for other actions available on the chart. For example, Export.
Both the selection of fields and metrics apply to different dashboards. This makes it possible that in one dashboard a selection is created to analyze, and the same selection can be analyzed further on a different dashboard.
You have several options to sort the data in bar charts using the column sort function. See the illustration below.