Product Q&A

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?

What is the best way to create copy of a datapool including all the datajobs

I tried it with != '' or NULL but the result was not as expected. The Result of the example attached should be: Component > Number: 2 CasesComponent > OLAP Table: 1004 / A50 and 1010 / A50  Hope you can help me, many thanks Stefan

The response of the POST call is a ticket that must be added to the header of the other calls as a session id. It seems that the extractor builder doesn't support POST calls. Is there a workout for this as authentication seems only possible by a POST?

Hi Celopeers!I am wondering what is the most convenient way to get the average throughput time between two activities based on their occurrence in a case. lets say C and D are always related to one another but can occur any time in one case: e.g. for the following 3 cases:A-B-B-C-C-C-D-DA-B-C-B-B-D-C-DA-B-C-D What is the best way to get the average TPT between each C and D based on the index in the case?so always...A-B-B-C1-C2-C3-D1-D2A-B-C1-B-B-D1-C2-D2A-B-C1-D1 C1-D1C2-D2C3-D3... I have thought of: LEAD/LAG; ACTIVITY_LEAD/LAG, SOURCE/TARGET, CALC_THROUGHPUT, ... in combination with INDEX_ACTIVITY_TYPE but I have not come up with the perfect solution yet. Thanks a lot! 

Hi Team, I have uploaded a data using parquet file in Celonis . I have extracted the data but coming to data model i want make the case table but in the below i could not see any option with case table 

Hi All, as a beginner in Celonis, I am often confused with the use of Skills and Action Flow, is there any significant difference in functionality, use case or scenario? Thanks in advance!

I've extracted all the variants that contains list of activities. In my case their are 648 variants. I need to identify which are the starting and ending activities of process. Can i assume that first activity in each variant is starting activity and last activity in variant is the last process activity that lead to 'Process End'? I've also comp up with query to create statistics between each link of activities as shown below. But i'm not sure how would i identify and calculate stats for 'Process Start' and 'Process End'. 

Hi, I am learning the celonis from the training track, while working on the creating the Account payable use case, i created the activity table but when inserting the second activity i am getting the above error so please help me where did i go wrong?  Thanks.

Hello, I had the PQL Code for Pull-Up-function in progress for many months now. This Function contains two dimensions/columns in the order by statement: PU_LAST(DOMAIN_TABLE("TAB1"."ID"), "TAB1"."STATUS", order by "TAB1"."SORTING","TAB1"."TIMESTAMP") ='Anlage'THEN 'create' A few weeks ago after adding more records to the dataset I got the following error message: Sorry! Something went wrongWe couldn't find any data for this chartPull-Up-function could not be executed PU_LAST:Only one ORDER BY column allowed, but [2] columns were specified After I removed the second Order by statement ("TAB1"."TIMESTAMP") the code works. However, ordering across both columns is still required.Was there an adjustment (function) or could it have something to do with the new data import? br Stefan 

Hello all,I was going through various packages in the celonis and i found out that there is a package called "Celonis_ml" with no other documentation. Where can we access the documentation / source files for the Celonis_ml package.Thank you

Hey Celonis world. I am trying to follow the Assistant Guided tour, but sometime it jumps and restart. is there some docs where we can do the exercises without following the assistant? Thks in advance