The new feature Working Hours Duration calculation in Mavim Process Mining is a powerful tool that helps businesses understand their workflows better in relation to their working hours. By analyzing events data considering only the working days and workings hours; it highlights the process executions by analyzing the duration of only the working hours. It helps process analysts to uncover inefficiencies and guides decision-making for process improvements.
How is duration in working hours calculated?
The workings hours timeframe is Monday through Friday from 08:00 a.m. till 18:00 p.m..
Let's take a look at some examples:
- Thursday 11 January 2024 13:32:00 p.m. is inside of the working hours timeframe
- Saturday 13 January 2024 10:04:34 a.m. is outside of the working hours timeframe
- Monday 25 March 2024 18:44:32 p.m. is outside of the working hours timeframe
- Wednesday 5 June 2024 13:56:00 p.m. is inside of the working hours timeframe
The duration in working hours is calculated between 2 timestamps: the timestamp of the activity and the timestamp of the succeeding activity. However; when the timestamp of the activity falls outside of the working hours timeframe is will calculate the duration until the timeframe. Let's take a look at the examples:
How to configure the working hours duration
You can find the working duration by searching in the data column that end in: "_workinghours":
In the result of the search; you can find:
- In the cases table:
- Duration_days_workinghours: refers to the duration of a case in the working hours calculated in terms of days.
- Duration_seconds_workinghours: refers to the duration of a case in the working hours in terms of seconds.
- In the event log table; all the measure of the duration is in milliseconds:
- duration_at_start_workinghours: refers to the duration at the start of the event.
- activity_duration_workinghours: is the duration in working hours between two activities
- duration_idle_workinghours: is the duration between timestamp_end to timestamp_start
- duration_workinghours: is the duration between activity and activity target
How to work with duration working duration
Cases working hours duration
If you want to use working duration instead of the whole duration; you can simply replace the duration_days or duration_seconds by duration_days_workinghours or duration_seconds_workinghours from cases table in any visual you wish to do so.
Events working hours duration
If you want to use working duration instead of the whole duration; you can simply replace the duration by duration_workinghours from the event log table in any visual you wish to do so; for example: