Skip to main content

Product Q&A

Ask questions and get answers about Celonis products from experts and peers.

3150 Topics
D
Level 3
dipro.baner12Level 3
asked in General Product Q&A
How to check whether a certain activity has occurred more than once , twice for a single case using PQL??

How to check whether a certain activity has occurred more than once , twice for a single case using PQL ??

70
D
Level 3
D
Level 3
dipro.baner12Level 3
asked in General Product Q&A
I want to get the days in this current month like if the month is june i want all the dates in june . How can I get that??

I want to get the days in this current month like if the month is june i want all the dates in june . How can I get that??

10
D
Level 3
B
Level 3
bhasker.sathyLevel 3
asked in Process Improvement
'If' condition not working in Action Flow

Hi, In the Set Variable module in my Action Flow, the 'If' expression below evaluates to 'A' whereas it should evaluate to 'B'. Where am I going wrong? if(1=2; A; B) Thanks ! Bhasker

50
B
Level 3
M
Level 3
muskan.singh15Level 3
asked in Process Improvement
What is the difference between Skills and Action flow? Can we perform any action in action flow based on the signals we receive from Analysis?

What is the difference between Skills and Action flow? Can we perform any action in action flow based on the signals we receive from Analysis?

10
D
Level 1
M
Level 1
mudit.nandw12Level 1
asked in General Product Q&A
Hello,Could you please let me know how we can get the list of Whitelisted Violations that have been done in Conformance?

Hi Team, Could you please let me know how we can get the list of Whitelisted Violations that have been done in Conformance? Just like we have a function READABLE ( conformance_query ) where we can get the text of Violation, similarly we are looking for some function so that we can identify which one of them are whitelisted and which one is not.

10
B
Celonaut
A
Anonymous
asked in General Product Q&A
More flexible way to develop multiple event logs that share activities?

The current way of developing transformations in Celonis for event logs is to do this per case key. The event log for PO headers has transformations with the po_header_id as case key. The event log for requisitions has it’s own transformations with the requisition header id as case_key and the event log for AP invoices has it’s own transformations with the invoice id as case key. All these three event logs share multiple activities. We would like to make this more flexible and easier to maintain. The main purpose is to have the complex joins only at a single place and to have the definition of the activities also at a single place to avoid having to maintain the different SQL statements in the transformations. The way we are thinking to set it up is to create 1 single activities table and this contains the usual columns like activity name, eventtime and user name, but not the case key any longer. Instead it has multiple columns for the different object id’s that will be populated depen

20
T
Level 1
S
Level 2
swathi.devirLevel 2
asked in General Product Q&A
Is there a role to restrict the user to grant only access to dashboards

We would like to have a separate user group/role in EMS to just grant access to dashboards in EMS. Currently, admin access has full access but we would like to restrict service desk team to only grant access to dashboards and not do any development.

40
G
Level 8
.
Level 3
.146001156Level 3
asked in General Product Q&A
Action flow doesn't sum amounts correctly - how to fix?

Configured the action flow to send an email where it would summarise at the top the total amounts and below it will be the details in a table format. The table format displays everything correctly, however the sum at the top omits when the table has duplicate values and so is incorrect.

40
G
Level 8
W
Level 3
ward.brandLevel 3
asked in General Product Q&A
A dashboard-button to automatically filter for the last 7 days or the last full week.

Hi All, I'd like to add a button to my sheet that allows the user to automatically filter for the last 7 days, and a separate button that allows the user to filter for the last full week. Bookmark selection doesn't seem to work, since the bookmarks are static. Thanks!

10
W
Level 3
G
Level 3
guilherme.luz11Level 3
asked in Process Analysis
How can I add a button where the user clicks and it filters the cases based on the following query??

Hi all, I want to add a button where the user clicks and it filters the cases based on the following conditions. What's the best way of doing it? FILTER PROCESS EQUALS 'IC SB Purchase Order Created'; FILTER PROCESS EQUALS 'IC SB Billing Created'; FILTER PROCESS EQUALS 'IC SB Invoice Receipt'; FILTER DAYS_BETWEEN( PU_LAST( "EKPO", Round_Day("ACTIVITIES"."DATE1"), "ACTIVITIES"."ACTIVITY_EN" = 'IC SB Billing Created' ), PU_FIRST( "EKPO", Round_Day("ACTIVITIES"."EVENTTIME"), "ACTIVITIES"."ACTIVITY_EN" = 'IC SB Invoice Receipt' ) ) > 30; Thank you. Guilherme Luz

