essentially i want to bucket cases based on where their latest event is.
what would be the best PQL clause to use in this instance?
Question
Single KPI - I want to count WIP cases that their latest event matches a specific activity
+4You can try the following syntax for the same
SUM(CASE WHEN PU_LAST(CASE_TABLE,ACTIVITY_TABLE.EVENTIME= 'specific activity' ) THEN 1 END )
This expression counts the number of times the value 'specific activity' appears in the CASE_TABLE
where the condition ACTIVITY_TABLE.EVENTIME= 'specific activity' is true. It uses the PU_LAST function to get the value of the EVENTIME column for the last row satisfying the condition, and the SUM functions to count the number of times this value is equal to 'specific activity'.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.