In this step, drag the mandatory labels to the corresponding columns from your data source. You can additionally label other source columns using optional labels, such as Resource.

Mandatory column labels

To create a working View, Pega Process Mining must ingest the following mandatory information from the data source:
  • Activity: The action/activity that is going to be traced
  • Case ID: The ID that represents a Case in your event log
  • Timestamp: The date time when the activity took place

Use the mandatory column labels to associate this required information with the corresponding columns in your data source. For example, define a column named ID as the Case ID by dragging Case ID to the ID column. The following demo shows an example of defining key columns:

Animation shows how to drag mandatory labels to corresponding columns.
Defining key columns

Optional column labels

To increase the informational value of the dataset, you can drag any of the following optional labels to corresponding source columns:
  • Resource: The agent or resource that performed the activity.
  • Resource Group: The resource role, section, or group.
  • Cost: The cost of the activity.
  • Order: Set a column to order events over Cases in the dataset. Use this property in case of parallel events. For example, use Order when the dataset includes events within the same Case that have the exact same timestamp.
  • End timestamp: The date and time when the activity ended.
  • Duration timestamp: The amount of time it took to complete the activity.
    NOTE: If you want to add duration information, you only need to select either the End timestamp or the Duration timestamp column, not both. If you include either of these columns in the import, then users can perform predictive analyses on the data. For instance, it becomes possible for Pega Process Mining to predict how much longer open Cases might take to finish.
    CAUTION: Ensure that the column for duration does not contain null values. If you select a column for duration that has null values, then these null values create errors in the process View.

For example:

Labeling a Resource column provides deeper analysis opportunities by adding Resources as a Social Metric in the application. Such metrics help you to answer questions such as, "What is the average time an employee takes to complete a selected activity?"

The following figure shows the Resource label associated with the Assignee column.

The optional Resource label is associated with the Assignee column.
Labeling a Resource column