Skip to main content

Product Q&A

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

4441 Topics
S
Level 3
sarah.kraftLevel 3
asked in Process Analysis
Ignoring the troughput Time of a specific activity

Hello everybody, Im struggeling with the analysis for my thesis of an ITSM process and hope there is a simple solution, which I just overlook. Explanation: A service ticket is considered as solved in RESOLVED status, the status automatically changes to CLOSED status after 10 days, in any way. So, what can I do to deposit in ALL analyses that these 10 days do not flow into the troughput time never? DLZ.jpg848958 62.5 KB Thank you very much in advance

97
S
Level 3
.
Level 3
.14600836Level 3
asked in Process Analysis
Date picker - conditional formatting

Hi all, We use the date picker quite frequently in our dashboards; however since we are still loading data manually it is quite important for our users to see what the most current data available is. The date picker already formats the days until data is available dark grey whereas the color is light grey for dates where no data was loaded. Unfortunately, we have different countries with different data sets available (e.g. Data for Germany might be loaded until 15th of March 2019 whilst Bulgaria is available until 1st of April 2019). The date picker shows, in this case, per default always every day until 1st of April 2019 in dark grey, even when the user selects Germany (data only available until 15th of March). In order to not confuse users which date is the most current available data set Id like to add a color coding based on the selection of the country (so that when selecting Germany the last dark grey date is the 15th of March 2019). Any ideas how to do that? And, if not possible

42
.
Level 3
N
Level 3
neel.neelLevel 3
asked in Data Ingestion & Infrastructure
Check Formatting of Data in Field

I am trying to check the Number of records that do not comply with std format (XX-XXXXXXX) within a specified field.Any help is greatly appriciated !

11
F
Level 1
V
Level 3
vahide.öztürLevel 3
asked in General Product Q&A
Data Mining for Activity Detection

Hello, Sometimes we struggle that how we can define activity correctly. Thats why we search for more data driven approach to define activities. For example, for change activities , we get count of changed fields and , then evaluate if it gives any inside or not. As a summary we search for more data driven, automated way for activity detection. Could you please share with your ideas ? Best Regards, Vahide.

00
V
Level 3
D
Level 2
david.karweLevel 2
asked in Process Analysis
Chaining PQL Queries

Hi Celonis Community, Ive recently started working in PM and am faced with my first real challenges. To answer complex questions of the process owner I would need to execute more complex calculations in Celonis. Im unsure to which extent this is supported. Ive read through the functions documented in the help section and functions highlighted here but could not find any that provide what Im looking for. Is it possible to base a calculation in Celonis on a previously calculated column? An equivalent of what Im trying to achieve might be subqueries in SQL. Im unable to go give insight into the process and will provide a much simplified example. My activity table looks like this: grafik.png886138 2.98 KB Based on this I can calculate a new table with the automation rate per CASE In the following I want to use the calculated column, to base further calculations on it. Like: OR I hope this is understandable enough. Im also positive, that there might be an easier way to achieve this,

16
D
Level 2
K
Level 3
krzysztof.sitar11Level 3
asked in Data Ingestion & Infrastructure
Connection KPI for custom Activity KPI

Dear Colleagues,I have built a custom Process Explorer Activity KPI, that takes the number of activity occurences from Case Level (BSEG table) and aggregates on header level (BKPF). This is because some activities are happing on header level, regardless of how many invoice lines we have. For example I post invoice only once and want to show value 1, even though it can be posted on 5 vendor item lines (BSEG=5).I want to apply the same for Process explorer connection KPI, but I dont know how to handle it.Can you please help me understand how to apply the logic to connection KPI? Details in attachement.Thank you very much (173.9 KB)

82
K
Level 3
.
Level 4
.14600775Level 4
asked in Process Analysis
OLAP table presentation

Hello, I am building a OLAP table. I was wondering if there was a way to re-structure the table so instead of the single KPI information flowing vertical, it can flow horizontal? I have thought about using a pivot table, however because the data set is so large, it does not seem to be a suitable option. Please let me know. Cheers, Anna

44
V
Level 1
.
Level 4
.14600833Level 4
asked in Data Ingestion & Infrastructure
From a specific activity to the “NEXT” one

Hello everyone, is there a way to calculate a duration between a specific activity (lets say A) to the next activity (whichever it was). Thank you!

215
.
Level 4
oliver.joere
Level 3
oliver.joereLevel 3
asked in Data Ingestion & Infrastructure
Same data model used by different business areas

Weve got the challenge that one data model (for O2C) is used by several different business areas like Sales, Logistics or Finance. Every business area likes to get their specific process activities defined in the data model and number of activities increases significantly. In order to avoid that every business area needs to deal with very detailed activities they are not interested in Id like to provide a customized data model for each business area just showing their relevant process activities. Due to license restrictions we could not simply multiply the data model. Now Im looking for ideas how to solve this issue.

35
oliver.joere
Level 3
joos.buijs
Level 6
joos.buijsLevel 6
asked in General Product Q&A
XES import: case table creation (and gzip support)

Today I loaded the BPIC 2017 event log and noticed that although the event log contains both event and trace level attributes, Celonis flattens all to event level attributes. Feature request: XES import results in both an activities as well as a case table. Minor feature request: support for gzip-ed XES files (BPIC17 is 560Mb as XES XML file, but less than 30 Mb as xes.gz, something you notice when youre working from home).

30
joos.buijs
Level 6
S
Level 3
sachin.rajpu12Level 3
asked in Data Ingestion & Infrastructure
Global Variable

Hello Celonis Team,Today I am using a variable that is defined within an analysis.How can I define the variable at the Data Model level so that we can use the variable throughout all the analysis that is created using that Data Model?Regards,Sachin

132
D
Level 3
V
Level 3
vaclav.juren12Level 3
asked in Process Analysis
RCALL or RAGG in Celonis

Hello, can someone please tell me how to put R code in Celonis? It is working in RStudio, but when I put it in RCALL or RAGG it gives me errors I do not understand. Can someone please explain to me how exactly RCALL or RAGG works? Thanks Vaclav Juren

11
D
Level 2
C
Level 2
carlo.ruggiLevel 2
asked in Process Analysis
Activity Selection in PQL Syntax

Hello, I don`t know what is the correct PQL Syntax for this Activity Selection for my KPI Component option (see screenshot). Thanks in advance for your responses :o)) image.png1061476 22.5 KB

52
C
Level 2
joos.buijs
Level 6
joos.buijsLevel 6
asked in General Product Q&A
Add axis range option: max

Currently axis ranges can be set to automatic or manual. Issue: What I observe is that the axis range is determined on the >visual< bars/dots/etc. However, this is confusing as scrolling causes the axis to dynamically change. Proposal: Add a third option which either sets the scale to all data points visible and not. Alternatively, but less user friendly in some use cases, allow PQL in the manual ranges (MIN/MAX() would need to be added by the user manually and in sync with the displayed KPIs so not that user friendly.

30
joos.buijs
Level 6
joos.buijs
Level 6
joos.buijsLevel 6
asked in General Product Q&A
Feature request: direct link from Celonis PQL library to more extensive PQL help documentation

Currently when adding dimensions/KPIs in the code editor there is a list with PQL functions and a summarized explanation of the feature. It would be really helpful if there would be a direct link from this summary to the Celonis help documenation with usually more extensive explanations and examples.

11
D
Level 2
S
Level 3
stefan.grossLevel 3
asked in Data Ingestion & Infrastructure
Getting Difference in consecutive data values in time series data (column chart)

Dear all,I have a time series plot of the automation rate like the following:x- Axis: ROUND_MONTH(EKKO.AEDAT)y-Axis: KPI(Automation Rate) (standard automation rate formula; should work then with any KPI)My Goal is to calculate the difference in the automation rate between the current month and the previous one i.e. get as result 4.8%.How to do this in celonis? In the end I want to have a list of KPIs which from design point of view look like the followingIs there a simple way to calculate the 4.8% in a dynamic way (the 7.33% is coming from 2 years of data)?Thxs & Br,Stefan

42
S
Level 3

Badge Winners

  • Qualified to Build Views
    l.colzanihas earned the badge Qualified to Build Views
  • Celonis Technical Expert
    Pablo MChas earned the badge Celonis Technical Expert
  • Qualified to Get Data Into Celonis
    Pablo MChas earned the badge Qualified to Get Data Into Celonis
  • Qualified to Build Action Flows
    Pablo MChas earned the badge Qualified to Build Action Flows
  • Qualified to Write PQL Queries
    Pablo MChas earned the badge Qualified to Write PQL Queries
VIEW ALL
Community Code of Conduct