Process Analysis

Hi everyone, I would like to add a line with a count all requests with a closed date not null by month on my chart. image.png1215225 17.9 KB I tried with this formulation but it is not working: CASE WHEN name_table.closed_at <> NULL THEN COUNT_TABLE(name_table) ELSE 0 END

Hi everyone, I would like to add a line with the number of the closed request opened in a month. image.png1215225 17.9 KB I tried with this CASE WHEN rm_enhancement.closed_at <> NULL THEN COUNT_TABLE(rm_enhancement) ELSE 0 END but it is not working. Someone had the same issue with a count with a case? Thanks

I created a donut chart modeling the percentage of EDI Orders in VBAK (Dimension is VBAK.ZZEDI_FLAG) Currently it looks as such: Instead of the X featured at the bottom and to the left of 26%, would it be possible to have the label appear as EDI Orders. I tried "VBAK"."ZZEDI_FLAG" AS 'EDI', but that did not work. Any other options available? Thanks

Backround: I have produced an OLAP table with the following columns for an Order-to-Cash Dashboard analysis with SAP. image.png70368 2.16 KB The dimension column variable is currently: "VBAP"."MATKL" || ' - ' || "VBAP"."MATKL_TEXT". The formula for Sales Order KPI is: COUNT_TABLE("VBAK") The formula for the EDI Order KPI is:SUM(CASE WHEN "VBAK"."ZZEDI_FLAG" = 'X' THEN 1 ELSE 0 END) The formula for EDI % KPI is: KPI("Ratio", "VBAK"."ZZEDI_FLAG" = 'X') Issue: I have two number KPIs that display metrics for The # of EDI orders within the OTC process SUM(CASE WHEN "VBAK"."ZZEDI_FLAG" = 'X' THEN 1 ELSE 0 END), andThe # of Sales Orders COUNT_TABLE("VBAK") The count for these are around 50k and 200k respectively, as they should

Hello Celonis Community, Celonis 4.5 I need to create a pareto chart showing the Delta hours (planned-actual) for each production phase (e.g. setup, production, breakdown,). Each phase can have different unique activities, for which Ive defined dedicated variables : The actual data are derived from the ACTIVITIES table. The Target data are located in another table: image.png827211 4.92 KB The two tables are not directly linked. The common parent table is the CASE table. image.png1609576 21.6 KB I use the component Column Chart and I add Dimension: KPI(Category), so defined CASE WHEN ACTIVITIES.ACTIVITY_EN IN (A,B,C) THEN Setup WHEN ACTIVITIES.ACTIVITY_EN IN (D,E,F) THEN Production WHEN ACTIVITIES.ACTIVITY_EN IN (G,H,I) THEN Dismantling WHEN ACTIVITIES.ACTIVITY_EN IN (L,M,N)

How can I copy the full tab from one analysis and paste into another. Idea is to have power user create there analysis in seperate folders / analysis. Once it reaches a validated stage then to copy the whole tab and paste in Productive / published analysis. Doing component by component is erronus and time consuming. Thanks Naveen Gupta

Hi all, Were using datepickers that are linked to a variable <%=date%> , which at the same time is being defined by different formulas. When looking at the title for the date picker, we have chose the text related to the variable <%=date%> The problem is that when the variable is being defined by a formula, and not a field in a table. this is also the case when we have graphs associated to the dates, in this case, the whole formula is displayed when the users hover over the graph we have tried to save the formula as a KPI, at least just to have the KPI name displayed, but in this case the variable will not be set, and the date picker will not work. Is there any way to avoid showing the whole formula as the title for these cases? Thank you for your help! image.png401673 20 KB image.png617572 36 KB

Hi all, I would like to define a new KPI to measure the ratio of eProcurement (EP) orders vs. all other PO doc types. The doc type information comes from the PO header (EKKO), however Id like to show the ratio based on line item level (EKPO). The formula which Ive set-up and which works fine for the ratio on Header looks as follows: 100 * AVG(CASE WHEN EKKO.BSART = EP THEN 1.0 ELSE 0.0 END) Somehow, Ive to bring in one more variable to take line items into account: COUNT_TABLE(EKPO) Any idea how to combine to show the ratio of EP PO items? Thanks, Oli

Hello Team, I noticed the decision tree function seems not available. Is it true or just the blue color didnt show? Best Regards, Chen Lei

