Product Q&A

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 formulas workHere you can see the desired structure, with S

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 (           "_MAN_QUALITÄT_CASES" ,           "vw_IPM"."AFO_Nummer" LIKE 'bb_%' AND           "vw_IPM"."Status_Verschraubung" = 'i

Has anyone had experience in integrating Genesysis, telephone contact center software (https://www.genesys.com/)?There is no connector, there is no extractor, and Genesys does not store data in an externally accessible database. Has anyone had any experience? How did you establish the data connection to the source? Thanks

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?

What is the ratio for the process deviation “Maverick Buying” for the material “Leather bag professional”?

Let's look at the code JOIN MERGEJOIN (inputs presorted) [Cost: 750, Rows: 1200] (PATH ID:1). What does the number 750 represent? A. The total cost of sales items in this joined dataset The exact known cost of the query runtime C. The estimation cost

Does someone know how to code dynamic happy path in the PQL? You know there is a dynamic happy path ratio in the process overview. Can we show the happy path gauge in the sheets by discovering the code? Can you find most frequent process variant in pql?

Hello,  I've just by accident went into Integromat website, and seen that it has been transformed into new product "Make". Unfortunately I couldn't see any official Celonis communication about that. In FAQ secion I've also seen that it will be treated as legacy product, and support and updates will be discontinued in 2023.  As Integromat is a part of Celonis in a form of Action Flows, could you kindly describe how that change will affect Celonis Action Flows environment? What's your strategy on that? Best Regards,Mateusz Dudek

Hi everyone! I need to build an action flow which will send an excel file attached, I followed the steps on the documentation, but I am getting an error and I am not sure how to solve it. I took step by step on the process.... Any advices? thanks a lot

in E2E there are some data missing like i found the data in OMS but i didn't find them in E2E ?

Hello! I wanted know if anyone was able to successfully have a Hubspot use case, I am currently in the middle of creating the tables for Celonis, but I wonder if anyone else did it before me. 😎

Hi Group! Wondering if Celonis has a connector for SAP Business One. Regards, Victor

What do you know about the term “Big Data”?

On the X axis, I have Hours (event. timestamp)On the Y axis, I want to have a graph with the maximum amount of cases that have happened. but on a day. ( So for example 1-01-2022 at 9 hours the count was 10 and on 2-01-2022 at 9 hours the count was 30, I want the output for 9 hours to be 30)  At the moment I use this to calculate the averageCOUNT ( DISTINCT CASE WHEN "eventlog_T1"."ACTIVITY" = 'activity'' THEN "eventlog_T1_CASES"."cases" END )/( COUNT ( DISTINCT Round_Day ( "eventlog_T1"."TIMESTAMP" ) ) ) Does any one has a suggestion how to get the maximum value on a day per hour

Using the skill "Email by celonis" when I select a line item it sends an email for each line. Is it possible to aggregate several selected lines and send them all in one email?

I am trying to create a formula to calculate the total of all invoices for a vendor (but not yet cleared) when an invoice for that vendor is posted. I am using SAP data, and trying to calculate using data from the BSEG table. I am displaying this total in an OLAP table in an analysis. I am passing in the posting date of the current invoice as a parameter ({p1}). The result displayed is the vendor invoice total for all invoices, for all records. PU_SUM("LFA1", "BSEG"."WRBTR", ("BSEG"."BUDAT" <= {p1}) AND ("BSEG"."AUGDT" >= {p1})) The Vendor Master table (LFA1) and the Invoice Line Item table (BSEG) are linked in the data model via MANDT (Client) and LIFNR (Vendor ID). Whatever help you can provide would be greatly appreciated.

Hello, I'm trying to do an analysis where I require the item data from delivery notes ( LIPS table), however for some reason in this specific table I have no information regarding items with delivery type = HOD, NL, and NLCC, only LF and LR appear. I checked all analysis filters and found nothing. LIKP table has HOD, NL, and NLcc information and so do VTTTP and VTTK.Can someone tell me what the issue might be? Thank you

The 'Create CSV' module allows you to specify which columns will appear in the CSV file by selecting them in the 'Aggregated fields' I would like to know how we can rearrange the columns of the Create CSV module (e.g. 'Document type' is always the first column output in the file, would like to move this to the 5th column)  The Create CSV file also will show commas ( , ) instead of decimal places when showing a calculated field (e.g. Throughput Time column in the Create CSV file shows 35,29 days instead of 35.29 days - I cannot see a way to alter this)

What's the correct setup for Replication Cockpit if we want to filter based on a date column for the initialization and the date column is in the table itself (There is no join). For example UDATE >= ''2023-02-27' did not work expected.