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,
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.
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.
Page 1 / 1
Hi newlen,
you can create an OLAP table with the following input:
Dimension:
KPI:
Component Filter:
Best regards,
Max
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,
Max
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.