Calculating process throughput time only during working hours

Help Process Mining
,
1

Hi, let’s assume that a process arrives at 17:00 and the shift ends at 18:00. If this process is processed at 10:00 the next day and the working time starts at 09:00, the throughput time of this process is calculated as 17 hours.
However, if we could calculate it as working hours, the processing time of this process was actually 2 hours. (between 17:00 and 18:00 and the next day between 09:00 and 10:00)

Is there any possibility that we can calculate workdays and working hours in the Process Mining application? So we can use avg. throughput time more efficiently.

2

Hey Onur,

The answer will be different depending on the version. Which version of the PM product are you using? Standalone, Automation Cloud or Automation Suite?

4

Update; It is Standalone.

5

Hi there, is there any update for this case? :slightly_smiling_face:

6

I am interested in this as well. Thanks!

7

Hey, sorry for the late response.

The way to achieve this in the standalone product is by using the workdaydiff function:

workdaydiff(Unit, Time1, Time2, DateTime1, DateTime2)

It returns the difference (DateTime2 - DateTime1) given a workday start (Time1) and end (Time2).
workdaydiff ignores time worked in the weekend and outside the workday.

8

Hi @Martijn_Wijffelaars artjin, how do we do the same for cloud version? We want to skip weekends and holidays for late delivery calculations.

9

Hello @nishad.fasge,

Welcome to our community! Hope you are doing well!

You can use the macro within the transformations. You could take a look at this blogpost by dbt explaining how they solved it, they also have some sample data and code available for this approach here.