how can we write a Pql Statement to count the activities passes through the cases
Page 1 / 1
Hi, I would suggest taking the following academy course for your reference.
https://academy.celonis.com/learn/course/use-pu-functions-in-analyses
https://academy.celonis.com/learn/course/use-pu-functions-in-analyses
In an OLAP table just add the case key from case table in dimension and in the KPI add count_table(activities_table). It should work. Just replace the activities_table with your activity table name.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.