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
)
Hi @michal.letka11Â
Â
Â
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.