Skip to main content

Hello everyone,

I'm working with classic process data: Case ID, Activities, and Timestamps.
I want to list all first activities and all last activities, and count them by case. This way, I can see which activities my variants start and end with, and how many variants they cover.

Ideally, I’d like this in two tables—so I can select a starting activity and see the corresponding ending activities in the other table.

I’m assuming it’s fairly easy but i can not manage to do this..

Kind regards, 
Niklas

Hi Niklas,

To  analyse process variants by their start and end points in Studio, you'll need to configure two separate table components, each leveraging specific PQL functions. For the first table, intended to display "Starting Activities," you would set its Dimension to PU_FIRST(“Activities”.”Activity Name”)and its KPI to COUNT (DISTINCT “_CASE_KEY”)Similarly, for the second table, focusing on "Ending Activities," its Dimension would be PU_LAST(“Activities”.Activity Name”) with the same COUNT (DISTINCT “_CASE_KEY”) as its KPI. Let me know if it helps, thank you!

hello navya,
Thank you for the response!
Don’t  i need two differt tables for the PU Functions?
I tried using PU_FIRST("A_VLCHIST_NL"."ACTION"), but it gives me an error. 
What am i doing wrong here? 

Kind regards, Niklas 

I also tried this:

PU_FIRST (DOMAIN_TABLE ("A_VLCHIST_NL"."ACTION","A_VLCHIST_NL"."VEHICLE GUID","A_VLCHIST_NL"."TIME STAMP"), "A_VLCHIST_NL"."ACTION" , ORDER BY "A_VLCHIST_NL"."TIME STAMP" ASC ). with actions as events, guid as cases, and timestamp..

Still i get the wrong data..

Reply


Community Code of Conduct