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.

  • 653 Topics
  • 1,648 Replies
651 Topics
NHARNIS
Level 2
NHARNISLevel 2
asked in Process Analysis
Calculate and Count First and Last Activities

Hello everyone,I'm working with classic process data: Case ID, Activities, and Timestamps.I want to list all first activities and all last activities, and count them by case. This way, I can see which activities my variants start and end with, and how many variants they cover.Ideally, I’d like this in two tables—so I can select a starting activity and see the corresponding ending activities in the other table.I’m assuming it’s fairly easy but i can not manage to do this..Kind regards, Niklas

10
NHARNIS
Level 2
julia.betzl
Level 2
julia.betzlLevel 2
asked in Process Analysis
Change Year in Fiscal Year in a KPI

Hello all,I used this formular to get the average time of late payment:AVG((DAYS_BETWEEN(PU_FIRST("BSEG", "_CEL_AR_ACTIVITIES"."EVENTTIME","_CEL_AR_ACTIVITIES"."ACTIVITY_EN" = 'Due Date passed'),"BSEG"."TS_AUGDT")) - <%= buffer1 %> ) This works well but when I filter on Fiscal Year the KPI is wrong because our Fiscal Year is not similar to Calendar Year. Our Fiscal Year starts always in october. How can I change my formular that the KPI is calculated for example from october 2024 til september 2025 when I selected 2025 as Fiscal Year. Thanks and best regards.

255
J
Celonaut
fabian.altendorfer
Level 3
fabian.altendorferLevel 3
asked in Process Analysis
Adjustments Process Explorer

Hi,Is it possible to adjust the settings of a Process Explorer on how it opens inside a view, like the zoom level or which Events are shown?Right now, there are too many events displayed in the Process Explorer, and my users need to zoom manually to see the names of the activities and their KPI values. I would like to change the initial zoom settings to a higher value or to show only the activities that don't display 0 in their primary KPI, if that's possible.Many thanks for any help, Fabian

92
fabian.altendorfer
Level 3
christine.gentr
Level 2
christine.gentrLevel 2
asked in Process Analysis
Need Help Fixing PQL script to look for a variable direct after a wildcard search using the LIKE function

Hi,I need help fixing my PQL scriptCASE  WHEN "SHOPPING_DETAILS_DESC" LIKE '%CRIT% 1%' THEN 'Criteria 1'  WHEN "SHOPPING_DETAILS_DESC" LIKE '%CRIT% 3%' THEN 'Criteria 3'  WHEN "SHOPPING_DETAILS_DESC" LIKE '%CRIT% 5%' THEN 'Criteria 5'  ELSE NULLEND I am trying task search in a text field (Shopping_Details_Desc) for cases where ‘%CRIT%’ is identified. I would then like the code to assign a Criteria when the number ‘1’, ‘3’ or ‘5’ follow directly after the we wildcard search. I am pulling errors because there are other numbers in the text description and the code is incorrectly assigning them because it is find any any ‘1’ (as an example) that comes after ‘CRIT’ and then calling it a ‘Criteria 1’, even when it is a Criteria 3.  My issue is that sometimes our operators are miss writing the text so we are trying to capture either CRIT or CRITERIA, or anything in between - which is why I want a wild card.  I was able to write a statement in DAX to be able to look for a number assigned direc

102
christine.gentr
Level 2
Mst11
Level 3
Mst11Level 3
asked in Process Analysis
How to Recreate Button Dropdowns in New Views

Hello everyone,I understand that the button dropdown is still not available in the new Views. Has anyone managed to recreate a similar functionality? For example in the analysis I have two button dropdowns and for each one of them I have manually inputted 5-6 categories (Local Supplier, Company Code, MSGK, PO number etc.). Each category is updating two variables (one is for the name of the column and other is PQL calculation in OLAP table). Categories from button one are updating variables in column A while the categories in button two are updating variables in column D. I need to achieve something similar in the new Views, but the documentation for the Input Dropdown isn’t entirely clear to me. Has anyone implemented this successfully? If so, how did you manage it?Thanks in advance for your help!

141
Mst11
Level 3
Mst11
Level 3
Mst11Level 3
asked in Process Analysis
Comments/Augmented attributes

Hello everyone,I would like to create option for users where they can leave comments. I would like for this option to be connected to a chart (let say it’s a chart showing number of blocked documents per month) and I would like to allow users to leave comments for February (number of blocked documents was really high compered to other months). But the issue is that for comments and augmented attribute identifier needs to be unique and I cannot configure it. So if someone has some idea I would be grateful.  Also in documentation they configured comments with variables but when i put variable for DOC ID (VIM_1HEAD.DOCID) and use that variable as identifier it’s not working. Any idea what should be put there? Thank you!

80
Mst11
Level 3
Aide_Yunuen
Level 2
Aide_YunuenLevel 2
posted in Process Analysis
TABLE VIEW IT ONLY BRINGS ME THE HEADERS

I DID THE WHOLE PROCESS IN MY DATA POOL, FROM UPLOADING A FLAT FILE TO THE DATAMODEL WHERE I HAVE NO ERRORS, HOWEVER IN THE VIEWS WHEN CREATING A TABLE VIEW IT ONLY BRINGS ME THE HEADERS

272
Aide_Yunuen
Level 2
raman.silot11
Level 3
raman.silot11Level 3
asked in Process Analysis
Multiple attribute selection in new views

Hi Guys, what’s up ? I wanted to ask if there is any way we can selection multiple attributes in new views and update variable based on it. Currently, the ‘multiple’ option is disabled for attribute selection. I tried with free text but it just adds additional single quotes in beginning and end of the string, so those single quotes should be removed to consider it as table and fields. for ex. “table”.”field” is considered as ‘“table”.”field”’.  

261
raman.silot11
Level 3
JOSE ANTONIO
Level 2
JOSE ANTONIOLevel 2
asked in Process Analysis
Análisis de información o datos para obtener INTELIGENCIA MILITAR

Buenos días necesito saber si es posible utilizar CELONIS para realizar análisis de dato o información para obtener INTELIGENCIA en el ámbito militar, lo que me permitirá mejorar el proceso de toma de decisiones 

100
JOSE ANTONIO
Level 2
leonardo.spina
Level 3
leonardo.spinaLevel 3
asked in Process Analysis
Configure Case Explorer - Case-centric

Hi all, In the case explorer, in YAML or Views, how can I change the Throughput Time and use my own formula in PQL?Thanks for helping.Br,Leonardo

182
leonardo.spina
Level 3
denise.kruge12
Level 4
denise.kruge12Level 4
asked in Process Analysis
Comparing timestamps of 2 cases

Good morning all, I need assistance with PQL to compare the timestamp of a certain activity of case A with the timestamp of another activity of case B, has anyone done this before?

312
denise.kruge12
Level 4
Damian
Level 2
DamianLevel 2
asked in Process Analysis
Filtering Cases by specific activity

Hello,My goal is to create a filter which, after clicking, will only show cases which contain specific activity in them. In my case I want to include all cases which do contain activity with string ‘reject’ in the name of activity.I’m trying to create a filter with this expression:  FILTER MATCH_PROCESS_REGEX ( "_CEL_MERGED_ACTIVITIES"."ACTIVITY", 'X' >> LIKE '%reject%' ) = 1;             Although it does not seem to be working.How can I create and apply a filter to show only all cases which do have such activity?

374
Damian
Level 2
Sony Shrestha
Level 3
Sony ShresthaLevel 3
asked in Process Analysis
PQL query (KPI)to get count of all objects where resource of Create Invoice matches with Resource of Approve Invoice

I have event log as leading_object_id activity_name resource1 Create Invoice A1 Approve Invoice Z2 Create Invoice A2 Create Invoice B2 Approve Invoice BI want to write PQL query (KPI) such that I get count of all objects where resource of Create Invoice matches with Resource of Approve Invoice. How can I achieve this?

181
Rami Agha Kassab
Level 3
Ushmita Patil
Level 2
Ushmita PatilLevel 2
asked in Process Analysis
Not Getting Data in Charts or Case Explorer – Shows "You don't have data yet"

I'm facing an issue where my charts and tables show the message "You don't have data yet" even though I have connected them to the data model.When I create a Case Explorer, it only shows 1 row with these columns: Case ID Number of Activities Duration In the table section of the Case Explorer, it only displays CDHDR.CASES.Can someone please help me understand why I’m not getting any data in the charts or other tables I create?Thanks in advance!

