PM.PRECEDENCE.MATRIX
AXCEL.PM.PRECEDENCE.MATRIX function
This function is part of Process Mining (PM) functions in Axcel and generates a precedence diagram. A precedence diagrams is a two-dimensional matrix showing the flows between activities. It can be contain different type values, by adjusting the type argument.
Syntax
AXCEL.PM.PRECEDENCE.MATRIX(data, [type], [plot])
The AXCEL.PM.PRECEDENCE.MATRIX 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 |
… | … | … | … | … | … |
type Optional. By default Axcel uses absolute type but user can define “absolute”, “relative”, “relative-antecedent”, “relative-consequent”, or “relative-case”. Here is the definition of each:
- Absolute frequency of flows
- Relative frequency of flows
- Relative frequency of flows, for each antecedent
- I.e. given antecedent A, it is followed x% of the time by Consequent B
- Relative frequency of flows, for each consequent
- I.e. given consequent B, it is preceded x% of the time by Antecedent A
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.PRECEDENCE.MATRIX(A1#, ,TRUE)
After execution, a table of precedence matrix 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:
