Skip to main content
Question

Process related functions of PQL

  • Apr 4, 2023 6:05 AM UTC
  • 2 replies
  • 54 views

Forum|alt.badge.img+14

How should the number of cases that do not go through a particular activity be coded in the PQL?

2 replies

COUNT(DISTINCT CASE WHEN PROCESS NOT EQUALS activity THEN _CASE_KEY ELSE NULL END)


Forum|alt.badge.img+14
  • Author
  • Level 6
  • Apr 4, 2023 7:49 AM UTC

Thank you for your reply. Successfully added to OLAPTable