PQL question;
I am trying to create a query that counts activities after a specific activity is captured.
Page 1 / 1
If you want to aggregate the count to each case, you can try this:
PU_COUNT (
"_CEL_CASES" ,
"_CEL_ACTIVITIES"."ACTIVITY_EN" ,
"_CEL_ACTIVITIES"."EVENTTIME"
>
PU_FIRST (
"_CEL_CASES" ,
"_CEL_ACTIVITIES"."EVENTTIME" ,
"_CEL_ACTIVITIES"."ACTIVITY_EN" = 'Specific Activity'
)
)
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.