PM.RESOURCE.INVOLVEMENT

You are here:

AXCEL.PM.RESOURCE.INVOLVEMENT function

This function is part of Process Mining (PM) functions in Axcel and calculates the involvement of resources.

Syntax

AXCEL.PM.RESOURCE.INVOLVEMENT(data, [level], [plot])


The AXCEL.PM.RESOURCE.INVOLVEMENT 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.

level Optional. By default, Axcel calculates frequencies based on resource. User can define the level as “log”, “case”, “activity”, or “resource”.

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.RESOURCE.INVOLVEMENT(A1#,,TRUE)

After execution, a table of resource involvement 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: