Solved

Hello everyone, I am currently calculating the time interval between 2 activities for my department, see formula... TRIMMED_MEAN(CALC_THROUGHPUT(FIRST_OCCURRENCE['toPAS: QT5.2 - Check successful'] TO FIRST_OCCURRENCE['XI release'], REMAP_TIMESTAMPS("T_CEL_AT_HP5"."EVENTTIME", DAYS, MONDAY TUESDAY WEDNESDAY THURSDAY FRIDAY)), 5, 5) Now it can and may also be the case that the activities are swapped, how can I then incorporate this option into the formula? TRIMMED_MEAN(CALC_THROUGHPUT(FIRST_OCCURRENCE['toPAS: QT5.2 - Check successful'] TO FIRST_OCCURRENCE['XI release'], REMAP_TIMESTAMPS("T_CEL_AT_HP5"."EVENTTIME", DAYS, MONDAY TUESDAY WEDNESDAY THURSDAY FRIDAY)), 5, 5)ORTRIMMED_MEAN(CALC_THROUGHPUT(FIRST_OCCURRENCE['XI release'] TO FIRST_OCCURRENCE['toPAS: QT5.2 - check successful'], REMAP_TIMESTAMPS("T_CEL_AT_HP5"."EVENTTIME", DAYS, MONDAY TUESDAY WEDNESDAY THURSDAY FRIDAY)), 5, 5

I’m a bit confused of when to use the ACTIVITY_TABLE() and other SAP tables when calculating the KPIs. So for example, when I want to calculate # of changes per PO item, is it correct when I use the ACTIVITY_TABLE() to count the change activities occurred or use the EKPO table and calculate the changes with indicator fields from the table. Same for other KPIs, this is just an example.  Becausesometimes I get different results (in calculating automation users/activitiesfor example) and I am not sure which is correct.

Hello everyone, I'm trying to count the number of materials per purchasing group that have been active in e.g. the year of 2023: PU_COUNT_DISTINCT("T024", BIND ("_CEL_P2P_ACTIVITIES", "MARC"."MATNR"),"_CEL_P2P_ACTIVITIES"."ACTIVITY_EN"='Create Purchase Order Item' ANDYEAR("_CEL_P2P_ACTIVITIES"."EVENTTIME")=2023)) I want the aggregation to be made per purchasing group (T024). MARC provides the information which purchasing group is responsible for each material number. I need _CEL_P2P_ACTIVITIES table to filter the eventtime within my view. This aggregation works, however, when wanting to build an average (per purchasing group) like this, it does not work - error: "The aggregation function COUNT cannot be used together with a dimension function input. Please check that there are no aggregations and dimensions used together as function inputs": PU_COUNT_DISTINCT("T024", BIND (&q

I have Python version of 3.8.6 by default I want to upgrade my version of python . I tried using this command in the terminal. It is asking password for it. Is there any other way to implement this?. Please let me know. Thanks, Ajith Naidu.

SUM(CASE  WHEN       PU_COUNT ("EKPO","_CEL_P2P_ACTIVITIES"."ACTIVITY_EN", "_CEL_P2P_ACTIVITIES"."ACTIVITY_EN"       IN (${VARIABLE_CHANGE_ACTIVITIES})) = 0      AND ACTIVITY_COLUMN () NOT IN (${VARIABLE_EXCLUDED_ACTIVITIES})     THEN 1.0    ELSE 0.0  END)

I am trying to create a component filter for "the running past 24 months". - I can get a "since 2022" to work, but I can't get a floating filter, like "for the past two years" to work. Can you help me with the general syntax? Thank you.

Hello everyone, I have incorporated a KPI List to a View and for those KPIs shown in the list, I do not want them to be filtered with selections. In the analysis design this was possible via a check button. Where can I set this the same way in a view? Is it YAML coding? Thank you! Best regards,Julia Bauer

Hi team, I want to create a KPI to measure the proportion of items with missing routes. BUT I want the scope of my data to be filtered only on specific order types.I could add a filter on the component, but to make sure the KPI is always measured the same everywhere, I want to have the filter within the KPI calculation. I understand the below formula is not correct ('The aggregation function SUM cannot be used together with a dimension function input.') but I am struggling to find the solution. Any suggestion ? Thanks heaps CASE WHEN "VBAK"."AUART" IN ('ZCS','ZECH','ZEDI','ZCSG','ZEDC')THEN SUM (CASE WHEN "VBAP"."ROUTE" IS NULL THEN 1 ELSE NULL END)/ COUNT_TABLE ( "VBAP" )ELSE NULL END

Hello everyone, I'm currently working on a dashboard within a view. There are two points where I'm probably lacking the YAML syntax or perhaps the "functionality" is not available yet: 1) Example without data - KPI - I want to color the number (in %) in e.g. red - is this possible?2) I want to color the background of a column within an OLAP table - how is this possible in YAML? Thank you for your support! Best regardsJulia Bauer

Here is the code: ROUND_HOUR( "ITT_PRODUCTIVITY_F_SEP_UAT"."EVENTTIME" )

Hi everyone, There is a functionality within Celopeers to save posts in the "bookmarks". However, I can't find them anywhere. Does anyone know where to find the bookmarks within Celopeers? Thanks!

When I save PQL formulas in the new Studio, they are not assigned to a record as an attribute in the Knowledge Model, but each time as a KPI.  Again, custom records and attributes are not displayed for selection in the new Studio. 

Hello everyone, I want to build a worklist in Celonis with exception messages that purchasers should process. New exception messages should be marked with an augmented attribute (Status: NEW). I also have another augmented attribute - Comment field. I now want to store every changes made manually (change status from e.g. NEW to in Clarification or changes in comments) into a table as this table is needed to train an AI model. Is this possible - has anyone made experience with this and is willing to share their experience? Thank you! Best regards,Julia Bauer

I'd like to create a component (dropdown or checkbox), to switch between two data models (let's call them "test", and "prod"), that have the same structure but contain different data.I tried two ways:A runtime variable called "dm" holding the data model variable name. I used this in the knowledge model like this: dataModelId: §{{dm}}A runtime variable holding a boolean value (1 or 0) called "useProd". I used this like follows: dataModelId: §{{useProd==1?prod:test}}Both ways didn't work. Did I just do it wrong or is it impossible?

Hi, how can I achieve a calculation with an OR / INLIST('RESOLVED','RESTORED')This formula is not working. Do I need to construct a case when first? AVG(    CALC_THROUGHPUT(    FIRST_OCCURRENCE['QUEUED']    TO     FIRST_OCCURRENCE['RESOLVED']  OR  FIRST_OCCURRENCE['RESTORED']    ,     REMAP_TIMESTAMPS("eventlog"."TIMESTAMP", HOURS))  ) The part without OR  FIRST_OCCURRENCE['RESTORED'] works fine

Hello everyone, this is probably very easy but I'm lacking the syntax that converts the number format. Can somebody please support me on this?Thank you!Best regardsJulia Bauer

Hello all, I would like to compare how certain attributes of selected cases compare to the overall share of cases with that attribute. For example:All cases have a certain color. I would like to know what is the share of each color for my selected cases compared to the share of that color for all cases. The result should look like (simplified):Color | Selected Cases | All Cases | Differencered | 15% | 30% | -15%green| 85% | 70% | 15% Therefore I created a OLAP table with the dimension "color" and the following KPIs: The KPI for my selected cases is:(COUNT ( DISTINCT "table"."case_id" ) / GLOBAL(COUNT ( DISTINCT "table"."case_id" )))-> works fine For all cases the KPI is:PU_COUNT_DISTINCT (DOMAIN_TABLE ("table"."color"), "table"."case_id") /PU_COUNT_DISTINCT ( CONSTANT(), "table"."case_id")-> which also w

I want to add a component filter to my chart in studio analysis that Filters it to only show values between 08:00 and 16:30. How do I do this?

I have a process with mulitple QUEUED per caseI want to find the last QUEUED, and find the first 'INPROG' directly after the last QUEUED.There could be many INPROG, so I don't need the LAST_OCCURENCE() - which does workIs there a NEXT() row kind of option? I tried this, but is not allowed AVG ( CALC_THROUGHPUT (  LAST_OCCURRENCE [ 'QUEUED'] # event X  TO  LAST_OCCURRENCE ['INPROG'], # I want the first event after X, not the last in prog, but the first INPROG after LAST QUEUED  REMAP_TIMESTAMPS ( "eventlog"."timestamp" , MINUTES ) )) Tried also with ACTIVITY_LEAD but that is also not possible AVG ( CALC_THROUGHPUT (  LAST_OCCURRENCE [ 'QUEUED']  TO  ACTIVITY_LEAD ( "eventlog"."timestamp",1),  REMAP_TIMESTAMPS ( "eventlog"."timestamp" , MINUTES ) )) Is there a option to calculate this formula and show it in a KPI Olap table? 

I have created a KPI to rank all plants based on their Invoice value. I also added two filters to this KPI - one for the top 20% of plants and the other for the remaining plants. Although these filters work as intended at the global level, they do not generate accurate numbers when applied to a specific country or region. How can I resolve this issue

PU functions don't take load script-, sheet-, component- or manual filters into account. Instead they have the filter option in their syntax. That is also described in the documentation (https://docs.celonis.com/en/pull-up-aggregation.html).I have some colleagues who think they are getting a different behaviour of the PU-functions compared to the time when their analysis were built (~3-4 yrs ago).Does anybody remember if the PU-functions once took sheet- or component filters into account?

End users usually have a problem identifying which environment they are currently using. One option is by clicking switch team which shows the name of the current environment, but it is a straightforward way.

I thought, I could use the generic technical documentation for Analysis sheets. But it turned out, that it's incomplete as it does not include design components like button dropdown.

I would like to create a role that only has the rights to manage the permissions of data pools, without the person being able to edit the data pool itself.I have already implemented the same with the Spaces, where the role can only distribute permissions but cannot see the content of the packages.  Unfortunately, Data Integration does not have the option "Manage Permissions" for a Data Pool separately, while the option "Edit Data Pool" includes the right ton manage permissions. With the "Edit Data Pool" option, the user can also edit the entire data pool. How can we devide the admin right to create data pools and to manage the permissions of a data pool, which needs to be granted to another role?  I look forward for some support. Best regards, Tim

Can anyone suggest the best way to extract the parameters used in extraction jobs in to machine learning workbench using python.