Product Q&A

Hi all,i got a strange issue. In view → table, i can see value “-” in column ‘Region’.However, when I try to search it in column search dialog , i can’t find it.The datasource of this column is coming from a customize excel sheet.  Can anyone help on this issue ?

Hello together,is there a way to (re-)load the data permission table automatically? Currently, it seems like that setting up a data permission table is only possible by manually clicking on the button ‘apply permission table’. I wonder if there is the possibility to schedule the load to automate this procedure.Has anyone experienced this problem and found a solution for it?Thanks! 

Hello Community,I am working in Celonis Studio- Views Asset where in one of the tabs i am adding a button that i want to use for navigating between Tabs.I tried the “Open linked View” option and yet it doesn’t seem to save and nothing happens when testing it. Any Advice please ?Thanks

Hi Community,I’m working on an individual custom project (not based on any default Celonis template) and I’m facing an issue where no data is visible in Process Explorer, even though the data model and configurations appear to be correct. I’m looking for guidance on advanced or non-obvious checks specific to custom implementations.Project context This is an individual project No default Celonis template is used All event logs, case/object tables, and views are created manually What is already verified and working ✅ Event data is successfully loaded into the data pool ✅ Transformations execute without errors ✅ Data is visible in table preview after transformation ✅ Activity column is correctly configured an

Hello Everyone,I have a scenario where I need to calculate the automation rate of a process. However, there is a specific condition: I need to exclude all activities that occur between the Approval Task Start and Approval Task End. These approval segments may appear multiple (N) times throughout the entire process.Please let me know if you have encountered a similar situation before or if you have any recommended approach for handling this type of exclusion logic.

Hi all, I am wondering about how to best setup the user permissions for my end-users of a package.I have two different groups of end-users (=Groups in admin & Settings panel). First one is a huge group of plain normal endusers who should have read access to a myrad of assets within the package lets call them “Read Users”.Then I have a single special “Settings View” which is used to set and edit specific Augmented Attributes which steer the. The editing of said augmented Attributes shall only be done by a small group of higher privilege “Admin Users”.see minimal example: I would prefer to give Read Users access on Package level as there are 30+ different assets they need access to. But I need to exclude them from editing the settings in “Settings View”. I can imagine that

Hey Celopeers, I want to create a Table within a View wihich contains 4 columns. One Column is the Dimension Column (Gives 15 Rows). In one column the numer of invoices for the current month are counted. In the other column the number of invoices from the previous month and in the last column the number of invoices for the month before last.  The user want to have the coulmn names in the format "YYYY/MM" and the column names should be dynamic, so that in the new month the column names are updated automatically. We are using the Knowledge Model - View Technology and no analysis. I also thought of using a chart diagramm, but the users require a table. I tried some things, but nothing worked. So if somebody knows about how to create dynamic columns I would be very thankful for your help :D  

One of my customers is asking for a detailed comparison of features between Celonis and Signavio. Can any one provide a link or document regarding this please?

Working with a dataframe activity table in Python I export the file in parquet format for efficiency reasons. However, when I load the file in Celonis it doesn't recognise the timestamp in the proper format but as a string. Can anyone tell me why this error is happening? Thank you very much. Thanks a lot.

Hi community.I have a question regarding WORKDAYS_BETWEEN function, currently, I’m trying to get the number of workdays between the creation date of a ticket and its current date, according to Argentine calendar. This is the PQL I have so far.WORKDAYS_BETWEEN ("XXXX"."fields$created",TODAY(),  FACTORY_CALENDAR(            "FACTORY_CALENDAR_ARGENTINA"."START",            "FACTORY_CALENDAR_ARGENTINA"."END"        ))For some reason, the PQL doesn’t return any results for any case. I tried this calculation with other functions like DAYS_BETWEEN instead, and it works. However, I need to take into consideration only the Argentine workdays.I’m not sure if WORKDAYS_BETWEEN supports the TODAY() functions. Has anyone faced a similar problem? Best!

Hey, my goal is to setup a line chart that is showing the “open tickets by time”. The issue is that the status of the ticket is changing in the db, means i cannot say: Last week I had 20 open tickets (because the status of these “old” tickets changed already to closed and not open anymore), this week i am having 14 open tickets → trend is great. Do you have an idea on how i can establish such a graph? Maybe over the activity table or with somehow backups?

Hello !I’d like to rename the labels of my task attributes without making any changes in the KM.Do you know if this is possible, and if so, how to do it?Thanks in advance for your help !Best regards,Cisse 

