General Product Q&A

Hi there, I have the following table:  We got for every part diffrent timestamps with a specific work done there. I would like to calculate the date between the installation and removal date. The problem ist, that for one part there can be historical data with multiple removals and installtions (like you see in 'Y'). Here I would like to calculate the difference by taking the installtion data followed by the date of the next removal.  I tried the Lead Function: DATEDIFF(DD, (Lead ( ('DATE'), ORDER BY ('DATE' DESC), PARTITION BY ('PART', 'WORK'),1)),  (DATE) ) The problem here is that this function calculates only the days between the removals.Do you guys have any idea how I can get the dates between the installation and removals date

Hey everyone, I keep on struggling solving issues on Celonis and not being able to find questions related to my topic here on this website or online in general. Often quite "basic" questions or at least advanced ones where others probably were also stuck at that problem. Celopeers is really great but we all know the downsides of forums. Just look at the SAP documentation and help online. It is really hard to get things done efficiently. Programming languages have Discords, other forums and community hubs. Celonis is, compared to a programming language, obviously way smaller (community wise). But is there anything else similiar to Celopeers or e.g. a simple discord server for Celonis? Or any interest in creating such thing for faster and easier connections among celonis users. Including an easier way to help others and learn. I just dont want Celonis to be SAP 2.0 in terms of knowledge transfer.  

Hello Celopeers.  I have a variable that is a list based on a dropdown component.The end result looks something like this:'0014','0191','0311' Now I want to pull a specific value from this variable.Problem is, that any function calling it is either pulling only the first value, or doesn't really give me the value I need (in this case a second or third value) Examples I tried already:1.Input:<%= VARIABLE%> Output: 0014 2.Input: RIGHT(<%= VARIABLE%>,4)Output: Error, Operator 'RIGHT' requires 2 inputs but 4 were provided. 3.Input: CONCAT(<%= VARIABLE%>)Output: 001401910311 4.While combining the RIGHT or LEFT with CONCAT might be able to be helpful enough with some tweaks if the variables had all the same length, they have varying length. some being 4 characters long, some up

Unfortunately, we couldn't find any documentation that explains how to send the data from a .xlsx file into a param in the HTTP module, the documentation that Celonis provides only explains how to push data for a CSV file into the datapool directly. In our case, we want to send the data of the .xlsx file to Machine Learning workbench to create a table that we can send to the data pool, but we don't know how to include the data of this file into the params in the request content from the HTTP Module. Does anyone know how to do that?

Dear Pablo, Apologies for the late reply as I've lacked access to my celopeers account for the past couple of months which just today got restored (most likely through my colleague Thomas' ticket, although it seems to have been reset from scratch). Unfortunately, the issue persists although we haven't gotten any closer to the cause or a possible solution, see case 00278943. Sorry, again, for not having replied sooner. I received the emails on celopeers' behalf but literally couldn't log in at all regardless of method, nor was I able to reset my password (no mails came through). BR,Bogdan Saroi

