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.
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
Hi
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.