Hello, I have an issue with a large number of Action Flow connections being saved under every analyst’s account, and wonder if it is possible to remove them, so that every analyst will only have 1 connection (via their API key) associated with the Action Flows. If it is unclear what I mean, under some Action Flow module (e.g. Query Data), there is a list of connections that you can use to get the module working, which I am trying to delete and establish only 1.  

Initially I had four attempts to complete the Rising star technical assessment. I failed in the first two attempts of the first section. Now it shows 0 attempts remaining.I have competed all other sections.Please guide me how to restore those attempts.

Please help me to complete the assessment

Hello everyone,I need your help with the Email connection settings in Actionflow. For a connection that has already been created, I would like to check what settings were configured. Where can I verify this?   

Is it possible to embed an image (customer logo) in an Action Flow Outlook email body?I read the related topic “Action Flow-Screenshot of an analysis as image in a mail body” but that thread has been inactive for ~ 1yr and it does not appear it was successful. The Outlook module also has its own nuances to it (text body content vs html...).Thanks

Hey, I am curently working on creating a dashboard for employees as a view where they can simultanously write back to each line in a custom “comment”-column. Basically the inline editing function from the new Views.Sadly I want to do this for a rather large data model.  Is there a way to have inline editing or something similiar for bigger tables that exceed 30M Rows? Or can I put some sort of filter on that table in the front end to minimize the rows below 30M. Or does it have to be in the back end? Thank you!

Hi,I would like to use the new augmented attributes available in the “Augmented Attributes” section of the Knowledge Model in a legacy view.Do you know if this is possible? If yes, how can I do it? Thanks in advance for your help !

Hello All, I have a use case that is currently using Skill send Email by Celonis.However 100 mails limitation is starting to cause trouble.Using actionFlow and without using connexion and Skill, is it possible to send email from Celonis Without limitation ?If Not how to bypass this limitation on Action Flow ?

Hello,I am facing a somewhat specific problem with an Action Flow.I am using the Get rows module to retrieve, depending on the input variable, the column from one table or another. The variable directly affects the name of the table I am retrieving. No problem there; depending on the input parameter, the module behaves normally. The problem occurs in the next module, when I use the Text Aggregator to group the data according to this specific field. The name of the Get Rows module variable changes depending on the value of my input parameter. Here is what I tried to do, which works when the parameter is 1 but does not work when the input variable is 2.  

Good morning,I need to create a date filter for the start date on a graph, and the date is a user input, so I create a Date Picker as input box and save it as a variable.I struggle with the PQL in my graph FILTER PQL statement:FILTER “table”.”datecolumn” >= {d ‘${my_start_date_variable}’} But I get this error message  How do I adjust my PQL to get the date format correct? The date picker has a standard format that cannot be changed. I also tried this, and it does not work:FILTER “table”.”datecolumn” >= ({d '${my_start_date_variable}'}, FORMAT ( '%Y-%m-%d')) Any assistance will be appreciated.  Thank you,Denise

Hi everyone,we are using Object Link functionality to link Manufacturing Orders. In order to show the relevant predecessors and successors of one selected order (order number is written to variable aufnr) we filter as follows:This selects the respective order, but also all predecessors and successor orders.However, in this case, we only want to see the orders, that are created in the same plant, not from previous plants. E.g. in the following examples, the 2 first orders 1 and 2 of Plant A should not be selected, if the variable is set to Order 6.What is the best practice to filter in this case?Thank you, BR Philipp

We have a Celonis view with KPIs defined in the Knowledge Model. These KPIs use time-based filters with variables like datefrom and dateto inside the PQL-code.For example:"o_celonis_VendorInvoiceItem"."CreationTime" NOT BETWEEN {d '${datefrom}'} AND ADD_DAYS({d '${dateto}'}, 1)and elsewhere in the same KPI:"el_custom_SalesOrderItem"."TIMESTAMP" BETWEEN {d '${datefrom}'} AND ADD_DAYS({d '${dateto}'}, 1) When exporting this view to Excel via Action Flows, the Get Rows module lets me reference the Knowledge Model, but I cannot pass values for these variables.Using the Data Model instead allows variable injection in PQL, but then I lose access to predefined KPIs and calculated attributes, resulting in very complex, hard-to-maintain code.Question:Is there a way to dynamically set the variables of Knowledge Model KPIs when using Action Flows?

Hi - I am trying to write back the Variables I used in Studio View to Data Integration via an Action Flow but the attribute where I am storing the variable is showing as blank. I read Action Flows can’t read Variables form the Studio View. Is this true?