How do I calculate throughput time from start to end for cases that did not meet a certain criteria. e.g I want to calculation the throughput time for cases that has a STP Fail = 'Yes"
+6
+6
You can try this.
CASE WHEN "CASE"."STP Fail" = 'Yes'
THEN CALC_THROUGHPUT(ALL_OCCURRENCE['Process Start'] TO ALL_OCCURRENCE['Process End'],
REMAP_TIMESTAMPS("_CEL_ACTIVITIES"."EVENTTIME", DAYS))
ELSE NULL
END
You can apply any aggregate function on top of this - eg. avg(), median(), if you want to display it as a KPI for all cases.
+6
You can try this.
CASE WHEN "CASE"."STP Fail" = 'Yes'
THEN CALC_THROUGHPUT(ALL_OCCURRENCE['Process Start'] TO ALL_OCCURRENCE['Process End'],
REMAP_TIMESTAMPS("_CEL_ACTIVITIES"."EVENTTIME", DAYS))
ELSE NULL
END
You can apply any aggregate function on top of this - eg. avg(), median(), if you want to display it as a KPI for all cases.
Thank you, its works perfectly.
+6Thank you, its works perfectly.
Glad to hear that my response was helpful. Feel free to mark it as the correct answer to your question.😊
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.