Skip to main content

Product Q&A

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

3129 Topics
Saba
Level 3
SabaLevel 3
asked in General Product Q&A
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

102
Saba
Level 3
Saba
Level 3
SabaLevel 3
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! 

172
Saba
Level 3
jan.vajse12
Level 3
jan.vajse12Level 3
asked in General Product Q&A
Shared link opens last user's selection

Hello,our users face regulary the issue that if someone sends them link with a certain selection, what opens is their last selection of the view and not the selection that was shared with them. Is there any known way how to overcome this setup? If you send somebody a selection, this selection should alway show up if the person clicks on the link. Thank you for any advice.Jan

143
andre.albar
Level 2
MrAj
Level 2
MrAjLevel 2
asked in General Product Q&A
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?

81
jonas.hess
Level 3
gauri.pai11
Level 2
gauri.pai11Level 2
asked in General Product Q&A
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!

123
jonas.hess
Level 3
Saba
Level 3
SabaLevel 3
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 !

463
Julie Shih
Celonaut
MrAj
Level 2
MrAjLevel 2
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!

60
MrAj
Level 2
MrAj
Level 2
MrAjLevel 2
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!

20
MrAj
Level 2
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" 

20
amey.punek12
Level 3
benjamin.caill
Level 2
benjamin.caillLevel 2
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 

91
jonas.hess
Level 3
jonas.hess
Level 3
jonas.hessLevel 3
asked in General Product Q&A
Anyone familiar with Skills?

Hello,  id like to create a skill which is triggered on every first of the Month. I Created an kpi like this if Left(Today(),2) = ‘01’ then KPI = 1. So my KPI logic is working fine but, i do not found any way to use this kpi as a trigger for a Smart Sensor. I included the KPI into a Record, but when i try to use this record in smart sensor, it does not show me created attribut with my KPI. Did anyone had a similiar Projekt with triggering Smart Sensor at the first of the Month, and could maybe help me? Kind Regards Jonas

50
jonas.hess
Level 3
Bharath
Level 3
BharathLevel 3
asked in Process Analysis
Process flow analysis

PROCESS FLOWNeed some assistance, I have a CaseID, Activity and Timestamp. I need to get all the cases where the activity flow is A to B to C. (NOTE: the activities don't have to be directly followed by) I cannot use MATCH_PROCESS_REGEX or any other commads. I need to used CASE WHEN, AND, ACTIVITY_LEAD etc... to solve this. Please help me out. My approachCASE WHEN "tab"."Activity" = 'A'AND ACTIVITY_LEAD(CASE WHEN "tab"."Activity" = 'A' THEN "tab"."Activity" END) = 'B' AND ACTIVITY_LEAD(CASE WHEN "tab"."Activity" = 'B' THEN "tab"."Activity" END) = 'C'  THEN CaseIDEND

194
Bharath
Level 3
.
Level 4
.14600833Level 4
asked in Data Ingestion & Infrastructure
Source und Target with PROCESS_ORDER

Hello everyone,i need a throughput between two consequitive activities and want to implement it via source and target.Die idee wre source(activity_table.activity), target(activity_table.activity, process_order(target)=process_order(source)+1))would it work?Best,Maria

105
sudharani.perum
Level 2
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,

111
caspar.jans
Celonaut
Iori Oshima
Level 3
Iori OshimaLevel 3
asked in Process Management
The difference of the words between Facet and Repository and Attribute

Hi all, I’ve learned the cource of “Celonis Process Management (CPM)”, but I don’t understand meanings some words well. I can understand Category Core Process, Main Process, Support Process Main Process, Sub Process But I can’t understandFacet Repository Attribute (Attribute group) StereotypesI would like to clearfyWhen or Where to use  What is the main concept they are connected to If there are any words which help me understand, feel free to add some words & concepts. Ref01. Welcome to Business Process Management > Learning the vocabulary [12:00] > Repository Objects and Facets [03:00]https://academy.celonis.com/learn/course/symbio-kickstarter/welcome-to-business-process-management/learning-the-vocabulary-1200?client=customer-panorama&page=3&query=facet

192
caspar.jans
Celonaut
koert.kritz11
Level 3
koert.kritz11Level 3
asked in Process Analysis
PAM Event log Error

Hi I, I am configuring my PAM but keep running into these errors.  ErrorSupport Id: faafa039-b13e-47e6-88cd-7e64c7f898e6PQL Error during operation: Events - Count. Repeating the request will always result in error. Fix this by changing the current asset state. If the error persists, please contact support. ErrorThere are event logs in your selection which are no longer available or valid:EL_CUSTOM_OTTPAYMENT__ACTIVITYI created a second eventlog with the required names for my activities and this works when I use it for process explorers and case explorers, but when I try and use it for my PAM I get the error messages. Here are my eventlogs: 

