This function is part of Process Mining (PM) functions in Axcel and generates a process map.
The AXCEL.PM.PROCESS.MAP 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|
type Optional. By default Axcel uses absolute type but user can define “absolute”, or “relative”. Here is the definition of each:
- Absolute frequency of flows
- Relative frequency of flows
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, the details of the event is shown in the console and a process map is also generated in the task pane: