Skip to main content
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, Max
Community Code of ConductAccessibility statement