PQL question;I am trying to create a query that counts activities after a specific activity is captured.

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'

)

)