Product Q&A

I want to display only the sum of all (claim cap) for Parcel status that were said to be lost. I will like to use a 'Number KPI'. Please can someone explain to me how I can go about it?  

Hello everyone, I have a question about 2 PQL formulas.😅  In this case, I need a conditional that checks if it is the last record of the ID, if so, make a formula that takes the timestamp of this record and does the DAYS_BETWEEN between this date and today's date. If the timestamp of that record is not the last one, use the formula below:  AVG( DAYS_BETWEEN ("table_activities"."TIMESTAMPLE", LAG ("table_activities"."TIMESTAMPLE", ORDER BY ("table_activities".."TIMESTAMPLE" DESC) , PARTITION BY ("table_activities",."PROCESS_CELONIS", "table_activities"."ID") )))  I think it would be something like this: CASE WHEN PU_LAST ("tabela_atividades"."TIMESTAMPLE") = "tabela_atividades"."TIMESTAMPLE" --this for each id THEN  DAYS_BETWEEN (AVG( DAYS_BETWEEN ("table_activities"."TIMESTAMPLE", TODAY)  ELSE  AVG( DAYS_BETWEEN

I’m trying to configure an input checkbox component with a chart/kpiI’m not getting to configure it correctly. I’m unable to use sharefilters attribute in kpi list any help on configuring this component will be helpfulthank you

Hide Years and Months in Date Picker Dear All, I have a table which has date and records only for the Year 2022. I have used a date picker in the analysis. But while using the date picker , I do not want to see all the previous years/months prior to 2022. I understand that if I will not be able to select any date from any previous year/month other than 2022, but is there a way to not show the years and months prior to Jan-2022, while using the date picker. Thanks in Advance,JB

I’m trying to add display rules like e.g.,background colour blue and kpi value to be in white but I’m not finding a way to add this to a textbox component. It works with KPI list component and some other componentsAny suggestion to get this requirement done?

Is there a way to replace text in Action Flows?We need to remove newline characters from a string input. Currently this is being done in Studio Skills, but it would be better for our workflow if this was possible within an Action Flow. Wondering if anyone has done this. Regards,Ravi

Hi, Is there a limitation on the number of recipients possible under the "Routing rule" of Action Engine?

I am getting attached error while configuring profile view for the Inventory Management starter kit. Does any one have an idea how to pass Profile view key manually to the execution gap list component. (Profile view is available with same name in KM)   

Any best way to debug the out of the box Knowledge Model KPIs

Hi everyone,  as the title of the topic suggests, I'm searching for the possibility to connect Celonis and Marketing Cloud Salesforce. The official documentation doesn't say anything about, and there isn't a specific connector to make possible this operation. Does anyone have news of this implementation? It would be ok for me also building a custom API to retrieve data from the Marketing Cloud. Thanks in advance for the help,Regards,Emanuele

Is there a connector for IBM Maximo?

Hi All, Together with my colleagues we have started trainings in Celonis, however we are facing the issue, that the UI that we are seeing on training videos is different that the one that we see on training environment that we have established.Is there any option to change this view in training environment? Currently we are unable to follow training materials. 1) My training environment 2) Video environment: Thanks in advance for your support.

Hi, i am looking to build a histogram in a view with a KPI which gives a throughput time between 2 activities. I need the frequency of cases on Y axis, and a (automatic) grouping/bucketing of the KPI values on the x axis. I have tried to use the Histogram option in the View, but it seems not to accept KPI's (only data value columns). So i created a Record (attribute) in the activity table with the same formula as the KPI and use that as attribute in Histogram instead. But i get an Error: "Aggregate expressions cannot be nested inside aggregate expressions." Is there any other way of producing the desired result? I can use a normal chart but it will not do the buckting automatically and i don't know how or where to create an extra buckting table. Thanks in advanceHimanshu 

What is the difference between Signal and Object Links? Hi, i am investigating how to best create network graphs for a BOM and I came across the Signal Link and Object Link. I already have a basic BOM using Signal Link but as i want to use the LINK_PATH operator i now need to switch the BOM to Object Links. I'm having trouble in understanding the difference between the two and what are the pros/cons of one or the other.  Does anyone have experience using the Signals, and can expand on the differences? Thanks in advance for your insights.

I would like to identify the incidents for which the assignment group is changed more than two times. I am able to write this in SQL but need some help in converting this to PQLSELECT INCIDENT_NUMBER,COUNT(*)FROM "_CEL_INC_ACTIVITIES"WHERE ACTIVITY_EN = 'Change Assignment Group'GROUP BY   INCIDENT_NUMBER ORDER BY 2 DESCThanks in Advance

Hello everyone, has anyone experienced this in Celonis? I'm doing a date filter, but in the frontend it's bringing me an extra day, but in the database it brings the period that I filtered.Below images showing.Thanks.

Hi for my use case requires me to add a 5-10 sec delay for each iteration of the data i.e. 6000 -7000 rows i.e. (6000* 5-10 sec) I believe that adding this delay should not cross the 1 hours execution limitations. Any thoughts on the same ?

How to add concatenated column in benchmarking dropdown and filter that column with KPI's and process explorer

Can i change the font colour from a component in a analysis via pycelonis?

I am trying to create a custom KPI using Visual editor but somehow the visual editor is empty (can't access/see the visual editor option)?Any idea why this is happening?

I wanted to use the following filter statement which unfortunately doesn't work:FILTER "Table"."type" = (<%=type1%>) AND "Table"."type" = (<%=type2%>); Strangely enough, the filter does work if I replace the 'AND' with 'OR' like the following: FILTER "Table"."type" = (<%=type1%>) OR "Table"."type" = (<%=type2%>);. However, this would have the same result as an 'IN' statement like the following:FILTER "Table"."type" IN (<%=type1%>, <%=type2%>); But I need an 'AND' or an 'IN' where all selected 'types' are true and not only one from the 'IN' list. Can someone please help me with that issue?

what is celonis?

uploaded parquet file the timestamp is different how to convert into readable way in transformation using sql

Hello All, Looking for some Benchmarks in KPI's associated with Accounts Payable, E.g. What is the Exception % Allowed generally?, What would be Automation Rate at? First Time Resolve / First Time Yield %? Any leads will be helpful.