HelloI am trying to create a KPI called PO Touch Indicator that will allow me to have a Value of touchless, manual intervention, or unknown based on the activites and User Type per PO.When AT LEAST one UserType = - then unknownWhen ALL UserType = B then TouchlessWhen AT LEAST one UserType = A and rest are B or all are A then Manual interventionEx 1:PO: 12344232 // PO ITEM: 01 // Activity: 1 // UserType: A // KPI "PO Touch Indicator: unknownPO: 12344232 // PO ITEM: 01 // Activity: 2 // UserType: - // KPI "PO Touch Indicator: unknownPO: 12344232 // PO ITEM: 01 // Activity: 3 // UserType: B // KPI "PO Touch Indicator: unknownEx 2:PO: 12344232 // PO ITEM: 01 // Activity: 1 // UserType: B // KPI "PO Touch Indicator: touchlessPO: 12344232 // PO ITEM: 01 // Activity: 2 // UserType: B // KPI "PO Touch Indicator: touchlessPO: 12344232 // PO ITEM: 01 // Activity: 3 // UserType: B // KP

Hi Team, We want to make one Column Chart, where X-axis (Dimension) have a data point like (0-3 Days, 4-6 Days, 7-9 Days, 10-16 Days & 17+ Days) and KPI will have such as PO Lines Pending & PO Pending GR Amount. But the issue is sorting not working properly, its sorting randomly. Is there have a way to custom sort the Dimension. Regards, Rakesh Paul

Hello, I try to create a Button drop down component for just a specific table in my analysis. So when I filter with this button, just this specific table is effected. Can anyone help me how to implement this? Best Wishes Sasan

Hi, in an Accounting use case we are looking for sales order items, where a goods issue was already booked but no invoice was created yet. That works fine with the process functions and shows always the cases where this situation is currently valid. My question: Is there a possibility to show also the situation at a reference date? So for example that you can display the amount and value of sales order items that have been in this so called ship to bill stock at 04/30/19? Thank you and best regards, Marco

Hello, I was trying to get the Median of a column. But no matter which way he calculates, he just gives me a rounded number. Even if I enter the numbers manually, the correct solution would be 4.54. Anyone have any idea what it is? Rundungsfehler2.png938969 33.4 KB Rundungsfehler.png873927 50.9 KB Thank you in advance

Hello everybody, Im struggeling with the analysis for my thesis of an ITSM process and hope there is a simple solution, which I just overlook. Explanation: A service ticket is considered as solved in RESOLVED status, the status automatically changes to CLOSED status after 10 days, in any way. So, what can I do to deposit in ALL analyses that these 10 days do not flow into the troughput time never? DLZ.jpg848958 62.5 KB Thank you very much in advance

Hi all, We use the date picker quite frequently in our dashboards; however since we are still loading data manually it is quite important for our users to see what the most current data available is. The date picker already formats the days until data is available dark grey whereas the color is light grey for dates where no data was loaded. Unfortunately, we have different countries with different data sets available (e.g. Data for Germany might be loaded until 15th of March 2019 whilst Bulgaria is available until 1st of April 2019). The date picker shows, in this case, per default always every day until 1st of April 2019 in dark grey, even when the user selects Germany (data only available until 15th of March). In order to not confuse users which date is the most current available data set Id like to add a color coding based on the selection of the country (so that when selecting Germany the last dark grey date is the 15th of March 2019). Any ideas how to do that? And, if not possible

Hi Celonis Community, Ive recently started working in PM and am faced with my first real challenges. To answer complex questions of the process owner I would need to execute more complex calculations in Celonis. Im unsure to which extent this is supported. Ive read through the functions documented in the help section and functions highlighted here but could not find any that provide what Im looking for. Is it possible to base a calculation in Celonis on a previously calculated column? An equivalent of what Im trying to achieve might be subqueries in SQL. Im unable to go give insight into the process and will provide a much simplified example. My activity table looks like this: grafik.png886138 2.98 KB Based on this I can calculate a new table with the automation rate per CASE

Hello, I am building a OLAP table. I was wondering if there was a way to re-structure the table so instead of the single KPI information flowing vertical, it can flow horizontal? I have thought about using a pivot table, however because the data set is so large, it does not seem to be a suitable option. Please let me know. Cheers, Anna

Hello, can someone please tell me how to put R code in Celonis? It is working in RStudio, but when I put it in RCALL or RAGG it gives me errors I do not understand. Can someone please explain to me how exactly RCALL or RAGG works? Thanks Vaclav Juren

Hello, I don`t know what is the correct PQL Syntax for this Activity Selection for my KPI Component option (see screenshot). Thanks in advance for your responses :o)) image.png1061476 22.5 KB