Question
Table showing all activities preceding a specific activity
Hi,
How would I write a filter on a table to show all activities preceding a specific activity, along with the frequency?
Basically, what the process explorer fullscreen analysis shows.
Hi newlen,
you can create an OLAP table with the following input:
Dimension:
SOURCE("_CEL_P2P_ACTIVITIES_EN"."ACTIVITY_EN") (adapt table and column names)
KPI:
COUNT_TABLE("EKPO") (normal Case Count, adapt table name)
Component Filter:
FILTER TARGET("_CEL_P2P_ACTIVITIES_EN"."ACTIVITY_EN") = 'Receive Goods' (adapt table and column names, choose activity that you want to analyze)
Best regards,
MaxLogin to the community
No account yet? Create an account
Login with SSO
Celonaut Login Celonis ID LoginEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.