Skip to main content
Question

To get Count of Activities in Process Explorer

  • March 11, 2025
  • 2 replies
  • 35 views

kandi.naidu
Level 7
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.

2 replies

jonas.hess
Level 6
Forum|alt.badge.img
  • Level 6
  • 15 replies
  • March 11, 2025

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 10
Forum|alt.badge.img+14
  • Level 10
  • 204 replies
  • March 13, 2025

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.