151
Rami Agha Kassab
Level 3
Hafsa
Level 2
HafsaLevel 2
asked in Process Analysis
Process analysis

Hello,To better analyze the Service Now process (a very complex process with many parallel tasks and loops...) in Celonis, is it preferable to use the pm_project and pm_project_task tables or the sys_audit tables?Thank you,

371
mariia.meles
Level 2
Clearner
Level 2
ClearnerLevel 2
asked in Process Analysis
Invalid PQL query. TRANSIT_COLUMN: No join path between the case tables

I am using the free version and custom functionality.Have two event logs and trying to create two flows with transition using the process explorer.Data model, KM, Data Explorer everything is working.  In the KM link between logs is enabled. In Views - Process explorer , it shows two flows. but the transition is not showing so trying to enable the configure transition in the Transition toggle and getting the error as Invalid PQL query. TRANSIT_COLUMN: No join path between the case tables1.What should be data structure.?2.Do we need same event in both logs?3.How does multievent log works with Transition enabled in backend.   

231
Clearner
Level 2
manuel.wetze
Level 5
manuel.wetzeLevel 5
posted in Process Analysis
Best practices to share Insights found in a Dashboard

Hi Community I need your inspiration for a big challenge of mine: Share an Insight made on a dashboard to colleagues with the least amount of effort. a bit of context:I have an Analytical Dashboard, it is not ment for Management and its not Operational. Its purpose is for Process managers to analyze the visuals and find inefficiencies. Now quite naturally if the enduser found something they want to communicate this finding (current Values+ be able to document which filters allowed to come to this finding). Receivers of those findings could be:other Users of the same Celonis Dashboard or persons which do not have Celonis access and also should not have it.Ideally I would like to have a Button or Action within a table called “Share Insight” which automates the  process for the enduser as much as possible. My initial thoughts around this:“Export PDF” is nice to share with non-celonis users. “Share Link to this view” (with Filters) is great to share with those who have viewing rights on th

130
manuel.wetze
Level 5
leonardo.spina
Level 3
leonardo.spinaLevel 3
asked in Process Analysis
How to use PQL Conformance query?

Hi Celonis team, If I have Activities ‘A’, ‘’B, ‘C’ , how do I confiugre the petri model inside the Conformance query found in CONFORMANCE?If Synax is as per below, whee do I add A B C, provided A is starting activity and C ending activity?NB: I don’t have a BPMN model. CONFORMANCE ( activity_table.string_column, [ places ], [ transitions ], [ edges ], [ mapping ], [ start_places ], [ end_places ] ) I’ve tried the below without success, based on the examples from the website:  CONFORMANCE ( "ACTIVITY_TABLE"."ACTIVITY",[],[],[],[['A' 'B'] ['B' 'C'] ], [], ['A'] , ['C' ] ) andCONFORMANCE ( "ACTIVITY_TABLE"."ACTIVITY",[],[],["T_01" "T_02" ],[['A' 'B'] ['B' 'C'] ], [['A' "T_02" ] ['C' "T_02" ]], ['A'] , ['C' ] ) Thank you again for your help! Leonardo

150
leonardo.spina
Level 3
yuyao.wang13
Level 3
yuyao.wang13Level 3
asked in Process Analysis
Conformance Checker in View

Hi,We previously built the conformance checker in Analysis, but after migrating to View, I couldn’t find the feature. Does this mean that the conformance checker is not available in View?Looking forward to your clarification.

714
leonardo.spina
Level 3
kailash.potha12
Level 5
kailash.potha12Level 5
asked in Process Analysis
Do we have an option to select a KPI in text box in new views ?

Is it possible to use a KPI in a text box like in Legacy Views? I currently use this to display the last data refresh date of the use case in Legacy Views, but this option isn't available in New Views. Has anyone tried using any other component ?

252
kailash.potha12
Level 5
MrAj
Level 3
MrAjLevel 3
asked in Process Analysis
Failed to auto save the View. Please save your changes manually