40
koert.kritz11
Level 3
omar.elmou
Level 3
omar.elmouLevel 3
asked in General Product Q&A
Dear Celomates,I would like to add the rework rate as a KPI without using PQL.

I have added an OLAP table with three columns where the Count of activities is compared to the Distinctcount activity for each case key. Please find attached the OLAP table. Besides the OLAP table i would like to show the rework rate as one number by referring to the formula and outcomes of the OLAP table. How can i add a number (without using PQL) where the ration of cases with a YES", as displayed in the OLAP table, is returned as one percentage. Many thanks!

172
Poovarasan
Level 2
david.stefa13
Level 3
david.stefa13Level 3
asked in Process Improvement
Action Flow - Sending an MS Outlook CSV file automatically to each customer and their varied list of contact email_addresses

As part of the MS Outlook email recipient ‘To list’, the number of email recipients varies by customer and can vary from 1 contact to up to 9 contacts. For those familiar with the term ‘Rolodex’, (customers/contact_names/email_address), I want to automatically sequence through the ‘Rolodex table’ and send one email to each identified customer (based on a flag that is set) and TO: each respective contact for that customer (1 to 9 contacts_email_addresses). What is the best way to address the ‘dynamic list’ of email contacts per customer that need to get set up in the MS Outlook module?I have seen the example in the community of using the Group function in the CSV module, but that example was specific to 1 role (1 recipient in the MS Outlook 365) vs a varied list of contact_email_addresses, depending on the customer.

382
david.stefa13
Level 3
andres.naran12
Level 4
andres.naran12Level 4
asked in General Product Q&A
How to get the timestamp for an specific activity?

Hi community, I have the following challenge that I’m trying to figure out.I need to calculate how many hours were spent on a holiday, since the connection is not through SAP, I cannot use the functions that PQL provides for that.My idea is to get the timestamp related to the last activity that happened on holiday and calculate the throughput time between 9:00 AM and that specific time in order to get how many hours were spent.Example:Activity 1 → Day 1 Activity 2 → Day 2 (holiday) Activity 3 → Day 3 Activity 4 → Day 4In this example let’s suppose activity 2 occurred at 13:00, so in this case I should do the following calculation. 13 - 9 = 4 hours → This is the number of hours that were spent on holiday. Does anyone have a similar experience?

182
andres.naran12
Level 4
Sony Shrestha
Level 2
Sony ShresthaLevel 2
asked in Process Analysis
Check if last occurrence of A directly follows B

I am aware of PQL that checks if activity A directly follows B. Can someone help me with PQL to check if first/last occurrence of A directly follows first/last occurrence of B?

201
janpeter.van.d
Level 8
marcin.konop13
Level 3
marcin.konop13Level 3
asked in General Product Q&A
Custom Attribute not available for KPIs

Hi all I have created a simple attribute that calculates a metric I will be averaging out.  And in the table it looks fine. However whenever I try to call it I get an error  Please assist. I presumed as documentation states that those calculated attributes are treated the same as values in a column. KindestMarcin

298
rita.kiss12
Level 4
Sony Shrestha
Level 2
Sony ShresthaLevel 2
asked in Process Analysis
Get number of instances of object type O1 which is related to n instances of object type O2

I want to write PQL that gives me number of instances of object type O1 which is related to n instances of object type O2. Ex: Number of Purchase Order which is related to 2 instances of payment. There is no 1:N relation between these table. In this scenario, is it still possible to get number of instances of one object based on how many times it is related to other object type?

132
Sony Shrestha
Level 2
Hafsa
Level 2
HafsaLevel 2
asked in General Product Q&A
celonis Vs camunda

Hello,I want to know why using Celonis and not Camunda for process improvement? I made some research and I found that with Camunda optimize I can get visualisations ..., logs from Camunda execution. So I need to know the ++ of Celonis compared to Camunda in term of improvement results and process optimization and not the approach.Thank you  

150
Hafsa
Level 2
farouk.abdel
Level 2
farouk.abdelLevel 2
asked in Data Ingestion & Infrastructure
CPM4 sizing

what is the celonis sizing guidelines for CPM4?

71
A
Celonaut
P
Level 1
puneet.duaLevel 1
posted in General Product Q&A
Can anyone confirm if we can extract the KPI data in excel format

Can anyone confirm if we can extract the KPI data in excel format

133
bruno.castr
Level 2

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 © 2025