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
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.

40
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!  

240
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!

74
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

50
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

110
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!

100
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?

00
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"))

10
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>

00
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: 

110
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?

30
R
Level 1
gauri.pai11
Level 2
gauri.pai11Level 2
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.

110
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!

10
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.

30
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​ 

60
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 ?

40
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​ 

00
A
Level 2
J
Level 3
joão.francLevel 3
asked in Process Analysis
See Apps from a user's prespective?

Hi, As an admin can i see celonis from a user's prespective?As if i had their permissions? Best,João

00
axel.bühle12
Level 3
A
Level 2
alejandra.galla11Level 2
asked in Process Analysis
Are Augmented Attributes for Date data types no longer a thing? How can I recreate a date-based augmented attribute that is used in an action flow?

@Sophia Stephenson​ @Brian Dees​ 

80
P
Level 1
W
Level 2
weijing.shiLevel 2
asked in Process Analysis
Variant Explorer

i find variant explorer very helpful when start to mine a new process. But it seems to be only available in the old analysis component. i wonder why it is not included in the Views ? what is the alternative function in the future roadmap?

50
W
Level 2
vamshi.vigne
Level 3
vamshi.vigneLevel 3
asked in Process Analysis
How to create a dynamic variable in the new views

We need to create a dynamic variable in the views as we used to create it in the analysis to hold multiple dimension values (as an example). Since the way of building views has been changed, any idea on how to build this dynamic variable in the new views? Note I tried the "Input Dropdown" component in the new views but the manual entries does not allow multiple variables option. Instead we can only input text values. 

210
P
Level 1
R
Level 4
raman.silot14Level 4
asked in Process Analysis
FAILED TO CHANGE DATA MODEL

Hello, I have installed an application from marketplace and got this error while assigning data model to the knowledge model. Please let me know what could be the issue.   Thanks

260
dennis.pflug
Level 6
R
Level 4
raman.silot14Level 4
asked in Process Analysis
Trigger generating multiple emails

Hi, I have recently created a trigger with filter to compare a date field with today. The issue is that this trigger is considering all the rows where this date field is being updated and sending multiple emails (over 100) I just want one email when my model loads. Is there any way to somehow restrict the action flow to only one execution ? 

60
R
Level 4
J
Level 1
jm.fLevel 1
posted in Process Analysis
Is there a possibility to hide KPIs in a line chart.

Is there a possibility to hide KPIs in a line chart. I have a line chart with several KPIs mapped to a time dimension. Now I only want to see only a few KPIs at once, otherwise there is no clarity in the chart. The OLAP table allows to hide KPIs via the eye symbol, in contrast this isnt available for line charts (or any other chart) Please let me know if and how this is possible. Thank you in advance!

01
D
Level 4
koert.kritz11
Level 3
koert.kritz11Level 3
asked in Process Analysis
Hi all, I want to create a dropdown in views of the hours in a day, but my dropdown shows multiple values for each dropdown.

Here is the code: ROUND_HOUR( "ITT_PRODUCTIVITY_F_SEP_UAT"."EVENTTIME" )

60
dennis.pflug
Level 6

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