Connect the datasheet and configure the paths

Use the “PATHS DATA” tab to connect to your datasheet and configure the behaviour and look-and-feel of all paths in you Process Mining extension.

Select Paths Data

This is where you select the sheet that holds your data, also referred to as the ‘datasheet’

Once you selected the ‘datasheet’ the rest of the fields will be populated with all the available fields of that sheet. So next option to configure is the “Activity” field.

Activity

The activities in your process are what will be shown on as nodes in your process map, they are the events of the process. This is where you will be able to see where the real bottlenecks are in your organisation, which events are taking too much time and which are taking the happy paths. ProcessMining will clearly show which activities need more attention than others.

Case Identifier

Choose which column holds the unique identifier of the cases flowing through your process. Each case will have a complete flow of the activities and time taken. Use dashboard actions for example to link to a sheet on your dashboard to see the flow of each individual case within the extension.

Start Time

Select the Date/Timestamp from your ‘datasheet’ that represents the start of an activity. As stated before the best way to store your dates is in a discrete “exact date” value.

End time (optional)

Select the field that contains the end Date/Timestamp on your ‘datasheet’. This field is not a required field to operate the ProcessMining extension but enables you to calculate the ‘Waiting time’ it takes for cases to move from one activity to another (so the time between the end of axtivity X and the start of activity X+1)

Position of Time KPI

If only one date time stamp is specified, this option allows for the configuration of the time KPI. By default, time between start dates will be displayed on the activities. But by checking this box, they will be displayed on the paths instead.

Custom Measure

When the default KPI’s / measures in the ProcessMining extension are not sufficient for your use case you can also add an extra custom measure to your ‘datasheet’ and select it in this field to be part of your ProcessMining analytics.

Reverse Data

If the sorting in your ‘datasheet’ is not as expected but it seems to be in reversed order, this switch can easily help you out in reversing the order of your activities.

Pagination

Enabling pagination will set your data to load in chunks (or “pages). This enables use-cases with large numbers of rows.

Limit Data

When configuring or changing the extension, limiting data will improve performance. This allows users to quickly have their changes reflected in the visualisation.