General Product Q&A

Dear community, I am using a formula to compute some KPI (based on the shown table), which is (SUM(PU_COUNT_DISTINCT( DOMAIN_TABLE("S2A_AKTIVITAETEN_DETAILS_xlsx_Sheet1"."CASEKEY","S2A_AKTIVITAETEN_DETAILS_xlsx_Sheet1"."EVENTTIME"), "S2A_AKTIVITAETEN_DETAILS_xlsx_Sheet1"."AKTIVITAET","S2A_AKTIVITAETEN_DETAILS_xlsx_Sheet1"."AKTIVITAET" = 'Eskalation durchgeführt')))However, using this formula for a type chart and a column chart, I receive two different results.The type chart correctly counts the unique combinations of the columns casekey and eventtime for column aktivitaet with value "Eskalation durchgeführt", which is 8.Meanwhile, the column chart does not only count the distinct values, but all, and therefore returns a 10 (dimension is round month, which should not be important, as all table entrances result from the same month). Does anyone know why the column chart does not solely count

For eg., I want to represent the avg kpi as one of t​he kpi in a column chart and makes it static so I can basically see a straight horizontal line to the dimension to compare which dimension value has achieved the avg.

Now I'm looking for data connector template from SAP to celonis.Do we have something pre-fixed data connection template for basic SAP module? if yes, please let me know where to find it, or do I really need to build something RFC setting in SAP from the first step?

I would like to show the changes of figures comparing to the previous period, I think of ways like through defining multiple variables with date input, is there a more convenient date in doing that? thanks!

where do I go to enroll in a certification exam?

How can I set conditional filter in load script page? I have tried Case When, but it gives me error. Is there anyone who has suggestions? Filter "xx"."yy" = <%= option1%> (it works)  i want to do multiple conditions like that in component filter case when <%=option1> = 'a' than Filter "xx"."yy" = 'value' ;case when <%=option1> = 'b' 'than Filter "xx"."yy" = 'value2' end  Is there any way to add conditional filter in the component filter section?   

Hi, I have built three KPIs that calculate throughput times. Lets say: KPI 1: 20 hoursKPI 2: 30 hoursKPI 3: 40 hours.  Total: 90 hours. I would like to make a simple pie chart with all three of them in it. KPI 1 showing 20/90, KPI 2 30/90 and KPI showing 40/90.  The KPIs are calculated through different formulas.  Anyone knows how to make this simple chart?

I currently use this load script: FILTER MATCH_ACTIVITIES( "_CEL_P2P_ACTIVITIES"."ACTIVITY_EN", EXCLUDING_ALL ['Record Goods Receipt'] ) = 1 But as far as I can tell this is only item level, so POs that have any item in which "Record Goods Receipt" doesn't occur still show up. I want to exclude any purchase order that has "Record Goods Receipt" anywhere in the process of any item in the PO.

Hello everyone,I would like to get the variation and percentage variation of a KPI generated in a Knowledge Model.I would like to know if there was an increase between the last value of the KPI and the value of the previous month.I can't think of a PQL to do this, anyone has an approach? Thank you.

Any idea on how to counter this?

Am trying in my Studio but nothing is getting updated or showing.

Hi - I tried executing the action flows named "Creating CSV file from Celonis output". I am not getting the results as mentioned, instead of this I am getting output as a direct values separated by coma (,). The result I am getting is given belowbut the result should be in the form of file as shown below.Kindly help me to fix this.

How to check whether after a certain activity , a transaction has occurred or not ? ACTIVITY_EN is the activity field and EVENT_TYPE is the transaction field

Dear Experts, I would like to calculate the percentage of stock out days that were longer than 5 working days.  I have a table with the information of SafetyStock and a table with the daily stock-level. Any ideas? Thank you! 

Hi, As an analyst, I want to exclude from the analysis pairs of invoices that have resulted in a credit note / (canceled invoices) Can you help with PQL query? Thanks,Guilherme

Hi - Actually I was trying to upload a flat file in file upload to analyse the data. After uploading I am facing some errors. I am attaching the screenshot of the error for the reference please let me know with the solution

Hi everyone, to show a graph with how many goods were not sent to customers (yet) on a specific date I followed the instructions of this example for filling ranges (Link). Dimension:RANGE_APPEND(ROUND_DAY("_CEL_O2C_ACTIVITIES"."EVENTTIME"), '7D', {d '2021-01-01' } , TODAY ()) KPI:RUNNING_TOTAL(SUM(CASE WHEN "_CEL_O2C_ACTIVITIES"."ACTIVITY_DE" = 'X'THEN 1 WHEN "_CEL_O2C_ACTIVITIES"."ACTIVITY_DE" = 'Y'THEN -1ELSE NULL END)) However, goods may be sent or received in multiple deliveries, thus leading to repeated activities.  1st Question: How do I only consider the last activity (and respective timestamp) per case?  2nd Question: How do I properly include this additional check, ensuring that all goods are actually sent out? (CASE WHEN PU_FIRST("VBAP","MSKA"."VBELN" || "MSKA"."POSNR","MSKA"."KALAB" > 0 OR "MSKA"."

Is it possible to change the timezone setting on Celonis or should it be done at a transformation level?

Hello experts, What kind of connections specific set up/configuration is needed on Celonis to Azure Data Lake file structure (currently data resides at the file structure level and probably at the Hive tables too and not in Azure SQL.)

how can i connect to db2 premise and db2 cloud. when I am trying to do giving me error

I created a PULL UP function as mentioned below PU_SUM(DOMAIN_TABLE ( "PR_CASES"."CUSTOMER_NO" || "PR_CASES"."CUSTOMER_NAME")  ,  CASE WHEN "PR_CASES"."CREATED_BY" = 'WF_PDP011' THEN 1 ELSE 0 END)This is to get the Total Automatic Ticket Creation per Customer. However, on trying to filter the column based on date picker field ("PR_CASES"."CREATED_AT"). It was observed that the PULL up function is not getting impacted and the value remains the same.Kindly suggest how to resolve this. Thank you in advance :) 

To protect client data, can I pseudonymize some credential data outside of Celonis before loading client-approved data into Celonis Cloud?

Hello everyone, for my current Usecase i need to upload a parquet-file (that is stored locally), to the data pool via File Uploads. When the file is uploaded i need to execute the referred datajob. The last step would be to press "Force Complete Reload" inside the Process Data Models Menu. These are all manuell steps. Is there a way to automate the whole process? best regardsAndreas

what is the PQL formula to find the rework time? for eg : we have the activity name as the dimension and i want the first occurrance of that activity to last occurrance of that activity (rework time) as the kpi in the OLAP table please help

Hi, I have a client calendar with their working days uploaded to my data model in a SAP TFACS format.  This TFACS table is also added to the model but not connected to any other table. I have done a complete reload properly already. When I go to my analysis and see the throughput time, it didn't change, even if I put all the working days to "0" in the TFACS table. It seems that isn't tacking into account my calendar. How can make it works in my analysis? Do I have to use functions to make the analysis use the new schedule?  Many Thanks, Paula.