Skip to main content

Product Q&A

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

4364 Topics
Mst11
Level 3
Mst11Level 3
asked in General Product Q&A
Font size

Hello everyone,Does anybody knows what is happening with the font size of numbers in KPI Cards. Some of them are extremely big and some seem to be normal sized. Thanks a lot!

665
J
Celonaut
alison.macke
Level 2
alison.mackeLevel 2
asked in Process Management
How to change the default font colour in Process Designer Graphic editor

In Process Designer Graphic Editor, the default font colour for new links/text is brown. When I change the default colour it is only saved for the current model. How can I change the global default setting?

141
caspar.jans
Celonaut
markus.golka
Level 2
markus.golkaLevel 2
asked in Process Analysis
Throughput time based on first occurrence and ignore multiple/duplicate same activities

Hello all, I would like to calculate the througput time from activity to next different activity.The Challenge:My process has activities which occurs multiple times with the same name directly one after the other. This is no data issue, the process is designed that way.In case the activity with the same name occurs later in the process again, this should be count as well and not ignored.What is the time to the next activity, which does not have the same name? Process example:Avtivity       TimestampA    01:00 pmB    01:30 pmB    01:45 pmB    02:15 pmC    03:00 pmC    03:20 pmD    03:45 pmE    04:00 pmE    04:50 pmA    05:00 pm Expected Result:Avtivity       DurationA                30minB                1h 30minC                45minD                15minE                10min Does anybody know a solution or a community post, which can help me?

210
markus.golka
Level 2
filipe.mussi
Level 2
filipe.mussiLevel 2
asked in Process Analysis
Error when using filter with Case When

Hello,I'm trying to make the DSO indicator, but I need to get data from several tables and I'm having problems...The DSO formula is made up of two parts, Revenue and Accounts Receivable. I need to calculate each one individually and then divide one by the other.I'll use the example of Accounts Receivable:Quando eu uso os campos de Filtro, com os seguintes filtros, funciona sem problemas:FILTER "o_celonis_SalesOrder"."CompanyCodeText" IN ('CompanyNameZYX');FILTER "o_celonis_SalesOrder"."SalesDocumentType" IN ('XXXX', 'YYYY');FILTER "o_custom_CustomerAccountItem"."BaselineDate" <= {t ${end_date}};FILTER "o_custom_CustomerAccountItem"."ClearingDate" > {t ${end_date}} OR "o_custom_CustomerAccountItem"."ClearingDate" IS NULLHowever, when I try to place the same filters in Case when, to generate the indicator that will be combined with Billing, there is a connection problem between the tables (o_celonis_SalesOrder and o_custom_CustomerAccountItem).sum( CASE WHEN "o_celonis_SalesOrd

470
filipe.mussi
Level 2
michaela.gebha
Level 3
michaela.gebhaLevel 3
asked in General Product Q&A
Order Mgmt Execution App - Filtering on a range of postal codes

Dear Community,Is there a possibility to create a filter component in the Order Mgmt Execution App giving the users the possibility to filter on a range of postal codes from/to (similar like a date filter)?Thanks for your help!Kind regards,Michaela 

90
michaela.gebha
Level 3
PhuongBHN
Level 3
PhuongBHNLevel 3
asked in Data Ingestion & Infrastructure
How to enable the ‘Push data into Celonis’ Data connection option within my Data pool

Hello everyone, I am unable to locate the ‘Push data into Celonis’ Data connection option within my Data pool.Could you guide me on how to enable this feature?!--endfragment>My Celonis  I want the ‘Push data into Celonis’ as the image below 

423
abdulnour.duale11
Celonaut
benjamin.caill
Level 3
benjamin.caillLevel 3
asked in Process Analysis
Studio views, variables not retained in bookmarks and shared selections?

Dears, Using legacy analyses, we were able to set variable values and save bookmarks / share selections that included the state of the variables.  In studio views, it seems the state of the (user) variables in not included in bookmarks and shared selections. Has anyone encountered the same challenge? Is there any way to share a link or bookmark including the state of the variables? Thank you. 

202
benjamin.caill
Level 3
benjamin.caill
Level 3
benjamin.caillLevel 3
asked in Process Analysis
How to access data from the Activity History Log

Dears, The activity history log component in JAB views allows us to see when augmented attributes and comments were updated.I want to to pull the date when the last action was taken for the object e.g. invoice (either through update of any augmented attribute or by adding a comment). I can’t find a way to achieve this and bring the information in a table. Thanks 

262
benjamin.caill
Level 3
NHARNIS
Level 2
NHARNISLevel 2
asked in Process Analysis
Using Pu functions instead of Aggregates to be able to Filter KPIs

Hello Celopeers, im new to Celonis and have created a view. There i use a Kpi which drops a lot of zero values. When trying to filter them out i always get the error that aggregated functions can not be used in combination with the FILTER function, and that i should try PU functions. The KPI i'm using is this:SUM( CASE  WHEN round_day("o_custom_KnotenpunktAuftrag"."AusgangForecast") = round_day("o_custom_KnotenpunktFuellstand"."Date")  THEN 1  ELSE 0 END)or alternetively this : COUNT(DISTINCTcase when round_day("o_custom_KnotenpunktAuftrag"."AusgangForecast") =round_day("o_custom_KnotenpunktFuellstand"."Date") then  "o_custom_KnotenpunktFuellstand"."KnotenpunktAuftrag_ID"end) is simply want to calculate for each KnotenpunktFuellstand.Date, how many Order.IDs i have where the filter condition is met.So i can have a table where im using the date plus KPI to see, how many outgoing orders i can except for each date. How can i have a row-count, based on a condition formulated as a PU functi

362
NHARNIS
Level 2
Saba
Level 4
SabaLevel 4
asked in General Product Q&A
Classiffy

Hi everyone,I have a column with many numbers, and I have uploaded a screenshot as an example. I want to classify them into groups. FYI: I know the maximum, minimum, and median, and I also know the total number of numbers.How can I do that?Thanks in advance! 

9515
matthias.gielk11
Level 3
deeksha.r12
Level 4
deeksha.r12Level 4
asked in Process Analysis
Accessing and Configuring Scheduled Reports

The reports section is intended for viewing scheduled reports, we do not see any option to configure them. 

151
matthias.gielk11
Level 3
ritesh3719
Level 3
ritesh3719Level 3
asked in Process Analysis
How to Capture User Inputs in Studio Views and Store Them in Backend SQL Table

Hi Community,I'm working on a use case in Celonis Studio where I want to take inputs from users directly via Studio Views  — such as dropdown selections, text inputs, or button clicks — and then store those inputs in a backend SQL table (in a Celonis data pool).What are the recommended ways to capture user inputs from Studio Views (e.g., via Input Controls or custom components)?

303
matthias.gielk11
Level 3
ritesh3719
Level 3
ritesh3719Level 3
asked in Process Analysis
How to send dynamic email content in Action Flow based on status

Hi Community,I’m building an Action Flow that sends email alerts based on a flag column (e.g., Alert_Status = 'Yes').The email subject and body should change dynamically based on the record’s status (like Pending, Approved, Rejected).I have a config table that maps each status to a subject and body template.Appreciate any suggestions!

233
S
Celonaut
manuel.wetze
Level 5
manuel.wetzeLevel 5
asked in Process Analysis
Variant Explorer: Add custom KPIs

Hi all I am wondering how to best add a custom KPI defintion to the Variant Explorer.Mainly I want to add my custom process specific defintion of a througphuttime. Me and my endusers don’t care about the default End2End TPT that Celonis always uses as default but rather the time between two specific activities.Instead of (or at least additionally to) the “Avg TPT” Column in the selection panel I would like to use my Metric “Median CustomProcesstime”.Does anyone know if this panel can be changed? Maybe via YAML?  

170
manuel.wetze
Level 5
emil.vakhi12
Level 3
emil.vakhi12Level 3
asked in Process Analysis
SAP FI-CA model for Accounts Payable

Hi, has anyone created a data model for Accounts Payable using SAP FI-CA data?Could you please advise on its parameters - what do you take as case ID, which additional tables your add, which activities do you extract, etc.?

222
emil.vakhi12
Level 3
Iori Oshima
Level 3
Iori OshimaLevel 3
posted in Process Management
What is the best practice when I describe the process map like TMForum

Dear all, I’d like to describe the process map like TMForum in the Process Designer .Like this : https://www.tmforum.org/certifications-awarded/huawei-digital-crm/business-process-framework/ TMForum eTOMThere are the horizontal part and vertical part.When we use the hierarchical edit alone, it cannot describe so I think that graphic is useful for me to do that. In graphic edition, we can use some diagram like ppt, but this will not be stractured.So I’d like to keep stractured and reuse the process I made as possible as I can. I ask you to advice on which parts should be presented as graphics and which parts should be structured as text. Regards,

222
Iori Oshima
Level 3
michael.kohlm
Level 2
michael.kohlmLevel 2
asked in Process Analysis
Assign Costs, depending on the predecessor

Hello,I am quite new to PQL and I tried to assign costs to spesific activities depending on the predecessor.When B is followed by C, only C should be assigned with certain costs. When A is followed by C, again C should be assigned with costs, but with a different value. The result should look like this:CaseID Time Activity Costs 150488 07:34 A   150488 08:30 B   150488 09:23 C 0,84 150488 09:45 D   150488 10:34 A   150488 11:45 C 1,56 150488 v E     I tried this with the following code: CASE  WHEN "ActivityTable"."Activity" = 'C'   AND MATCH_PROCESS_REGEX (    "ActivityTable"."Activity",    'A' >> 'C'   ) = 1  THEN 1.56 WHEN "ActivityTable"."Activity" = 'C'    AND MATCH_PROCESS_REGEX (    "ActivityTable"."Activity",    'B' >> 'C'    ) = 1   THEN 0.84 ELSE 0END Unfortunately the table looks like that, so it assigns the wrong costs: CaseID Time Activity Costs 150488 07:34 A   150488 08:30 B   150488

10
michael.kohlm
Level 2
Saba
Level 4
SabaLevel 4
asked in Process Analysis
Sorting

Hey People,I need help sorting a coloumn in a table where each item number appears twice with a corresponding "Potential Savings" value. My goal is to sort the "Potential Savings" coloumn in descending order while keeping duplicate Item Numbers together (as shown in the current table). However, when I try to sort "Potential Savings," the duplicate entries get separated.Does anyone know how to sort the table in a way that maintains both the descending order of "Potential Savings" and keeps the duplicate items next to each other?Thanks in advance! Vendor Name Business Unit Item Number Commodity Last Order Date Expected Delivery Days Unit Price Potential Savings Alpha Supplies P18 0410390025 I030 2004-01-29 27 10.45 52.66 Beta Industries P20 0410390025 I030 2004-02-09 0 6.90 0.00 Alpha Supplies P18 0437150201 A110 2004-07-31 40 40.67 69.35 Gamma Solutions P20 0437150201 A110 2004-08-26 50 32.00 0.00 Alpha Supplies

192
Saba
Level 4
douglas.souza
Level 3
douglas.souzaLevel 3
asked in General Product Q&A
Variable Clear

Good afternoon/Good morning Celonautas, could any of you tell me if there is any way I can clear the variable? For example, the variable is disabled. I would like it to clear the variable from my dropdown when it is selected.Here is how it looks when I disable it.And how I would like it to look  

131
jonas.hess
Level 3
gauri.pai11
Level 3
gauri.pai11Level 3
asked in Process Analysis
Involve business user with task - unable to find record in task list

Hi team,I was trying to follow as per below screenshot.But i am not able to find a record in task list although added in knowledge model(Attached screenshot below of task list component and knowledge model respectively)Can someone please guide me on this?Thank you in advance!

203
jonas.hess
Level 3
Suveesh_adessi
Level 2
Suveesh_adessiLevel 2
asked in Data Ingestion & Infrastructure
Celonis Audit API - Group & Group Members

I’ve been extracting Celonis audit logs API for user-platform analysis. I couldn’t find the right field for group name and group members in the extracted data. If you are someone done this already, please share your knowledge to get these data.Also, please mention if there is any dedicated API endpoint is available to extract those data.

151
jonas.hess
Level 3
Saba
Level 4
SabaLevel 4
asked in General Product Q&A
Classification

Hello everyone,I have a coloumn with a lot of numbers and as an example i have uploaded a screenshot of it.I wanted to classify them into groups so i wrote a case when like this :CASE        WHEN KPI("max_potential_saving") BETWEEN 7000 AND 70000  THEN 1          WHEN KPI("max_potential_saving") BETWEEN 1000 AND 7000  THEN 2              WHEN KPI("max_potential_saving") BETWEEN 800 AND 1000  THEN 3            WHEN KPI("max_potential_saving") BETWEEN  600 AND  800 THEN 4          WHEN KPI("max_potential_saving") BETWEEN  400 AND  600 THEN 5        WHEN KPI("max_potential_saving") BETWEEN  200 AND  400 THEN 6        WHEN KPI("max_potential_saving") BETWEEN  0 AND 200  THEN 7        ELSE 8      ENDbut when i sort it based on the classification it does not show the Max Potential Saving in order from highest to lowest. Does anyone have an idea ? Thanks in advance !

573
Julie Shih
Celonaut
MrAj
Level 3
MrAjLevel 3
asked in Data Ingestion & Infrastructure
How to Trigger a Machine Learning Script from a Button in Celonis?

Hi everyone,I need help figuring out how to execute a Machine Learning script directly from a button in my Celonis app in views (dashboard). I believe I might need to use Action Flows, but I’m unsure about the exact steps to make this work.Here’s what I want to achieve: When a user clicks a button in the Celonis app, it should trigger an ML script. The script could be hosted externally (e.g., a REST API) or executed within Celonis.( atm its not hosted, there is just a file in ipynb format, stored in ml workbench in  analysis. I need guidance on how to set up the Action Flow and link it to the button. Has anyone implemented something similar? If so, could you share the best approach and any potential challenges I should be aware of?Thank you in advance!

170
MrAj
Level 3
MrAj
Level 3
MrAjLevel 3
posted in Data Ingestion & Infrastructure
How to Trigger a Machine Learning Script from a Button in Celonis?

 Hi everyone,I need help figuring out how to execute a Machine Learning script directly from a button in my Celonis app in views (dashboard). I believe I might need to use Action Flows, but I’m unsure about the exact steps to make this work.Here’s what I want to achieve: When a user clicks a button in the Celonis app, it should trigger an ML script. The script could be hosted externally (e.g., a REST API) or executed within Celonis.( atm its not hosted, there is just a file in ipynb format, stored in ml workbench in  analysis. I need guidance on how to set up the Action Flow and link it to the button. Has anyone implemented something similar? If so, could you share the best approach and any potential challenges I should be aware of?Thank you in advance!

140
MrAj
Level 3
amey.punek12
Level 3
amey.punek12Level 3
asked in Process Analysis
Issue with Skills (Manual Selection)

We have created a OLAP table which we have connected to a skill.In the skill we have created Manual Sensor and enabled the manual selection option but it is not working correctly.In the OLAP table we have also added URL in "Allow Data Service Link" 

40
amey.punek12
Level 3

Badge Winners

  • Celonis Certified Data Analyst
    sudhakar.ybhas earned the badge Celonis Certified Data Analyst
  • Qualified to Build Views
    Gero Busatishas earned the badge Qualified to Build Views
  • Qualified to Write PQL Queries
    sahil.rathe11has earned the badge Qualified to Write PQL Queries
  • Qualified to Manage Implementation Projects
    delano.dewet11has earned the badge Qualified to Manage Implementation Projects
  • Qualified to Create and Deliver Demos
    anna.jakub12has earned the badge Qualified to Create and Deliver Demos
VIEW ALL
Community Code of Conduct