Example: A(1)-C-B(1)-A(2)-B(2)-N-A(3); In this case I need the throughput time between A(1)->B(2). any ideas?
For the rest it should show me values like
C->B(1),
B(2)->N and
N->A(3)
Currently I use something like the following
DATEDIFF(dd, SOURCE ( "ACTIVITIES"."EVENTIME" ),TARGET( ( "ACTIVITIES"."EVENTIME" )))
However this works for the rest of the flow but for A(1)->B(2) it will just return 0
Does not answer my question @ilmi.hajdi I am looking for specific flow i.e for this case A(1)-C-B(1)-A(2)-B(2)-N-A(3); time between A(1)->B(2)
For the rest it should show me values like
C->B(1),
B(2)->N and
N->A(3)
Maybe CASE WHEN and several PROCESS EQUALS (one for each combination)?
HTH
Maybe CASE WHEN and several PROCESS EQUALS (one for each combination)?
HTH
Would be very difficult to make it dynamic..
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
