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.

image

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,
Max