Skip to main content

Process Analysis

In the Process Analysis topic, you can ask questions and start discussions about systematically examining workflows to identify inefficiencies, capture value opportunities, and get recommendations for improvements using Process Mining and AI.

  • 563 Topics
  • 1,521 Replies
561 Topics
.
Level 3
.14600843Level 3
asked in Process Analysis
Time difference between multiple occurrences of activities

In my activities table, I have cases like create incident A B C B A B Now I want to calculate the time difference between create incident and every occurrence of B. Example: (create incident and B (first occurrence), create incident and B(second occurrence), create incident and B(third occurrence)). After that, I want to calculate the overall average of these time intervals.

30
A
Level 3
D
Level 3
daniel.riesLevel 3
asked in Process Analysis
How should the interaction between the new Studio and the Knowledge Model look like?

When I save PQL formulas in the new Studio, they are not assigned to a record as an attribute in the Knowledge Model, but each time as a KPI.  Again, custom records and attributes are not displayed for selection in the new Studio. 

110
D
Level 3
koert.kritz11
Level 3
koert.kritz11Level 3
asked in Process Analysis
Hi all, is it possible to make a dimension in a OLAP table static. So when I click on another dimension it does not affect the value?

Hi all, is it possible to make a dimension in a OLAP table static. So when I click on another dimension it does not affect the value?

20
koert.kritz11
Level 3
L
Level 2
lukas.muellLevel 2
asked in Process Analysis
Rework Selection as column chart component in Daslhboard

Hello everyone, I'm still quite new to Process Mining and PQL.  How can I create the Column chart of the "Rework Selection" as a standalone component for the dashboard? In my process, there is a process flow (loop) that can occur either 0, 1, 2, 3, 4, or 5 times per case. Therefore, on the X-axis, the number of loops should be listed (0, 1, 2, 3, 4, 5), and on the Y-axis, the frequency of occurrence of each number of loops should be shown.  I tried it with this: https://docs.celonis.com/en/calculations-on-activity-sequences.html   And that works well for an OLAP table, but it only provides me with the count of loops per case and not the count of cases for each loop count (0,1,2,3,4,5). However, I cannot or do not know how to access this OLAP table in another component and sum up the counts per loop iteration. Thanks for your help! 😊

30
dennis.pflug
Level 6
koert.kritz11
Level 3
koert.kritz11Level 3
asked in Process Analysis
Hi all,I have a drop down list in my analysis with multiple values, but I want one value to always be selected and you must not be able to deselect that specific value. How do I do this?

Hi all, I have a drop down list in my analysis with multiple values, but I want one value to always be selected and you must not be able to deselect that specific value. How do I do this?

40
koert.kritz11
Level 3
koert.kritz11
Level 3
koert.kritz11Level 3
asked in Process Analysis
I want to add a component filter to my chart in studio analysis that Filters it to only show values between 08:00 and 16:30. How do I do this?

I want to add a component filter to my chart in studio analysis that Filters it to only show values between 08:00 and 16:30. How do I do this?

50
koert.kritz11
Level 3
M
Level 3
maciej.kupcz12Level 3
posted in Process Analysis
Hi All!

Hi All! I'm wondering if this is possible in Celonis to build custom attribute (not based on any table) through which I can iterate and calculate pu functions? I want to create record which can be used for reporting purposes (extracted using PowerBI connector).In this record I want to see KPIs per month. For KPI calculations I'm taking into consideration multiple factors including dates (entry date, clearing date, etc.), so I can't build this column only base on one date field. I was thinking about creating attribute, which will contains specific range of dates (not based on any SAP table) and then, base on it, iterate by all those dates in range and set up pu functions using those dates as variable. I was trying using RANGE, but I was getting error that there is no common tables between range and for example BSEG (from which I'm taking date to compare to result of RANGE function): Time dimension in record: var_date One of the filters in PU function: "BSEG".&q

62
M
Level 3
R
Level 2
rafikahamed.moham12Level 2
asked in Process Analysis
Dear Community

Can we Add Color in Process Explorer(Views) for Particular Activities as needed?

00
R
Level 1
R
Level 2
rafikahamed.moham12Level 2
asked in Process Analysis
Dear Community

Can we Change the FONT Size or Style of KPI Names and Table or CHART Title Names in Views?

10
deeksha.r12
Level 3
koert.kritz11
Level 3
koert.kritz11Level 3
posted in Process Analysis
Hi all,

Hi all, Is there a way to get saved Formulas from analysis into Knowledge model without recreating them manually?

03
matt.witty13
Level 5
andrea.quint
Level 2
andrea.quintLevel 2
asked in Process Analysis
How can I create a matrix type visualization in a view?

Hi Celopeers team, I have a requirement where the user needs see the data as a matrix (like a image) Basically the user needs to see the trend of various KPIs for specific dimension over time. the request is in a View someone knows, how can I do it? Thanks 😉

30
andrea.quint
Level 2
magdalena.silak11
Level 3
magdalena.silak11Level 3
posted in Process Analysis
Hi all!

Hi all! I am trying to track the information how many notifications are sent weekly by my Action Flow. Do you know the best way to do so? Can I add some module in the action flow that would be able to add a line whenever we have new notification to some table that I could then use in the KPI of the analysis? BR!Magda

02
magdalena.silak11
Level 3
andrea.quint
Level 2
andrea.quintLevel 2
asked in Process Analysis
Can I read data in the comments I have on a profile view?

Hi Celopeers Team, I have a profile view with a comment component, I need to creat an Action Flow that sent to the user especific data more de comments that there are. Does anyone know how I can read the data in the comments of an action flow? Thanks 😉

00
andrea.quint
Level 2
R
Level 3
rafal.augusLevel 3
asked in Process Analysis
How to filter records, where we want to get only those with no value? Problem both for Celonis tables and Celonis Action Flows.

Hello! Among my data I have records with four possible values in the column Class ('Inactive', 'Proc Manage', 'non-Proc Manage' and '-'). The last option occurs when there is no value for the record inside Class column.  Although without filtering I can see records with all values of Class listed above, trying to filter as in the picture, I can't get them (I receive only Inactive ones, my goal is to get empty ones also). If I want to get for example only those where Class = 'Inactive', it's easy, but what about the requirement to filter only records with no value for Class column? I don't know how to do it in a table, and inside Action Flows filtering as well. My intuitive code inside Action Flow is FILTER "MyTable"."CLASS" IS NULL , but unfortunately, there is no result. Do you have any idea how to solve this issue? I will be grateful for your support.

60
bunyod.sap
Level 4
A
Level 3
ayushi.ade12Level 3
asked in Process Analysis
Hi All,Can we add display rules to other column on the basis of one column?I have a requirement wherein I need to show background color to entire row.

Hi All, Can we add display rules to other column on the basis of one column? I have a requirement wherein I need to show background color to entire row.

20
B
Level 1
B
Level 2
boobathi.subraLevel 2
asked in Process Analysis
Passing parameter value from one sheet to another sheet

Let say i have predefined columns in sheet2 which has employee details ,So i willl send the employee id from sheet 1 to sheet2 and show employee info based on employee id. How can i achieve it. Please help on this. Note : Dynamically passing employee id

20
D
Level 4
richa.patel
Level 2
richa.patelLevel 2
asked in Process Analysis
How to find if any specific analysis is using incremental data?

How to find if any specific analysis is using incremental data?

30
dennis.pflug
Level 6
C
Level 2
c.mLevel 2
asked in Process Analysis
How to sync two OLAP Tables with variables- one table showing a list of payers in one column with costs in the 2nd colmun. The 2nd OLAP table should show the sum of the first OLAP table.

Payer: Combined Number and Name Logic- One Payer Name can have several Payer Numbers, so Table A always shows a list of Payer Numbers/Name Combinations. Table B should show only the SUM of the Costs of the Payer name. The Customer would like to have in Table A Number and Name combined in one column, Table B should always show the SUm of the above selection.  Table A: Variable: Payer Number/Name Combined Column A, Costs Colmun BTable B: Payer Name Column A, SUM Costs Column B I think the solution could be working with variables: I added two variables: Drilldown_dimensions and drilldown_text so if I select a payer both tables respond.  In Data Transformations I combined three different payer colmuns and also three different payer number colmuns to one column. So it is not possible to select only the payer_name for the selection.

10
B
Level 1
V
Level 4
vasco.caron11Level 4
asked in Process Analysis
Is there a way to reference Knowledge Model Variables in Studio Dashboards?

Good afternoon, Just wondering if there was a way where I could use the variables we've set up in the Knowledge Model, inside the dashboards, for page filters, etc. Thank you!

00
J
Level 2
A
Level 3
anil.vishLevel 3
asked in Process Analysis
How to create a Change Assignee feature in the App?

I have created a table within the Studio App. The table is loaded with Tasks(Created through skills) auto-assigned to Business users in Celonis. Now we would like to have a feature to select a record and click on the change assignee button, on this click we need to be presented with a list of users to whom we can reassign the record. We built an action flow to update the email but we are only able to build a text box to input email addresses, we would like to be presented with a list of users(emails) to whom the task can be reassigned. Please let us know how we can accomplish this.

00
B
Level 1
S
Level 3
sam.weyel11Level 3
asked in Process Analysis
Is there a way to Export a Knowledge Model into a consumable and editable document?

Is there a way to Export a Knowledge Model into a consumable and editable document?

40
floris.kwaks
Level 2
S
Level 2
sanchit.khann11Level 2
posted in Process Analysis
I have to implement a functionality where:

I have to implement a functionality where:There is a table for my vendors with multiple line items, each line item has a Rating field which can be blank or some value.SO when I click on the Vendor code, an overlay view opens.Now on this view there is a button, clicking on which I need to perform different actions:If there is a rating for that vendor, then trigger an action flow. I have created the action flow but not the conditionIf there is no rating for that vendor, then open a message pop displaying a Text. What I need help with is, how do I put a condition on the button to check if the rating exists or not and then open the message pop up.Bros ​@Abhishek Chaturvedi​  @Dipro Banerjee​ Help! :)

23
abhishek.chatu14
Level 7
J
Level 2
joão.macieLevel 2
asked in Process Analysis
Time between two activities based on activity attribute

Hi, I need to calculate the time between two activities that are not directly followed by each other taking an event attribute into account. Example: Calculate time between A and B where: Both activities A and B happen more than once in the processTo get the correct throughput time, we need to consider an activity attribute (e.g., campaign_id). In our case, if activity A happens three times, it will have three distinct campaign ids, so we need to match those ids with the ones in activity B. How can I implement that in Celonis? I tried using SOURCE() and TARGET() from the example in this post , but it seems it only works for directly followed by activities, so there was no data for my chart, as A is never directly followed by B in this case. Thanks a lot in advance!

50
S
Level 2
J
Level 4
joyce.cardo12Level 4
asked in Process Analysis
Hi mates! I am trying to load a data model, but I am getting thi error :The export failed: Data Type Time is not supported. I know tha data type time is not supported, but how I can replace it to ony have the time populating?Thks!

20
D
Level 4
C
Level 2
cybel.itaniLevel 2
asked in Process Analysis
Hello, I am a temporary user but when I try to ingest the activity dataset into the data model, I get this issue: The export failed: Table contains more rows than the allowed maximum per table of 10000000 Please reduce the number of rows.

Hello, I am a temporary user but when I try to ingest the activity dataset into the data model, I get this issue: The export failed: Table contains more rows than the allowed maximum per table of 10000000 Please reduce the number of rows.

110
C
Level 2

Badge winners

Show all badges
Terms & Conditions

ANY QUESTION?

Talk to an expert
FAQs
Contact us

MORE CELONIS

Academy arrow_outward
Documentation arrow_outward
Support Center arrow_outward
Partner Portal arrow_outward
Marketplace arrow_outward

CHECK US IN

LinkedIn
YouTube
Instagram
Facebook
Imprint
Disclaimer
Privacy Notice
Cookie Notice
Terms and Conditions
Celonis © 2024