I would like to add a column to the OLAP table that lists the number of processes that go through a particular activity and the number of processes that do not go through a particular activity. How do I code a PQL that calculates the number of processes that go through a particular activity A?
Page 1 / 1
PQL that calculates the number of time an activity is executed that go through a particular activity A is as follows
SUM(CASE WHEN ACTIVITY_TABLE.ACTIVITY = 'ACTIVITY A' THEN 1 ELSE 0 END )
I am not sure what you mean by number of processes
PQL that calculates the number of time an activity is executed that go through a particular activity A is as follows
SUM(CASE WHEN ACTIVITY_TABLE.ACTIVITY = 'ACTIVITY A' THEN 1 ELSE 0 END )
I am not sure what you mean by number of processes
@Abhishek Chaturvedi Thank you for your reply.
>I am not sure what you mean by number of processes
It meant the number of cases going through a particular activity.
In contrast, if I want to calculate the number of cases that do not go through a particular activity, what would be the PQL formula?
Use
PROCESS EQUALS <activity>
PROCESS NOT EQUALS <activity>
in filters or inside a SUM(CASE WHEN ...) structure.
HTH
Use
PROCESS EQUALS <activity>
PROCESS NOT EQUALS <activity>
in filters or inside a SUM(CASE WHEN ...) structure.
HTH
Thank you for your reply. I'll try.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.