Skip to main content
Question

Create a chart in which we count for every month the number of cases ending with a precise activity

  • July 18, 2024
  • 1 reply
  • 26 views
N
Level 1

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!

    1 reply

    luis.marti11
    Level 1
    Forum|alt.badge.img+3
    • luis.marti11
    • Level 1
    • 1 reply
    • July 19, 2024

    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.


    Community Code of ConductAccessibility statement