Skip to main content
Question

To get Count of Activities in Process Explorer


kandi.naidu
Level 4
Forum|alt.badge.img+6

Hi Team,

 

I am trying to write a pql query to extract value of activity count between two activities one of them is either process start or process end.

Like I highlighted the value in the screenshot.

 

please let me know, how to achieve it.

 

Regards,

Ajith Naidu.

jonas.hess
Level 3
Forum|alt.badge.img

Hello ajith, 

maybe you could a case when. Give the Condition that the two activities should have eventtime is not null and if the condition is given then count CaseID.

 

Then you should get the number of cases which involves both of your desired activities

 

This is the first solution which comes in my mind. 

 

Kind regards Jonas 


Sverre Klein
Level 6
Forum|alt.badge.img+14

Hi ​@kandi.naidu ,

 

Not sure if I fully understand, but you want to count the amount of times activities have been the process end?

You can achieve this using a table with a PU_LAST as a dimension and as a kpi counting your Case table.

Dimension: PU_LAST("CASE_TABLE", "ACTIVITIES_TABLE"."ACTIVITY_NAME")
KPI: COUNT_TABLE("CASE_TABLE")

This way, your table shows you how many times the last activity in your process flow was the process end.

Let me know I interpreted your question wrong.


Reply