Hi all,
My interest is to calculate the THROUGH PUT time for all the desired set of process flows. I would like to view the distribution over a BOX PLOT. I am using the below approach.
CASE WHEN
PROCESS EQUALS 'event A' TO ANY TO 'eventB' then 'Process1'
WHEN PROCESS EQUALS 'event B' TO ANY TO 'eventC' then 'Process2'
END
The above formula will act as dimension axis for my box plot. I am calculating the tp time accordingly.
However, since most of my cases(for e.x. 97%) satisfy the first condition, i cannot seem to calculate the tp time independently for other event or process correctly. The tp is calculated only for the remaining cases.
Kindly suggest any other approach for the same.
Thank you in advance :)