Skip to main content
Question

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

  • Aug 31, 2022 9:00 AM UTC
  • 1 reply
  • 84 views

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

1 reply

irfan.suria12
Member Spotlight
Forum|alt.badge.img+5
  • Member Spotlight
  • Aug 31, 2022 12:20 PM UTC

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'

)

)