Skip to main content
Question

Hi All, I want to count the number of activity 'A' WHEN the user is 'automatic' and it happens after another occurrence of activity 'A' with user 'manual'. Note that I want to calculate the number of activities and not the cases that this happens.

  • November 27, 2023
  • 1 reply
  • 18 views

kiarash.diba
Level 1
Hi All, I want to count the number of activity 'A' WHEN the user is 'automatic' and it happens after another occurrence of activity 'A' with user 'manual'. Note that I want to calculate the number of activities and not the cases that this happens.

1 reply

Forum|alt.badge.img+5
  • Level 6
  • November 28, 2023

Set the activity table as a Domain Table and use this as the first parameter in your PU function. Something like this:

PU_COUNT ( DOMAIN_TABLE ( "caseTable"."companyCode" ) , "caseTable"."companyCode" )

 

You can find more information here: https://docs.celonis.com/en/domain_table.html