Product Q&A

Saw a similar post from a few years ago but believe my question is slightly different. I want to write PQL that calculates the difference in days between the time stamps of when a "Next Status" was entered. The image is an example of what my raw data looks like and the column in yellow is what the PQL would help calculate. 

Hello Everyone,Can we apply a filter only for certain KPIs in a table component. Different filters for different KPIs.

 Hey guys,We are trying to export tables from SAP Ariba via API Supplier but we are receiving the return below message in Celonis extract Has anyone experienced this problem in this extraction?. Has anyone had this problem and could help me? Reached Supplier Data API limit waiting for 1 seconds. Current rate limits are;---X-RateLimit-Limit-day: "25000"X-RateLimit-Remaining-day: "24935"X-RateLimit-Limit-hour: "4500"X-RateLimit-Remaining-hour: "4435"X-RateLimit-Limit-minute: "150"X-RateLimit-Remaining-minute: "86"X-RateLimit-Limit-second: "3"X-RateLimit-Remaining-second: "0" 

Hello, the blue part is supposed to interact with filters that are applied to the entire view and change according to those filters. The green part is NOT supposed to interact with the filters and still stay with the same values.  Is it even possible to make the green part still with the same values and not interact with filters across the view? Note: The blue part is status 1. The green part is status 2. E.g. when I change the filter on April blue part changes values but the green part disappears because the values of the green part are only on the actual month. I'd like to blue part to show other months and the green part only the actual one even when I filter across the view.  

Hi, I need to determine the Cycle time of each activity that is not fully automated to determine the impact of not being fully automated. The Cycle time must be from the activity before the specific activity to the activity after the specific activity. How can I do that without specifically referencing the activity - hence 1 PQL that can apply to all non-fully automated activities.  

We would like to move to KM usage, but we have a lot of legacy analysis to be linked to KM. Ideally we would like to develop a code that could update reference from local KPI to KM kpi? E.g. from KPI("CT AVG") to KPI("CT_AVG").  I can identify approximate cases where update needs to happen, but I cannot really find if it is possible (and how) to do the update of KPI name in the component itself.

@Sophia Stephenson​ @Brian Dees​ 

Constantly users try to request access to our app portfolio via the Marketplace. (Maybe they didn't notice the "Apps" section and think specific access needs to be requested in "Marketplace" ...)    This will help new business users to focus on the important content and reduce the email notification (spam for admins) about new app requests from users.

Hi, can you tell my why my training version of Celonis have "Object and Events" and "Task Mining", but my production version does not have them?

want to read the file through machine learning, could you please help me

Can anyone please help me with PQL code to get Plant(WERKS) in MARC for the invoices (BELNR) in the table RBKP , but there is no common field between them so directly cant find so need to use RSEG which has common fields for both the table ,

Can anyone help me with the PQL query to find the Plant (WERKS) for each Invoice using BIND function as Plant is present in EKPO which doesnt have 1:n relationship with RBKP and RSEG is the only common table between EKPO and RBKP ?

Hello Community,I want to view the value of a KPI on monthly basis (Not in form of a chart). How can I partition the KPI value for different months in a year.

Hi all, I would like to show a celonis demo to Japanese member so I'm looking for it but it dissapperared. (I think there is some japanese demo in try celonis but not right now.) Does anybody know about this and let me know if you can find it.Regards, Tatsuya, Suzuki

@sverre.klein11​  Hoping you can help on this question.

Hi, I can't see the solution here. Can someone give me a hint? is in the Value Realization course- Manage change & scale adoption 

 I have a table that I am doing an extract of last 1 year. Once the extract is complete, there is 1 column in it (let's say invoice number) that had some activity occurred for it few years back. I am trying to do a second extract of the same table where no date constraint is in effect but using invoice number column values in "Additional Filter" condition.Steps Performed:Extract table data for last 1 year.Create a dummy table to save invoice number column values in it.Create a list parameter to save all those invoice number values in it.Try a second extract of same table without "Enable creation date filter" condition.Use the parameter value in Additional Filter condition (Invoice IN <%=hist_param%>. I am getting an error in the second extract "ORA-01795: maximum number of expressions in a list is 1000".Its an on-prem extractor in use. Any help would be appreciated.

How can we calculate the average throughput time per unit without errors? ーーAVG(   CALC_THROUGHPUT (    FIRST_OCCURRENCE [ '伝票登録画面表示' ]   TO FIRST_OCCURRENCE [ '伝票保存' ]   , REMAP_TIMESTAMPS ("t_Activity"."日時", MINUTES ) ) )ーーーーErrormessage​ーーThe aggregation function AVG is applied on a column from table "t_Case" which has a 1:N relationship to the common table "t_Activity". This means that one input value can contribute to the aggregation result multiple times. For more information search for "Join functionality" in PQL documentation.ーーErrormessage​ーー 

Hello, how to set up the connection to sharepoint through action flow? While registering the application what should be the redirect uri? The one which is mentioned in the celonis help documentation is not working.

Hello everyone, the following KPI is implemented within a view:  Safety Stock / Sum Demand of the next 12 M (= Coverage Range [Years]) This coverage range is visible within a table in the view. I now want to incorporate the KPI as a filter. I created an attribute on the basis of the KPI:  My Celonis users now want to filter the coverage range individually e.g. >0.5 and <0.6 or >1 etc. In Excel this is very easy to do. Does this also somehow work in Celonis?As of right now I can only select the possible values from a list and without some intelligent clustering. Thanks! Best regards,Julia Bauer

Hi All,How can we clear View selection in 1 click? This is fairly straightforward in Analysis, where it is possible to create a button component that will 'Delete selections'. I find no such equivalent in Views. To add some context, we are creating views that integrate several KMs, which we'd like to separate by tabs (tab1 for KM ABC, tab2 for KM XYZ). The problem is that selecting on tab 1 will apply the filtering for the entire view and all KMs.  if the table.field (item creation date) i'm am filtering for is present in both KMs, then both KMs will be filtered for that selection, even though the filtering is only relevant for KM ABC. This will lead to misunderstandings. Ideally, i would like to create a view that upon clicking on a tab selection will clear the user selection. Is this doable?

Hello Dear Community, I'm trying to write PQL query that will return Material Numbers which are ordered on both active Scheduling Agreements and open Purchasing Orders in SAP.  Do you have any suggestions which PQL functions will be suitable for that? I've attached example with the input/expected output. Thank you! 

Hello All! Hope you all are doing great!We are working on a use case for which we are using Sap Concur connector available in Celonis market place. Wanted to check if anyone has used this connector.What is the method of extraction is uses? For now what I have seen in the connector settings, it seems it is using API. Could anyone confirm it. Regards,Tapan

Hi. I'm a new user, while I created the account / login incorrectly created as 'Guest' it is supposed to be 'Partner'. In the same I have completed welcome kit and Foundation. I planning to undergo certification. I need help to change access to Part