Product Q&A

Hello all,i have the issue that I want to join two different tables based on a time filter. Table 1 describes different materials going to different Targets with an exact event-time.Unique-ID | Eventtime | Target 1|Unique-ID | Eventtime | Target 2|Unique-ID | Eventtime | Target 1| Table 2 is a status-table which is updated in irregular intervals (Date_1, Date_2, Date_3..) and contains for each Target a string with either Mode_A oder Mode_B.Target 1 | Date_1 | Mode_ATarget 2 | Date_1 | Mode_ATarget 1 | Date_2 | Mode_ATarget 2 | Date_2 | Mode_BTarget 1 | Date_3 | Mode_BTarget 2 | Date_3 | Mode_A I now want to join table 2 into table 1 and match the Mode-A to each unique-ID based on the condition, that the Eventtime is between the respective Date-Intervalls.  Any Idea how to solve this?

How can we create process models, using BPMN2.0, with Celonis?

Hi team Can any one explain me about the difference between aris process mining tools and celonis tool what features we have in celonis better than aris..

Hi everyone, Is there a way to find out the value that appears most often in the dataset? I could not find it in PQL references. Example Values in a Dataset2221035 In this example, the value 2 appears most often.  Looking forward to your replies. Many thanks and best regards,Thorsten 

Hi, I am trying to utilize Ratio of cases with certain process flow KPI, however I am permanently getting values which do not make sense to me. In attached pictures you can see, there's 221 cases out of 13943 which goes from V stage to V stage (about 1,6 %). However, when I try to get the ratio of such cases using KPI I get result 2,1 %, which is from my perspective incorrect. Any idea what is happening there? Tomas

I have created an OLAP table with a dropdown button where I can select dimension and I have linked the outcome of the conformance check by using:  READABLE (<%= conformance %>). I put a filter on it so that it doesn't include "Conforms". However, it now lists all deviations and I am only interested in the top 3. How do I limit it to only show the top 3 deviations per result?

Hi, in our celonis_integration PostgreSQL DB, we can see 4 different status (cpm_status) of data jobs: "ERROR", "NEW", "RUNNING", "DONE". I would like to understand what does status "NEW" mean? Can anyone help? Thanks!

I have a query regarding sending reports for critical KPIs using transformation center. I tried to navigate through transformation center but couldn’t find any such option where I can scheduled reports.  even tried to check help support section of Celonis Below screenshot is perhaps of the older version of transformation center which is there on the help page.   It seems older version of transformation center was having different interface and there were these option of sending weekly, monthly or daily reports.  Note : There is a possibility to use the Action Engine to create reports but would prefer to use the report function of the transformation center.  Any help will be appreciated.

Hi,Is there a way that my filters from one dashboard can also be applied to another dashboard? For example, in my first dashboard, I filtered 2-3 dimensions and now I wanted to analyze in another dashboard those dimensions again. It could be placing a button to navigate to the link in the 2nd dashboard, but the selections filters are left behind in the 1st dashboard.

I have a column chart component which displays for each status(activity) the number of cases for which this activity is the last per week. So in dimensions I have this kind of expression ROUND_WEEK("ACTIVITIES"."EVENTTIME") but I want to display for each week for each status(activity) the number of cases for which this activity is the last and from a week to another I want to sum the cases which have not moved to another activity. Is there a way to do that, so in dimensions I want to have a kind of calendar of all weeks and then according to the date of the activities I want to display what I explained above. Thanks in advance for your help !  

Hi there, intuitively I would have thought that this checkbox selects values that are NULL but this was not the case when I tested it. So what does it do? Kind regards,Sasa

Dear Celopeers, On November 4th 2021, we are hosting our next Webinar on how to Kickstart your Action Flows with Use Case Templates! This is the third part of our new series of Webinars. The session will coverAction Flow use case templates: What they do, where to find them (presentation)How to install & combine templates (live training)Where to find further material (link to resources)Q&A (live)FAQ (live, gathered from previous session) You can directly register here!

hi, I would like to calculate number of cases that have some particular throughput time. I want to divide total number of cases for the cases that happened in less than 4 days and for hose that happened in more than 4 days. I tried to use avg but it calculates for all of the cases and put them all in one column. To be clear: there are cases with status "Closed" that have TT<4, but in the table I have 0 there (in column case count where TT<4)

Hello All, Is there any way to get the sum of the Throughput time other than what is there. For example want to group by with some activities, the throughput only available for the avg, median and mean. If we can get the sum of the same. 

Hi everyone! I am trying to find out if it is possible with Celonis to do calculations based on sentences in comments or notes. I am analysing a process where there is an attribute called "comments", where the operator makes a description of the task he has performed. I want to know if it is possible to analyse this text with some formula, for example, to know which are the most frequently used words.  Thank you!  

Like the Title says, I have 18 Queued Executions of a Studio Skill that have been pending for 30m Here is a picture of the flow: Does anyone know how I can cancel / restart?It was running fine when I had just a couple of columns being written to the table, I've since added a number of columns and changed the Table Name  Thank you in advance!

What is the maximum number of rows we can export from any OLAP irrespective of the maximum rows we provided in the setting.

Hi everyone, I set up a bpmn model for my conformance checker, but the gateways does not seem to work. Example: Here I can see, that the movement from "Erstanlage Schaden" to "Manuelle Deckung geändert" is possible. However when i look in the Conformance analysis it lists "Erstanlage Schaden" followed by "Manuelle Deckung geändert" as one of the most common violations.   Any ideas what i can do about it?  Best,Maria

Hi Team, I'm trying to build a KPI shows which column data has wrong fields. I'm using the KPI syntax as below but it is not working. Could you please help me on this case.CASE WHEN LEN ("TableA_xlsx_TableA"."Name") > 4 OR ("TableA_xlsx_TableA"."Name") IN_LIKE ('!','@','#','$','^','*','(',')','-','_','+','=','{','}','[',']','|','/',':',';','"','<','>',',','.','?','[%]') THEN 'Name, ' ELSE '' END ||CASE WHEN ("TableA_xlsx_TableA"."Country") IN_LIKE ('!','@','#','$','^','*','(',')','-','_','+','=','{','}','[',']','|','/',':',&#39

How to use OR in numerator and denominator while writing KPI in ratio format

Hi there, our client hast 20+ activities that she has to drag and drop into the activity selection. Is there a less tedious way of doing this? One solution would be to create a new activity during the transformation step in the Event Collection.   But is there another way in the Process Analytics? Kind regards,Saša   

Is there any way to integrate/add checkbox or any indicators into an OLAP table in an analysis ??

I want to get only numeric values from the column. I'm trying with the syntax '%[^0-9]%' but it is not working.

How can we extract execution logs such as transformation script logs from front end.

Hello, I would like to know what happens if you stop the execution of an extraction task. Will the data extracted until that point be removed automatically or you should do something to remove it?