We are trying to create a dashboard with different KPI’s. We have a scenario that we would like to filter in cuirrent status of the order. When we try to use Case ends with then there could be still some activites happening after that status and thus we don’t see the results.
Also, we would like to filter as an OR condition on multiple activities.
FILTER MATCH_ACTIVITIES ( “_CEL_O2C_ACTIVITIES”.“ACTIVITY_EN”, NODE_ANY [ ‘CRM Order: Released’, ‘CRM Order: Open’, ‘CRM Order: In process’ ] ) = 1;
FILTER MATCH_ACTIVITIES ( “_CEL_O2C_ACTIVITIES”.“ACTIVITY_EN”, NODE [ ‘CRM Order Item: Contains Errors’ ] ) = 1;
FILTER “CRMD_ORDERADM_H”.“PROCESS_TYPE” in (‘ZTA’, ‘ZFD’);
In nut shell we want all the orders which are in Open, In process or released and contains error for certain process types.
We are missing on how to apply filter on activities? Can someone help here?