I'm encountering a persistent error in the View: "Failed to auto save the View. Please save your changes manually." Even when I attempt to save the changes manually, the View does not get saved, and none of the modifications to the UI are being retained. Is anyone getting the same issue? what could be the possible resolution?

402
MrAj
Level 3
HsJaSe
Level 2
HsJaSeLevel 2
asked in Process Analysis
Rework analysis

Hello,I am just starting with Celonis and I have the following question: I would like to find out which activities are repeated the most (rework). What could a corresponding PQL function look like? I have already looked at Calc_Rework and Index_Activity_Type, but both do not provide me with the right function because I would like to look at the rework number of activities across all cases (across all sales orders together) in order to make a statement about which activities cause the most rework in the company under consideration.Thank you very much in advance!

210
HsJaSe
Level 2
jacob.fehli11
Level 2
jacob.fehli11Level 2
posted in Process Analysis
Experiences with Process Adherence Manager

Hi everyone,the company I work at is interested in using the Process Adherence Manager (PAM). We already started setting it up for a first use case. While doing so, we encountered some questions. We would be very happy if some of you could share your experiences with PAM, particularly regarding (but not only limited to) the following questions:How do you handle numerous deviations that might be acceptable in some cases but not in others? Is it better to filter on each variant based on known attributes and break it down by creating multiple PAM instances? Or can it be a solution to create a lot of “allowed deviations”? Is PAM more suitable for complex processes including multiple objects or is it more effective to look at little sub-processes individually? The idea behind this question is that when a large process with deviating variants, the conformance rate tends to be low. Do you have experience if there are any types of processes where PAM is strong at and if there are processes whe

250
jacob.fehli11
Level 2
gauri.pai11
Level 3
gauri.pai11Level 3
asked in Process Analysis
Table missing in new version of views

Hi team,I am working on creating a dashboard out of a table created by TASK(cel Task).I am able to find the table in legacy view but not in new view.Please find attached screenshot of legacy view and new view. Legacy view: New view:Can you please help me in this? Thanks and Regards,Gauri Pai

170
gauri.pai11
Level 3
leonardo.spina
Level 3
leonardo.spinaLevel 3
asked in Process Analysis
Daily Average of IDs, daily period is dynamic (depends on Graph)

Hi all,I have a set of IDs/Case Keys that is spread accross 2023-2025. Focusing on 2024, I would like to calculate the daily average based on the Last activity dates.These IDs are divided in products, so when I create an OLAP table in Studio Views, then it takes the IDs per product, for large samples it’s closer to a correct daily average. On the other hand, when the product has 1 or 2 case IDs, then the Daily average is far from correct.Instinctively, I believe I should create a DOMAIN_TABLE but it doesn’t work. I tried using GLOBAL but it is not accepted.Hereby the code i’m using:Originaly:KPI("number_of_cases")/(  MAX (REMAP_TIMESTAMPS (PU_LAST("PROD_CASE_TABLE_DR", "PROD_ACTIVITY_TABLE_DR"."EVENTTIME"), DAYS, WEEKDAY_CALENDAR ( MONDAY TUESDAY WEDNESDAY THURSDAY FRIDAY ) ))-MIN (REMAP_TIMESTAMPS (PU_LAST("PROD_CASE_TABLE_DR", "PROD_ACTIVITY_TABLE_DR"."EVENTTIME"), DAYS, WEEKDAY_CALENDAR ( MONDAY TUESDAY WEDNESDAY THURSDAY FRIDAY ) ))+1) orKPI("number_of_cases")/(DATEDIFF ( dd, PU_LA

231
leonardo.spina
Level 3

Badge Winners

  • Qualified to Manage Implementation Projects
    jauhar.khalihas earned the badge Qualified to Manage Implementation Projects
  • Qualified to Manage Implementation Projects
    julia.portehas earned the badge Qualified to Manage Implementation Projects
  • Qualified to Deliver Business Value with Celonis
    manali.malpahas earned the badge Qualified to Deliver Business Value with Celonis
  • Celonis Certified Data Analyst
    ihtishaam.khanhas earned the badge Celonis Certified Data Analyst
  • Qualified to Build Action Flows
    ihtishaam.khanhas earned the badge Qualified to Build Action Flows
VIEW ALL
Community Code of Conduct