PM.TRACE.EXPLORER

You are here:

AXCEL.PM.TRACE.EXPLORER function

This function is part of Process Mining (PM) functions in Axcel and explores traces, ordered by relative trace frequency.

Syntax

AXCEL.PM.TRACE.EXPLORER(data, [coverage])


The AXCEL.PM.TRACE.EXPLORER 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 xresource 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 xresource 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 xresource y 2012-01-02T12:23:00.000+01:00 start1
record 1process xresource y2012-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.

coverage Optional. The percentage coverage of the trace to explore. Default is 20% most frequent. If the number is negative, the most infrequent traces are reported.


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.EXPLORER(A1#,0.99)

After execution, the details of the event is shown in the console and a plot is also generated in the task pane: