hi, I would like to calculate number of cases that have some particular throughput time. I want to divide total number of cases for the cases that happened in less than 4 days and for hose that happened in more than 4 days. I tried to use avg but it calculates for all of the cases and put them all in one column. To be clear: there are cases with status "Closed" that have TT<4, but in the table I have 0 there (in column case count where TT<4)
Page 1 / 1
status is a column in Case Table
I found a way. Instead of KPI, I used Dimension
COUNT (
CASE
WHEN
(
CALC_THROUGHPUT (
ALL_OCCURRENCE 'Process Start' ]
TO
ALL_OCCURRENCE 'Process End' ] ,
REMAP_TIMESTAMPS ( "_CEL_ISSUE_ACTIVITIES"."_EVENTTIME" , DAYS )
)
)
< 2
THEN
"_CEL_ISSUE"."_CASE_KEY"
ELSE
NULL
END
)
I guess below PQL query will also work.
CASE WHEN
CALC_THROUGHPUT(
FIRST_OCCURRENCE 'Activity 1'] TO LAST_OCCURRENCE O'Activity 2'],
REMAP_TIMESTAMPS(
"_CEL_ISSUE_ACTIVITIES"."_EVENTTIME" , DAYS
)
) < 2 THEN "_CEL_ISSUE_ACTIVITIES"."_CASE_KEY"
ELSE NULL
END
You can check this out.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.