- 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
Filters
Filters can be created on dashboards and used to modify the information displayed on all dashboards. With filters, you can create subsets of your data to have a closer look at particular parts of the process. Filters can be created from the header bar and the Filters panel. See the illustration below.
The Period filter is a predefined and immovable filter. This Period filter splits the data according to the start date of relevant items in the dashboard. For example, purchase order items or events, in the selected period. See the illustration below.
You can also select a custom period to be used as the period filter. All relevant items that have a start date within the defined period are displayed in the dashboard.
Follow these steps to select a custom period.
- Click on the Period filter button in the header bar.
- Click on the Type list box and select the Custom option from the list.
- Click on in the From field and select the start date of the custom period you want to define from the date picker.
- Click on in the To field and select the end date of the custom period you want to define from the date picker.
See the illustration below.
Process apps contain multiple advanced filter types. These filters can be added to the dashboard and used to modify the information displayed. You can add filters for analyzing in more detail in the Filters panel.
Follow this step to display the Filters panel.
The Filters panel is displayed to the right.
Follow these steps to add a filter.
If you want to add a particular filter, you can search for available filters.
Selections in the dataset allow you to create a filter based on the information displayed in the dashboards. Selections can be triggered by dragging your mouse or by clicking on the graphs and charts.
Follow these steps to create a filter based on a data selection.
- Select the data you want to use to create a filter.
- Select the Filter icon on the chart to open the Filter menu.
- Select the Filter by selected values option.
A filter is added to the Filter panel.
Instead of using the Filter menu you can also right-click and select Filter by selected values from the context menu.
The Filter icon is only visible when you have made a data selection.
To easily find a particular filter, you can search for applied filters.
Follow these steps to search for applied filters.
- Go to the Filter panel.
- Select the icon to open the Search... field.
- Start typing the filter you want to find in the Search... field.
Cases
, for example, Purchase order items
, or Incidents
.
The Activity end-to-end process filter enables you to select activities to filter on cases that include the selected activities.
Filtering on cases that do not include the selected activity
If you want to filter on cases that do not include particular activities, you can select the Without option next the activity. See the illustration below for an example.
With the Directly follows and Indirectly follows end-to-end process filters you can filter particular activity paths, meaning directly or eventually followed activities. This enables you to analyze cases in which activities follow a certain order.
Creating a Directly follows filter
Follow these steps to add a Directly follows filter.
Creating an Indirectly follows filter
Follow these steps to add an Indirectly follows filter.
You can also create a Directly follows filter, or Indirectly follows filter, by clicking on an edge in the process graph and selecting the Filter by selected values option from the context menu.
If you want to filter on cases that do not follow a particular activity path, you can select the Without option for the Directly follows or Indirectly follows filter. See the illustration below for an example.
With the Starts with and Ends with end-to-end process filters, you can filter for cases that start or end with a selected activity. You can select the Without option if you want to filter for cases that do not start or end with the selected activity.
The Rework filter enables you to filter for cases that have rework, meaning that one or multiple activities are executed more than once in the process.
Follow these steps to create a Rework filter.
- Add a Rework filter in the Filter panel.
- Select the activity for which you want to filter the occurrences from the Show cases where activity list.
- Use the Occurs .. times fields to select an operator (
<=
,>=
,=
) and the number of occurrences to define the filter expression.
A list box filter allows you to select multiple values of a field.
Select all / Deselect all
You can select the Select all option to select all the options from the list box in one click.
Invert
You can click on Invert to change all unselected values into selected values, whereas all selected values will become unselected.
A range selector is created for numeric fields and time ranges. This filter allows for a range to be selected. You can either drag the dots on the line to select a range, or enter the desired start and end values in the value fields.
See the illustration below for an example.
For time ranges you can change the granularity of the selected range by selecting a different units from the drop-down lists. See the illustration below for an example.
The Clear all option in the Filters panel enables you to reset all the current filters. This means that any selections in advanced filters are cleared and all filters are removed from the Filters panel.
Follow these steps to reset all filters.
- Go to the Filters panel.
-
Select the More icon.
-
Select Clear all from the menu.
When you have set one or more filters, you can save these filters in a filter collection. This enables you to quickly and easily navigate to your frequently used filters when analyzing data.
Follow these steps to create a filter collection.
-
Add one or more filters.
-
In the Filter panel, select the More icon next to the Filter collections drop-down list, and select Save as filter collection.
-
In the Save filter collection dialog, enter a Name and a Description for the filter collection.
You can change a filter collection, for example, by adding a new filter.
Follow these steps to change a filter collection.
-
In the Filter panel, select the filter collection you want to change.
-
Change the filters as desired.
-
Select the Save icon next to the Filter collections drop-down list.
Follow this step to manage existing filter collections.
-
In the Filter panel, select the More icon next to the Filter collections drop-down list, and select Manage filter collections.
The Manage filter collections dialog is displayed. Here you can edit the Name or the Description for a filter collection, or you can delete the filter collection.
Follow these steps to edit the name and/or the description of the filter collection.
-
In the Manage filter collections list, locate the filter collection for which you want to change the Name or Description.
-
Select the Edit icon.
-
Edit the Name or Description as desired.
When you open a dashboard that contains one or more charts with chart filters, those charts will display data according to the chart filters. When one or more filters are defined for a chart, the icon is displayed at the top of the chart.
You can select the icon to view the applied chart filters. The following illustration shows an example of chart level filters.
You can still add global filters in the Filter panel, which are applied on top of the chart filters. You cannot change the chart filters.
- Introduction
- Period Filter
- Defining a Custom Period
- Filters Panel
- Adding a filter
- Adding filter values
- Data selections
- Searching applied filters
- Percentage Cases and Events
- Process filters
- Activity Filter
- Directly follows and Indirectly follows
- Starts with or Ends with
- Rework filter
- Filter types
- List box
- Combo box
- Range selector
- Resetting filters
- Clear All
- Resetting Individual Filters
- Filter collections
- Introduction
- Creating a new filter collection
- Changing a filter collection
- Managing filter collections
- Changing the name or description of a filter collection
- Deleting a filter collection
- Applied chart filters