This function is part of Process Mining (PM) functions in Axcel and calculates the amount of time that no activity occurs (idle time).
AXCEL.PM.IDLE.TIME(data, [level], [units], [plot])
The AXCEL.PM.IDLE.TIME 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, 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 frequencies based on resource. User can define the level as “log”, “case”, “trace”, “resource”.
units Optional. Axcel by default use days as the unit. User can define the units as “days”, “hours”, “mins”, “secs”, and “weeks”.
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 idle times 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: