Skip to main content

Hi everyone,

 

I would like to create a chart where I show for each month the number of cases that satisfy some conditions in terms of process activities. Specifically, I need to count the number of cases that every month end with activity A. Therefore, if a case at the end of the May and at the end of June ended with activity A and in July it ends instead with activity B, I want to see it in both the column of May and June but not in the column of July.

I tried to combine the TIMELINE_TABLE function with the MATCH_PROCESS function but it only takes into consideration those cases that satisfy the requirement today.

Do you think it is possible to get what I need?

Thank you in advance for your help!

Hello,

 

I think you can use the function PU_LAST(). You can use the filter_expression] argument to check the Activity A and then aggregate accordingly.


Reply