This function is part of Process Mining (PM) functions in Axcel and analyses the trace lengths.
AXCEL.PM.TRACE.LENGTH(data, [level], [plot])
The AXCEL.PM.TRACE.LENGTH 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.
Data should be structured in the order of record, process, resource, and timestamp as follows:
|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.
Data should be structured in the order of record, process, resource, start_time and end_time as follows:
|record 1||process x||resource y||2012-01-02T12:23:00.000+01:00||2012-01-02T12:46:00.000+01:00|
Data should be structured in the order of record, process, resource, timestamp, status and handling_id as follows:
|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 length based on log. 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:
After execution, a table of trace length statistics 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: