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.

  • 646 Topics
  • 1,635 Replies
644 Topics
A
Level 1
alexis.duwatLevel 1
asked in Process Analysis
How do I get the selection filter in the new studio (views)?

Hello, I'm using the views in the studio for the first time. The old version allowed you to make a selection (see screenshot below). Is it possible to do the same thing in the new version of the studio? Thanks for your help

150
mateusz.dudek14
Level 7
A
Level 2
akash.suhag11Level 2
asked in Process Analysis
I have 2 tables connected with each other. From table1 when I select Current month value in drop down. I want to sum the balance column values from table2 where month value is selected month value - 1.

I have 2 tables connected with each other. From table1 when I select Current month value in drop down. I want to sum the balance column values from table2 where month value is selected month value - 1.

20
mateusz.dudek14
Level 7
T
Level 3
t.m.Level 3
asked in Process Analysis
Dynamic filtering based on a variable in a View

Hello together, I want to build a dynamic filter that can vary depending on when a particular button is clicked. This means I write a variable and update it depending on the button. The filtering also depends on this. Unfortunately, I cannot use the variables created in the view as input for the filter.  Specifically, I have a button called “Process start” and one called “Process end”. Depending on what was clicked, the start of the process in the filtering should not be longer than 12 months ago, or if the end of the process was clicked, it should not be longer than 12 months ago. I'm using this for a diagram. Unfortunately, the dynamic variables cannot be used in filtering.  Does anyone have an idea? I'm really desperate. Thank you very much and kind regards! 

600
abhishek.chatu14
Level 7
lucas.fisch12
Level 2
lucas.fisch12Level 2
asked in Process Analysis
How to update runtime variable from a View?

Hi all, I want to update the value of a runtime variable with a Button input from a View (JAB) in order to use this runtime variable for a KPI with a PQL Statement inside a knowledge model .But I can't find the runtime variable in the 'update variable' selection of the button. Any Ideas how I can dynamically update the runtime variable value from a View?

440
abhishek.chatu14
Level 7
H
Level 3
huseyin.simseLevel 3
posted in Process Analysis
Hi,

Hi,  Even if I published my Studio package with KM, I am receiving an error at Apps: This component has been misconfigured. It can be fixed by people who have access to the Celonis Studio.How can I tackle this issue?

124
H
Level 3
sewhui.sam
Level 2
sewhui.samLevel 2
posted in Process Analysis
Column and Line Chart

Column and Line ChartHi, In View, there is a feature that you can split the line by column in the graph. I tried to create the same feature in the New View using column and line chart component. But having no luck! Any helps would be helpful!

492
sewhui.sam
Level 2
R
Level 4
raman.silot14Level 4
asked in Process Analysis
Input needs to have proper JSON format

Hy,I have connected a skill with action flow using webhooks module and connected a view with that skill.As I wanted that user be able to enter text at runtime, I am getting error if I enter text in next lineThe 'execute action flow' module throwing error as follows

190
andrea.quint
Level 2
sivasakthi.dhand
Level 3
sivasakthi.dhandLevel 3
asked in Process Analysis
Hi, Can anyone please help me on how to cascade filter to popup screen ? ie I am trying to open a popup based on the cell value clicked from view table and I would like to show details in the popup screen for the value clicked in the table.

For example, I have a table listed with below values in one of the columnsComponent-AComponent-BComponent-CComponent-DPopup screen should show details of Component-C when I click it . I couldn't find any relevant material on this.Thanks in advance for your help.

252
sivasakthi.dhand
Level 3
marcin.konop13
Level 3
marcin.konop13Level 3
asked in Process Analysis
"Case-When" categories KPI not aggregating.

Hi Celopeers and Celonis team.  I have quite a conundrum that is bothering me quite a bit and I don't know what else to try. I have a case-when kpi that creates a risk category for customers based on a set of parameters. It works perfectly for customer by customer basis. But when I try to do any aggregations by the categories it always shows just one value. In the below image you can see it in action. In one the KUNNR number is the dimension and the Category as the KPI, in the other, the Late payer is as dimension and COUNT(KUNNR) as a KPI.

60
marcin.konop13
Level 3
T
Level 3
t.m.Level 3
asked in Process Analysis
Multiple Case When Statements and count of occurences of an element in a string

Hello everyone, Unfortunately I have a field that says something like: “A|B” or also “A|B|C” or "B|C". I don't know in advance how many different combinations there are, but I have predefined categories. Now I want to create a diagram in which I want to display the frequency of the individual elements. If I do something like: Casewhen Table1.Column Like '%A%' then 'A'when Table1.Column Like '%B%' then 'B' etc.end Then it aborts after the first occurrence and does not count the other elements. But I would like to have them all counted in each associated “pot”. Several case when statements in a row do not work, even union does not work in PQL as far as I know. With STRING_SPLIT I can cut after the “|”, but I don't know how I can then aggregate the individual occurrences again. I would also be interested to know how I can count the number of occurrences of “|” in a string Does anyone have an idea? Thank you!  

680
T
Level 3
sewhui.sam
Level 2
sewhui.samLevel 2
posted in Process Analysis
Hi, I want to use the button components to view KPI lists in Number / Percentage in the New View.

Hi, I want to use the button components to view KPI lists in Number / Percentage in the New View. For example, clicking button 1 will display KPIs in number and clicking button 2 will display KPIs in percentage. I know I can use enhanced variable but I'm not sure how to link them together. Any helps would be helpful!

334
sewhui.sam
Level 2
axel.bühle12
Level 3
axel.bühle12Level 3
asked in Process Analysis
Parsing of variable containing list of string values not working as expected (filter evaluating this list for an IN statement doesn't work)

Hi, I have been trying to build a filter in the new view based on a variable - but couldn't get it to work. Target filter should look like this (and the explicit example below works): FILTER "DEV_CUSTOMER_HIERARCHY"."KUNNR" in ('9000100043','9000100188','2000000007') The variable contains a list of strings, each string enclosed by single quotes, separated by a comma, see below - as I couldnt make it work I tried different versions in respect to start and end of string (with or without parentheses and single quotes) ('9000100043','9000100188','2000000007')'9000100043','9000100188','2000000007'9000100043','9000100188','2000000007 I didn't get any of these filter expressions working: FILTER "DEV_CUSTOMER_HIERARCHY"."KUNNR" in ${path_from_top}FILTER "DEV_CUSTOMER_HIERARCHY"."KUNNR" in (${path_from_top}) the filter is flagged with a red

80
axel.bühle12
Level 3
A
Level 3
ayushi.ade12Level 3
asked in Process Analysis
Hi All,I am trying to create a overlay view in new studio, created a target view as well. However when I click on the sales order in my main view the target view value is not updating, mapped a variable as well

Hi All, I am trying to create a overlay view in new studio, created a target view as well. However when I click on the sales order in my main view the target view value is not updating, mapped a variable as well

230
A
Level 3
M
Level 3
maciej.kupcz12Level 3
asked in Process Analysis
Augmented Attribute history

Hi All, I'm wondering if there is an option to see history of augmented attribute? Let's take a look on below example: If we are changing status (augmented attribute) to "Urgent", we always want to see this case with priority "High", no matter that we will change this status to "In progress" later on. Priority field should works like IN() formula - we want to check if at least once this status was used so the priority can be assigned properly. In addition to that, can we somehow see the history of those changes in simple table? For example three columns - date | user who set the status | status.And I'm not talking about Activity History which seems to not be very customizable and is showing each field as separate change. Many thanks in advance for your help!

230
mateusz.dudek14
Level 7
axel.bühle12
Level 3
axel.bühle12Level 3
asked in Process Analysis
Populate variable based on another attribute of selected record (e.g. select material no via drop-down, but populate variable with value of material group of selected material, i.e. another attribute of the selected record) - is this possible?

Populate variable based on another attribute of selected record (e.g. select material no via drop-down, but populate variable with value of material group of selected material, i.e. another attribute of the selected record) - is this possible?

20
axel.bühle12
Level 3
V
Level 3
vincent.witteLevel 3
asked in Process Analysis
Extract weekday (Monday, Tuesday etc.) from a timestamp column not working. Always returning Thursday

I have a date/time field, but somehow DAY_OF_WEEK(table.column) with %A as formatting always returns Thursday.To strip the time, I'm using Round_day() which makes 2024-07-03 from a 2024-07-03 21:23:35 timestamp, but returns Thursday, but it should be Wednesday for July 3rd. I can add a extra column from source tables, but prefer an easy PQL formula.PS: I'm using the new view experience. DAY_OF_WEEK ( ROUND_DAY( "eventproperties"."reportdate"))

30
V
Level 3
S
Level 2
sumit.sahu11Level 2
asked in Process Analysis
How to get access to the training environment>

How to get access to the training environment>

30
S
Level 3
florian.mrkvi
Level 4
florian.mrkviLevel 4
asked in Process Analysis
How can I pick custom colors for a pie chart?

I am using the new Studio views and I can't find a way to pick any non-predefined colors. I only see the those options in the screenshot: 

180
Jordan Horengic
Celonaut
L
Level 1
lisa.heinrLevel 1
asked in Process Analysis
How can I limit the number of displayed bars?

Hello everyone, I'm facing issues while creating a view. I have a grouped column chart. Now I want to limit the number of displayed bars to 6, but scrolling to the other bars in the time line should be possible. When I use the data setting "Allow scrolling," scrolling works. However, when I set a limit in the data setting, I can't scroll anymore, and the displayed time period is fixed.I hope you understand what I mean. Does anyone have an idea how this could work?

180
R
Level 1
gauri.pai11
Level 3
gauri.pai11Level 3
asked in Process Analysis
How to navigate to another tab in same view using button click of user?

Hi team,I am searching for a component which on clicking will take me to another tab in same view.It was possible in analysis using button component (open tab feature).Can you please guide me how can i achieve this in view.Thanks beforehand for the help.

340
R
Level 1
N
Level 1
nelly.gonzaLevel 1
asked in Process Analysis
Carry Filters random behaviour

Good day community, We are having issues with the "Carry Filters" option on Analyses. This feature works very randomly: sometimes the option does not appear at all, other times it appears but it doesn't actually carry any filters, and sometimes it works as expected. I am not able to find any documentation on this specific feature, or any option that could allow me to review what is happening. Has anyone experienced something similar? Does anyone have an idea of what could be happening here? Is there a way to configure/review the "carry filters" option to see if modifying it would help it behave as it's supposed to?Any input is appreciated. Thanks in advance!

20
N
Level 1
N
Level 2
niklas.mederLevel 2
asked in Process Analysis
How to subtract the running total from a target quantity? Dimension error.

Hi,  I wanted to implement the open target quantity in celonis. Therefore I used the RUNNING_TOTAL function to add up the quantities as shown in the screenshot. After, I wanted to subtract the RUNNING_TOTAL from the target quantity, the code for this looks like that: "CONTRACT_INFO"."KTMNG" - RUNNING_TOTAL("EKPO"."MENGE") That constantly gives me the following error:  The running aggregation function RUNNING_TOTAL cannot be used together with a dimension function input. Please check that there are no moving aggregations and dimensions used together as function inputs. Even if I try to use e.g. AVG(), SUM(), LAST() in front of "CONTRACT_INFO"."KTMNG" , it's not working. Only if I use RUNNING_TOTAL() in front of "CONTRACT_INFO"."KTMNG" it's working, but obviously this is giving me wrong results. Thanks for your help.

50
milan.eric
Level 3
A
Level 2
alejandra.galla11Level 2
asked in Process Analysis
Knowledge model variables created directly in the Knowledge Model don't appear in the View associated with the Knowledge Model - is that intentional?Similarly, variables created in the View and marked as Knowledge Model don't appear in the KM.

@Sophia Stephenson​ @Brian Dees​ 

100
P
Level 1
R
Level 4
raman.silot14Level 4
asked in Process Analysis
record identifier causing issue

Hi team, I am working on creating a profile view, for which the identifier in record is required. As DISTINCT and usage of two tables is restricted while creating an identifier, I am using PU_FIRST and using same table and column in target and source.  I am able to make records unique, but I am facing problem when I am adding KPIs for this profile view dimension. It looks like it is showing duplicates. Can someone please let me know why this approach is not right and any alternative solution for the same ?

110
R
Level 4
A
Level 2
alejandra.galla11Level 2
asked in Process Analysis
How can we see the last column headers in tables using the new Views? They currently appear blocked by the display preferences icon (see attached). It is important that end users can see all cols by default.

@Sophia Stephenson​ @Brian Dees​ 

10
A
Level 2

Badge Winners

VIEW ALL
Community Code of Conduct