Dear Community,
For the KPIs in our O2C process we have created some dashboards, but would like to have only order items included that are fully processed, e.g. where the invoice is cleared.
I currently do this by using an activity selection in the filter which is not very practical.
Is it possible to have this as a component or sheet filter and how can I do it?
Thanks for your help and please excuse this beginner question.
Regards,
Michaela
Page 1 / 1
Hello Michaela,
welcome to the Celonis Community!
You can use the
The filter statement (which can be used in Component, Sheet and Analysis filters) looks like this:
You can find Documentation with more examples in the help space of your Celonis version (here for CPM4 or here if youre on IBC).
Best,
David
welcome to the Celonis Community!
You can use the
MATCH_ACTIVITIES PQL function to filter on cases that flow through a certain activity.The filter statement (which can be used in Component, Sheet and Analysis filters) looks like this:
FILTER MATCH_ACTIVITIES ( "<your activity table>"."<your activity column>" , NODE [ 'Clear Invoice' ] ) = 1 ;You can find Documentation with more examples in the help space of your Celonis version (here for CPM4 or here if youre on IBC).
Best,
David
Hello David,
Thank you for your quick reply and help
It works perfectly.
Best regards,
Michaela
Thank you for your quick reply and help
It works perfectly.
Best regards,
Michaela
Great help/insight! I am looking to achieve the same result, inversely; wondering how to apply an analysis/sheet filter to only show Open sales orders. Essentially, how to write the PQL formula to filter OUT cases that flow through a certain activity?
Hi,
for filtering on cases that does not have a certain activity, you can actually use (almost) the same formula. You would check if the function returns 0 instead of 1, this means that the case does not flow through the activity.
for filtering on cases that does not have a certain activity, you can actually use (almost) the same formula. You would check if the function returns 0 instead of 1, this means that the case does not flow through the activity.
FILTER MATCH_ACTIVITIES ( "<your activity table>"."<your activity column>" , NODE [ 'Clear Invoice' ] ) = 0;
Hi,
for filtering on cases that does not have a certain activity, you can actually use (almost) the same formula. You would check if the function returns 0 instead of 1, this means that the case does not flow through the activity.
for filtering on cases that does not have a certain activity, you can actually use (almost) the same formula. You would check if the function returns 0 instead of 1, this means that the case does not flow through the activity.
FILTER MATCH_ACTIVITIES ( "<your activity table>"."<your activity column>" , NODE [ 'Clear Invoice' ] ) = 0;Hi Viana,
Is it possible for you to help with including 2 activities to the above filter and which will work as AND? i.e, the first activity and the 2nd activity both should be considered in the filter.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.