When I put only formula for 'no-touch' rate is shows correct value (if 1 out of 3 cases meets criteria then it returns 33%). But if I add no of activities (total: 37) it changes to 46% (calculates no of activities within case that fulfils criteria and divides by all). Any tips how to come up with no of activities (37) in column A and correct ratio per case (33%) in B? Thanks in advance for any guidelines. *** AVG( CASE  WHEN PU_COUNT("VBAP","_CEL_O2C_ACTIVITIES"."USER_TYPE","_CEL_O2C_ACTIVITIES"."USER_TYPE" IN ('A','B','C')   AND "_CEL_O2C_ACTIVITIES"."ACTIVITY_EN" IN ('X','Y','Z')) = 0    THEN 1.0  ELSE 0.0 ***Case A # of Activities No TouchA 17 yesB 10 noC 10 no 

Hi All,We have few use cases where we want to do task mining quickly and show results.What all use cases you have used Celonis task mining are there other better tools to do it

I have two log tables, Tables A and B, that are in n-type connection with my main table (the Case table), i.e., the Case table is 1: n type relation with Table A, and the same with Table B. As log tables, Table A and Table B record certain activity, whereas Table B records others. I need to identify activities that are repeated by merging the data from Tables A and B at the process analysis level. Requesting advice

Hello.I'm Ishizuka. How and where can I modify it to avoid module timeout errors? What is the cause? My guess is that the error occurred because there was so much data extracted in the "SELECT" statement of the query that it almost exceeded the one minute limit.---------------------------------------Error SummaryError details (example)

Hello everyone, I have set up an AF that sends data to our purchasers and also sends the data via a HTTP module to a Webhook: About 6.5k data rows will be submitted in the queue of the webhook AF and will be pushed to a table in the data pool every 2 minutes (300 data rows per execution). At the end of the run of the AF, the table in the data pool does not contain the same amount of data than the data (deviation to 6.5k). Hence, I was guessing that some execution did not work correctly. When looking at the executions, this was confirmed - some executions have this error message:  I tried filtering these executions by adding the BREAK module (with Filter for status code 400 - to stop the execution and store it in incomplet

1- The AF is running quite ok, but the email is being sent a lot of times, I need to send it out just one time, not sure what is causing it. 2- I need the price to be reflected in USD currency, but when the sheet is being filled, the currency is being set to euros. Can anyone advise? thanks a lot 

Hi celopeers!I would like to know if any of you when implementing a solution using an Action Flow have used any framework to ensure its lifecycle. I mean what steps have you followed to build, test, release to production, monitor and manage the changes of an Action Flow? Thanks!

In the latest project, an OLAP table was employed, featuring distinct attributes for each individual case. Certain attributes are not universally applicable across all cases. We know that Celonis automatically inserts "-" in null values; however, we aim to modify this default value to "no information." Despite attempts using functions such as coalescence, case when is null, case when isnull(), none of these methods have proven successful. Could you kindly suggest an alternative approach? If additional details are required, please feel free to request them. Thank you for your assistance.



Hello everyone, in the data model purchase requistions, I want to add the EINE to this snowflake (with join with EKPO). However, when setting up the join with the needed keys the DM does not load with following error message - what does this mean? Thanks for your help! BRJulia Bauer

I have calculated two KPIs. Both work and give me a result per each case. Both calculations use the source / target function and they calculate for different status the total time. When I try to substract or add the KPIs i get the following error message. I can't even use them in a chart when using the average of both. Why? ERROR MESSAGE:No common table could be found. The tables [<Temporary table: SOURCE/TARGET configuration _CEL_SF_ACTIVITIES,REMAP_VALUES ( "_CEL_SF_ACTIVITIES"."ACTIVITY_EN" , [ 'Set Status to Information Received - Email' , 'Set Status to Information Received - Email' ] , [ 'Set Status to Awaiting Customer Information' , 'Set Status to Awaiting Customer Information' ] , NULL ),ANY_OCCURRENCE [ ] TO ANY_OCCURRENCE [ ]>] and [<Temporary table: SOURCE/TARGET configuration _CEL_SF_ACTIVITIES,REMAP_VALUES ( "_CEL_SF_ACTIVITIES"."ACTIVITY_EN" , [ 'Set Status to

Let me know if anyone have implemented this outlook extractor and what kind of output I can expect from this extractor?

As a software/saas provider, how do we become a tech partner to Celonis?

Hi Everyone, I have exported my data pool as a .json file but I have not found a way to import it via a button in Celonis. Is there a solution to import the file into Celonis?

Good morning,   I am using Celonis Free Plan and I want to share my analysis with other people in the organisation. The problem is that they can only see it when they have "editor" permissions. I would like them to access it with the Viewer role, but when I give these permissions nobody can access it.   Another question, is it possible to download csv or excel with the Free Plan?   Thank you very much in advance.   Best regards, Pedro.

We are analysing a contract cancellation process and I would like to calculate the average throughput time between the cancellation notice and the first customer touchpoint per touchpoint. Different activities can be the first touch point, e.g. the cancellation confirmation or an outbound call. I would like to know the throughput time per touch point, e.g. "in cases in which the first touch point is the cancellation confirmation, the average time between cancellation notice and cancelation confirmation is xy"Some additional info:The process does not always start with the cancellation notice. There can be touch points before the cancellation notice, that we want to ignorethere can be several cancellation notices in one case; we want to start calculating the throughput time from the first notice. If there is another cancellation notice it is a customer touch pointWe are working with an on prem solution, so not all pql formu

Given a set of process data that determines a time in process using pull up aggregation, I would like to generate the different time in process averages for an attribute for 1st quartile, 2nd quartile, 3rd quartile, and 4th quartile attributes. Remember the average time in process is calculated via pull-up aggregation, which I believe means I can't run pull up aggregation on it again. I tried to research Domain Tables, but I wasn't sure how to apply them here. see image for example:        

CASE     WHEN        BIND_FILTERS (           "_Q_CASES" ,           "vw_IPM"."AFO_Nummer" LIKE 'aa-%' AND           "vw_IPM"."Status_Verschraubung" = 'niO'       )   THEN       'niO'    WHEN       BIND_FILTERS (           "_MAN_QUALITÄT_CASES" ,           "vw_IPM"."AFO_Nummer" LIKE 'aa-%' AND           "vw_IPM"."Status_Verschraubung" = 'iO'       )   THEN       'iO'     WHEN       BIND_FILTERS (           "_MAN_QUALITÄT_CASES" ,           "vw_IPM"."AFO_Nummer" LIKE 'bb_%' AND           "vw_IPM"."Status_Verschraubung" = 'niO'       )   THEN       'niO'    WHEN       BIND_FILTERS

Hi team,  I am trying to create a Stacked Bar chart. I would like to see label points aligned according the stacked bar. Instead, I see that they are not properly aligned.FYI screenshot with YAML and visualization for reference.   I am also including screenshot below (expected behavior of chart)  This works the same with split by too. Therefore, kindly requesting to guide me with relevant code snippet to achieve the above request. Thank you :) Best Regards,Shravya B

It is indicated in the Celonis Academy that "As an improvement action, you might choose to implement Celonis Machine Learning and Action Flows". Do you know any other option for improvement actions when improving the business value?