100
W
Level 3
R
Level 4
raman.silot14Level 4
asked in Process Analysis
Case Frequency vs activity frequency

Can anyone please give me the explanation about their difference with respect to a business point of view. Like if a client asks why you are showing me case frequency and activity frequency for change price. That what should we say?

10
R
Level 4
V
Level 3
vahide.öztürLevel 3
asked in General Product Q&A
How to implement conformance checker with own process flow

Hello, We have lack of knowladge . We would like to load a process flow like this. Lets assume we have process Flow like that A-> B-> B->C-B->B-> D->B->B->E When we do conformance I would like to use A->ANY To ANY -> C Any to Any ->D Any to Any->E I mean Any activity between A->C could be exits. We tried this solution but unfortunately, it didn't work as expected. All of our cases detact as violation. We implement BPMN as below. What we did worng ? Best Regards, Vahide.

20
V
Level 3
A
Level 3
ashish.jha12Level 3
asked in General Product Q&A
Hi, We are facing issue in importing activity table from GCP to Celonis. Please note that the connection has been established between GCP & EMS & also able to add certain tables in CElonis. But for the activity table , getting below error as att

Pls see the line 2 & 3 of the screenshot.

00
A
Level 3
.
Level 2
.1460138Level 2
asked in Data Ingestion & Infrastructure
How to check any dimension (like Vendor etc) wise Violation Rate?

How to check any dimension (like Vendor etc) wise Violation Rate?

00
L
Level 1
M
Level 1
manohar.surinLevel 1
posted in General Product Q&A
Hi,

Hi, I am Manohar and I would like to change email address associated with the account as my earlier email was blocked when I resigned from the organization. Can someone guide me how to change email address and how to login with fresh email address? Thanks, Manohar

01
.
Level 4
M
Level 1
mohit.mehro11Level 1
asked in Process Analysis
Histogram with Aggregations

Hi, we want to showa histogram which shows days a particular case takes to get resovled(Days Spent), instead of the actual start and end timestamps. So in this sample data set assume we have sveral cases of each type between the start and end timestamps, which would show up as counts in the histogram. How to achieve this. Histogram Query938656 96.3 KB

10
J
Level 2
D
Level 1
durai.paramLevel 1
asked in Data Ingestion & Infrastructure
Accessing PQL

Hi All, I have basic question on PQL. How can I explore PQL for process mining? Do we have any start up guide? Should I need to have full license version to explore PQL ? Thanks Durai

00
.
Level 3
G
Level 2
gregor.schei12Level 2
posted in Data Ingestion & Infrastructure
Hi all,

Hi all, I have a basic question regarding activity table column configuration. We have the luxury of having start AND end datetimes for each activity. I remember this was possible at some point to specify the date columns as such with the effect that for each activity the duration was calculated and shown in the process explorer (performance view). Is this still possible, and if so, how? Thank you!

11
E
Level 4
E
Level 4
eugene.em13Level 4
asked in General Product Q&A
Open invoice aging trend over time in a line chart

Hi celopeers, I am trying to build out a trend chart that plots the open invoice aging over time. In terms of dimensions I have the following: x axis - ROUND_MONTH(INVOICE CREATION DATE) y axis - AVG(TODAY - CREATION DATE) for open invoices only The issue I'm running into is that since KPI is tied to creation date and today's date produces a strictly negatively sloped trend as shown below, which makes sense in practice (beacuse both axes are tied to creation date), but not exactly what I'm looking for. What I need to show is the change in trend by month, but that will require detaching the KPI calculation from the creation date, sort of like a snapshot of the KPI at the end of each month, kind of like transformation center did it before. Has anyone successfully accomplished that before? If so - how did you do that? Thanks! Eugene

120
E
Level 4
.
Level 2
.1460138Level 2
asked in AI
Getting below error while creating RCA using Machine Learning workbenchAttributeError: 'NoneType' object has no attribute 'source_name'Please help us reslove this error

from pycelonis import get_celonis from pycelonis.root_cause_analysis import root_cause_analysis celonis = get_celonis() dm = celonis.datamodels.find('c4cb1efc-fa6a-4704-bc51-b3b365c5e796') kpis = {'late_payment': """ CASE WHEN PU_COUNT(P2P_case, "Activity"."ACTIVITY_EN", "Activity"."ACTIVITY_EN" = 'Clear Invoice')=0 AND DATEDIFF(dd, PU_MAX("P2P_case", ROUND_DAY("Activity"."EVENTTIME"), "Activity"."ACTIVITY_EN" = 'Create Purchase Order Item'), TODAY()) > 0 AND DATEDIFF(dd, PU_MAX("P2P_case", ROUND_DAY("Activity"."EVENTTIME"), "Activity"."ACTIVITY_EN" = 'Create Purchase Order Item'), TODAY()) <= 60 THEN NULL WHEN PU_COUNT(P2P_case, "Activity"."ACTIVITY_EN", "Activity"."ACTIVITY_EN" = 'Clear Invoice')>0 AND DATEDIFF(dd, PU_MAX("P2P_case", ROUND_DAY("Activity"."EVENTTIME"), "Activity"."ACTIVITY_EN" = 'Create Purchase Order Item'), PU_MAX("P2P_case", ROUND_DAY("Activity"."EVENTTIME"), "Activity"."ACTIVITY_EN" = 'Clear Invoice')) > 30 THEN 1 WHEN PU_COUNT(P2P_case, "Activity"."ACTIVITY_EN",

10
G
Level 8
S
Level 2
saskia.plüstLevel 2
asked in Process Analysis
How can you create a dropdown filter in a view to switch between AVG & MEDIAN?

I would like to update a runtime variable with the value selected (either AVG or Median)

90
G
Level 8
.
Level 1
.146103341Level 1
asked in General Product Q&A
I am unable to access the trainings required by my organization. I need urgent help

I am unable to access the trainings required by my organization. I need urgent help

00
G
Level 8
A
Level 2
antti.järviLevel 2
asked in Process Analysis
How to calculate the throughput time also for negative values (activities in different order)?

Is there a way to calculate the throughput time also for negative values (activites in different order) than start -> end in "throughput time search" visualization? Like also having end -> start included in the same visualization, if there are variants that follow different order of activities. The default of "throughput time search" is to only show variants that follow the defined order. My work-around was to create custom datetime columns for the two activities in the case table, and then just use datediff calculation between two columns. But it seems rather clumsy way, and also binning is required to make it look nice.. Thank you for comments

30
A
Level 2
harish.c.j
Level 3
harish.c.jLevel 3
asked in General Product Q&A
Getting KeyError: 'name' in Jupyter Lab ML workbench (highlighted line in details section). The key "name" is not accessed in the code, but still throwing error. Is this a bug in pycelonis? How to overcome this error?

---------------------------------------------------------------------------KeyError Traceback (most recent call last) Input In [1], in <cell line: 13>() 29 for sheet in analysis.published.sheets: 30 # if sheet.pql_filter is not None and re.search(find_pattern, str(sheet.pql_filter), re.IGNORECASE): 31 # print ("Sheet filter of analysis: " + analysis.data["name"] + "; Sheet: " + sheet.data["name"]) 33 for component in sheet.components: 34 # if component.pql_filter is not None and re.search(find_pattern, str(component.pql_filter), re.IGNORECASE): 35 # print ("Component filter of analysis: " + analysis.data["name"] + "; Sheet: " + sheet.data["name"] + "; Component: " + component.name)---> 37 if len(component.pql_columns) > 0: 38 pql_columns = component.pql_columns 39 pql_columns = pql_columns if isinstance(pql_columns, list) else [pql_columns] File ~/.local/lib/python3.8/site-packages/pycelonis/celonis_api/process_analytics/analysis.py:861, in BaseAnalysisComponent.pql_columns(self) 859 p

40
janpeter.van.d
Level 8
.
Level 3
.146105038Level 3
posted in Data Ingestion & Infrastructure
Community Discussion

can you please make a video how to integrate the Uplink Integrations also how to create a data connection

02
joost.herma
Level 4

Badge winners

  • Celonis Certified Data Engineer
    karamdeep.singhhas earned the badge Celonis Certified Data Engineer
  • Qualified to Manage Implementation Projects
    maria.troyahas earned the badge Qualified to Manage Implementation Projects
  • Qualified to Write PQL Queries
    danila.farinhas earned the badge Qualified to Write PQL Queries
  • Qualified to Build Action Flows
    danila.farinhas earned the badge Qualified to Build Action Flows
  • Qualified to Build Analyses
    danila.farinhas earned the badge Qualified to Build Analyses
VIEW ALL
Community Code of Conduct

ANY QUESTION?

Talk to an expert
FAQs
Contact us

MORE CELONIS

Academy arrow_outward
Documentation arrow_outward
Support Portal 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 © 2025