Skip to main content

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?

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.chatu14​  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.

Terms & ConditionsCookie settingsAccessibility statement