General Product Q&A

Hi folks, Does anyone know if it is possible to have a dynamic date in a table? so that the table has a column with today's data, and the header shows the current date?

The SAP S4H Data Model for Credit Management has changed since ECC.Has anyone had experience in extending the existing Celonis AR data model to incorporate credit management? I am currently developing such a model for a client and would be interesting in the experience of othersRegards

As someone with a stake in Celonis’ success by means of a commercial online course I have been offering since 2021, I’ve closely observed its evolution in process mining. My experience, along with feedback from my students, has highlighted a growing concern: while Celonis’ new advanced features like the business miner, the execution management system, object-centric process mining and AI-driven intelligence are impressive, they seem to overshadow the platform’s foundational strengths—offering simple, actionable insights. The Shift Away from SimplicityIn the early days, Celonis was a go-to for its ease of use: you could upload an event log and instantly generate a clear, valuable 2D process map. The low barrier to entry made it ideal for those looking to identify inefficiencies quickly. Today, however, reaching that classic 2D process map with sliders feels almost like a hidden feature. Navigating through the various menus, filters, and new tools can take numerous clicks, with a lot of

Hello I am new to the platform ; I would like to know if there is a way to find fake log activities that I could use to test the solution. Thank you for the help ! Cédric

Hello everyone, I am an employee from a technology company called Terus. I am assigned to learn and know how to use Celonis, then bring it back to apply to the company's process, but I currently do not have a clear plan for this move because in my country, not many people use Celonis.By chance, when I was researching, I noticed that this community and everyone shared a lot of information related to Celonis. I want to ask about the roadmap that everyone learned to use and apply Celonis? I hope everyone can give me an answer!

*Deleted Post*  (re-posted as a new post here:  

How do I add a process explorer filter in an analysis that calculates throughput time between activities in seconds?

I want to filter based on a condition like this:FILTER Color = 'blue' WHEN Shape = 'square'. I'm having trouble creating a formula like this because what I have tried is filtering all instances where Color = 'blue', but I want to filter only for blue color when the shape is square.I think this should be something very easy to do, but I'm having trouble. Thanks in advance :)

I need some help guys, I want to add up the day's payments to generate an accrual. Example: Day 01 $100, Day 2 $200 Day 03 $300 In the amount I want, I would do it like this: on day 1, $100, on day 2, $300, on day 3, $600. But I don't know how to do it, below in Excel how it was done.This needs to be per month. So it adds up only within the month when the month ends it resets and dnv starts. I don't know if it's clear, but you can try to clarify better. Excel:  my attempt at PQL   SUM ( CASE WHEN "BSEG"."AUGDT" >="BSEG"."AUGDT" THEN KPI("valor_acumulado") + "BSEG"."DMBTR" ELSE  "BSEG"."DMBTR" END) valor_acumulado = CASE WHEN  "BSEG"."AUGDT" >= "BSEG"."AUGDT" THEN "BSEG"."DMBTR" END  

Do anyone know the PQL formula to find PR which is not converted to PO within 2 days

I have a trigger which is link to 2 subscribers. I'm not able to delete the subscribers, so when I delete the trigger, it gives following error.

I want to connect Azure MySQL to celonis. I am not able to connect. Getting error message "Connection test failed. Please check the data connection and ensure that the system is running. Extractor responded with an internal error."

Hi, Can you help me with a PQL that can showcase total time spent by each workgroup on an incident? The incidents can be re-assigned between different workgroups in its life cycle. output required Workgroup Avg time spent on incidents Volume of Incidents handledA XX mins. 10 incidentsB XX mins 20 incidents Example data below.

Hi, I'm trying to show a target inside a column and line component, but for some reason I'm not able to add it.I already created the target in the desired KPI, but I don't know how to show it. Did anyone have a similar scenario before?  

Does anyone know of an online place (URL) where we can view sample use cases and practice PQL query?

Enhanced variables and updates to existing Knowledge Model variables in Studio (2024-09-16) You can now create and use enhanced variables in your Studio content. Enhanced variables allow you to centrally create and manage information that is referenced and reused across components and assets in Studio. They act as placeholders for information, either based on dynamically inserted context (such as company names, countries, and sales orders) or with manual input by the app user (such as entering the cost of an item). There are two types of enhanced variables:Enhanced View variables: These are specific to individual Views and can't be reused across Views in the same package. To learn how to create and manage enhanced View variables, see: Creating and managing enhanced View variables.Enhanced Knowledge Model variables: These can be used wherever the Knowledge Model is being used, as such can be reused across Views, Packages, and Spaces. To learn how to create and manage Knowledge Model

Has the On-Premise Environment in Celonis been deprecated or is there a plan for this? I'm looking for clarification and insights on why this shift might happen, and how to best handle the transition if we're still using the on-prem version

I wanted to use Get Message module of Microsoft 365 email in my Action Flow. But I don't know what does each field mean and what are the accepted values for those fields. For example in the screenshot below.I checked Celonis as well as in make.com documentation, but none of the place I found the proper documentation. Thus, can someone suggest where I should look for documentation on Microsoft 365 module.

I have the following scenario, there is a component table inside a view each column is related to some KPIs, and in other columns, the values are coming from inputs that the user inserts manually inside the Apps. It means that some values don't exist in the data model or can be generated with any table since they are inserted manually. I would like to know if it's possible to create an action flow that reads all the values from that table in the studio and sends the data to a data pool. I was checking the documentation, but it seems that all modules from Celonis are only capable of reading data that exists in a data model or a knowledge model but not from a table component.  

Could you tell how to set up the Share Link button?(Attached below) The permissions are also fine for the administrator in the target environment.I would be grateful if you could let me know.

In my output (OLAP) table I want to have each activity name from the activity table and then an overview of the number of cases in which that activity name has occurred. Then I want to get an overview of the number of cases in which that activity name has occurred two times, three times, or multiple times etc. I know that with the following code I can get the number of cases where the activity happened at least 1 time, but I do not know how to calculate the number of cases where the activity happened 1 time and not more often. SUM(CASE WHEN INDEX_ACTIVITY_TYPE ("ACTIVITY_TABLE"."ACTIVITY") = 1 THEN 1 ELSE 0 END)  The other thing I still miss is how I can calculate the number of cases in which that activity occurred >=2 times. When I change the formula to >=2, I get the wrong count as then a case with 4 activity occurrences is counted as 3 instead of 1 (it counts the second occurrence, third occurrence and fourth occurrence all as one 'case'). Is there

I am trying to configure a comment component in the new views. I followed all the steps in the documentation but it is still not working. Is there additional documentation or other steps to configure the component that is not in the documentation?

 I would like to stack bar graphs on top of each other like this - I see there is an option to "Stacked (on Primary Axis)": But it looks like when I add a secondary axis that option disappears -  Does that mean it is not possible in Analysis to combine a stacked bar graph with a line graph on the secondary axis? Or is there a way to combine a stacked bar chart on the primary axis with a line chart on the secondary axis?

"Scroll from right" doesn't seem to work in View