Get Cycle Time between two events in Process Intelligence

[Kunalvyas155]

Hello all, 

I would like to get the cycle time between two events in Process Intelligence. I think I can do this by putting in two filters on CT widget. 

1. Put an activity event type filter and select those events 
2. Put a behaviour filter with A~>B 

This ensures that both the events are present in the filtered cases and only those two events are present in those case. 

Is there a more efficient way of doing this ? 
In Celonis, we just have to select 2 events in a single filter and it works. 

[goslingsam · Accepted solution]

Hi Kunal,

Thanks for your question. Sam here from the #SIGNAL Engine team in Process Intelligence.

To calculate the cycle time between two events, I would propose the following query:

AVG (
	(SELECT LAST (END_TIME) FILTER (WHERE "event_name" = 'B')) - (SELECT FIRST (END_TIME) FILTER (where "Event_name" = 'A')
) AS "Cycle time between event A and event B"

Some notes to the query:

• There is a chance the the same event can occur multiple times in a process. For example, "Update Purchase Order Item" could occur multiple times.
  
  • For this reason, the query provided requires you to specify which occurrence (e.g. LAST or FIRST) of the event you would like to use. 
  • The FIRST or LAST end_time of the event will be used in the cycle time calculation.
  • Note, if there is only a single occurrence for an event, then you can use either FIRST or LAST. They will yield the same result.
  • Note, if you require more specifitivity on the event occurrence or the event name, (e.g. taking the event name that occurs directly after another event, or the 3rd occurrence of an event, etc.), additional logic would be required. Such as MATCHES, BEHAVIOUR MATCHES, or something else. 

Please let me know if this solves your problem or not. I have also flagged this as a good candidate to include in our SIGNAL Cookbook, extending on from the Average Cycle Time calculation.