General Product Q&A

Hi @ALL i try to do smth like this. one dynamic filter should execute the NULL values in the table. FILTER "table". "column" = CASE WHEN <%=option1%> = 'abc' THEN NULL END; all other filters work but i cannot return null values from the same table. I have tried this formula  FILTER "table". "column" = CASE WHEN <%=option1%> = 'abc' THEN Filter_TO_NULL("table". "column") END; but when i have tested, i realized that i did bring up all values but not Null values from table. Does anyone have an idea?

Hello, I am trying to modify an Action Flow by adding a column to the final result which is a Gsheet file in shared drive but although the query seems modified in the Action Flow, the final resultat in the Gsheet is not. I have save and published.

Need help woth pql code. For example, in a particular 1 hour the count of activity is 89 or 56 or 05, then that count has to be considered as 1 How can I achieve this? ​

I have been provided data in a parquet file, and the activity names are quite long and verbose. What's the best approach to editing the activity names to make them more intuitive/user friendly?

I am revisiting this issue because my new approach did not work properly. The Case I'm trying to program is:  I have two OLAP tables where one table filters (component filter) data with:(DATE < TODAY()) and the other has the component filter:(DATE > TODAY() AND DATE < TODAY() + DAYS()).  My aim is: Column 1: Material NameColumn 2: Material NumberColumn 3: The KPI of the Material as a whole from the OLAP Table 1 which is a Detail Table of all Materials The filter is only a simplified representation of the code. In summary, I have one table that looks at dates from the past and one that looks at dates from the future (future orders/deliveries). However, I now want to connect KPIs from the table that maps from the data from the past on the table that looks into the future.  For example, if I have the sales of a material from day 1 to today (past until today), I would like to be able to display that as additional info for the future orders of that material (considered the pas

I have a button dropdown, where I've different inputs like: EINDTSLFDTMENGENETPR  Separator : ,I'm wrapping with:start = 'end = ' My variable I'm writing into is changeFields So I did a KPI where I'm using this case when: CASE WHEN <%=ChangedFields%> = 'Lieferdatum (EINDT)' THEN 'EINDT'WHEN <%=ChangedFields%> = 'Stat. Datum (SLFDT)' THEN 'SLFDT'WHEN <%=ChangedFields%> = 'Preisaenderung (NETPR)' THEN 'NETPR'WHEN <%=ChangedFields%> = 'Mengenaenderung (MENGE)' THEN 'MENGE'END THe problem is, when I'm using more than 1 input my CASE WHEN state the project doesn't work.  I tried it like:  WHEN <%=ChangedFields%> = 'Lieferdatum (EINDT),Stat. Datum (SLFDT)' THEN 'EINDT,SLFDT' But this idea doesn't work. I also tried to do it with logic gates. Does anyone have an idea how I can filter multiple inputs and check it in a case when function?

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.)