Skip to main content
Hello together,
I want to use the standard Process Overview App to analyse troughput times and bottle necks.
My process is the accounts payable process (paying bills).
I could categorize my activities in:
  • Data Log activites (performed activities by user or batch_user), f.e.: scan document, post document, forward document
  • Calculated activites, f.e.:reached discount period, reached payment period (based on the document date)

These calculated activities are really important for the process analysis.
However, they can be disturbing when analyzing the throughput time, because these activities dont affect the troughput time (they are just calculated).
Do you know a sheet filter i could apply on the Process Overview App so that these activities are no longer taken into account?
However, the cases themselves should still be included.
Thank you in advance.
Andreas
Hi Andreas,
Welcome to the Celonis Community
I afraid it is not possible to use a sheet filter for this as sheet filter always exclude cases.
Im not sure in which situations these activities being included bother you. But here are a few Ideas I could think of.
If you dont want the want the variant / Process explorer to show these activities, you can use the eye icon to hide them from view.

If you want to exclude them from activity counts, there are two ways to do this.
  1. If you have a farely small number of activities you want to exclude the easiest way to is to use REMAP_VALUES.


COUNT( REMAP_VALUES(activity table.activity column, [activity to exclude 1,NULL], [ activity to exclude 2,NULL], [ activity to exclude 3,NULL], ))

  1. If you have more activities you want to exclude and some of them follow a certain rule (e.g. no activities performed by batch users) you could use a CASE WHEN statement to to this.


COUNT( CASE WHEN activity table.user type != batch user type AND activity table.activity column NOT IN (activity to exclude1,activity to exclude2, activity to exclude3,)

THEN activity table.activity column
ELSE NULL
END)
I know this code is a little complicated, so Ill explain it quickly. COUNT counts the number of non-NULL values so when the condition that the activity has neither a batch user nor is it in the list of band activities, it gets some non-NULL value. Im using the activity name for this, but it doesnt really matter what is used so long as its guaranteed not to have any unexpected missing values. The important part of the code is that, if the condition is fulfilled (i.e. the activity is one you want to exclude) it is a signed the value written after ELSE, which is in this case NULL so its not counted.
I hope this answers your questions. If these suggestions dont cover what you want to achieve then please write back with more details. Its frequently helpful if to use screenshots when explaining your aim.
Best wishes,
Calandra
Hello everyone,
I know the discussion was a while ago, but I have a follow up question regarding a similar issue. I would like to have a separate analysis for a specific topic (for example document changes in Accounts Receivable). In this analysis I would like to have a Variant Explorer to see the most common processes. In this Explorer however I would like to hide specific activities, for example the calculated ones (due date passed, cash discount due date passed, ) and so combine multiple variants. It is not important in this case whether the changes happened before or after the due date, so they should show as one variant.
As described by Calandra above I can achieve this by hiding the activities in the explorer using the eye icon. Question is, if I can achieve this on an Analyst level and save this for the analysis or the component to always hide those activities in the explorers.
Thank you for answers, BR Philipp
I believe I already answered my question:
By activating the custom dimension of the Variant Explorer and changing it to the following statement only the selected activities that are named in the variable are considered for the different variants.
CASE
WHEN "_CEL_AR_ACTIVITIES"."ACTIVITY_EN" IN (
<%=ActivityGroup%>
) THEN "_CEL_AR_ACTIVITIES"."ACTIVITY_EN"
ELSE NULL
END

BR Philipp

Reply