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"

Page 1 / 1

You can try this.

CASE WHEN "CASE"."STP Fail" = 'Yes'

THEN CALC_THROUGHPUT(ALL_OCCURRENCEN'Process Start'] TO ALL_OCCURRENCEN'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.

You can try this.

CASE WHEN "CASE"."STP Fail" = 'Yes'

THEN CALC_THROUGHPUT(ALL_OCCURRENCEN'Process Start'] TO ALL_OCCURRENCEN'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.

Glad to hear that my response was helpful. Feel free to mark it as the correct answer to your question.😊

Sign up