PM.TRACE.COVERAGE
AXCEL.PM.TRACE.COVERAGE function
This function is part of Process Mining (PM) functions in Axcel and analyses the structuredness of an event log by use of trace frequencies.
Syntax
AXCEL.PM.TRACE.COVERAGE(data, [level], [plot])
The AXCEL.PM.TRACE.COVERAGE function syntax has the following arguments:
data Required. This is a table of events. Input data could be provided in 4,5, and 6 column formats.
4-column data:
Data should be structured in the order of record, process, resource, and timestamp as follows:
| record | process | resource | timestamp |
| record 1 | process x | resource y | 2012-01-02T12:23:00.000+01:00 |
| … | … | … | … |
In this format, Axcel assumes that all processes are “complete” and every event is an individual process.
5-column data:
Data should be structured in the order of record, process, resource, start_time and end_time as follows:
| record | process | resource | start_time | end_time |
| record 1 | process x | resource y | 2012-01-02T12:23:00.000+01:00 | 2012-01-02T12:46:00.000+01:00 |
| … | … | … | … | … |
6-column data:
Data should be structured in the order of record, process, resource, timestamp, status and handling_id as follows:
| record | process | resource | timestamp | status | handling_id |
| record 1 | process x | resource y | 2012-01-02T12:23:00.000+01:00 | start | 1 |
| record 1 | process x | resource y | 2012-01-02T12:46:00.000+01:00 | complete | 1 |
| … | … | … | … | … | … |
In this format, each record, process and resource action has a start and complete status which are grouped by handling_id.
level Optional. By default, Axcel calculates trace coverage based on trace. User can define the level as “log”, “trace”, or “case”.
plot Optional. If set TRUE, Axcel generates the visualization of the outcome and shows in task pane. Default is FALSE.
Here is an example based on patient-hospital operation data. You can pull this data by executing AXCEL.DATASETS(“hospital-process-mining”). Considering you pulled your data in cell A1#, you need to run:
=AXCEL.PM.TRACE.COVERAGE(A1#,,TRUE)
After execution, a table of traces and corresponding coverages (individual and cumulative) is produced in Excel, the details of the event is shown in the console and a plot is also generated in the task pane since we set plot TRUE in the function:
