Solved

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.

Hello everyone, I have created a table through the use of HTML in the textbox in order to display the Related KPIs. I wanted to know if there is a possibility to apply the displaycontentrule for the KPI values displayed through placeholders.

Hi guys, is it possible to display a view variable as a column in a table within the same view? The value of the view variable will be updated by a input box in the same view. Thanks in advance.

Hi Team, Anyone worked on Apache Kafka data connection, if so please provide relevant documentation and steps how to extract tables from it.

Transformation Center - I am trying to write a KPI in Transformation Center to monitor when "EBAN"."MATNR" (Material Number is Missing in Purchase Req) Can anyone provide some guidance

Hi everyone, I have noticed an abundance of posts of people posting academy questions like this below:It's also always the main question, but they never post the statements. I don't want to cause a stir, but is this normal? 😓

Hi there! Is it possible to show in views the last data load date? Users would like to see in app when data have been loaded in Celonis. Thank you in advance for your help!

Hi Community I have the following PQL Query as an KPI: AVG (  CASE    WHEN      MATCH_ACTIVITIES ( NODE [ 'Proposal Submitted' ] ) = 1    THEN        CALC_THROUGHPUT (          First_OCCURRENCE [ 'Proposal Stage' ]          TO          Last_OCCURRENCE [ 'Proposal Submitted' ] ,          REMAP_TIMESTAMPS ( "ACTIVITIES_TABLE_HUBSPOT"."EVENT_TIME" , DAYS )        )           ELSE      'No Proposal was Submitted'      END) I would like to have the string value 'No Proposal was Submitted' for the business in thr ELSE statement. I know I can simply replace it with the INT value 0, but I don't want that.  Any help is appreciated 😊  The error reads: Operator requirements are not met. CASE WHEN expression is not compatible with an ELSE case of data type STRING when at least one THEN case is of data type INT Kind regards,Sverre Klein  

I would like to know if it's possible to fix a view component in the top section of a dashboard, so it doesn't move vertically when scrolling.

I am sharing an attachment for reference .   Thanks, Kandi Ajith Naidu.

In the Windows under Data Integration where I write SQL Code for Transformations I sometimes have dark mode (white font on black background) and sometimes the other way around. It seems this changed from time to time and from environment to environment.Where can I set this? How is this being influenced? Obviously being a developer I want dark mode all the time 😁

Hi there, I have the following table:  We got for every part diffrent timestamps with a specific work done there. I would like to calculate the date between the installation and removal date. The problem ist, that for one part there can be historical data with multiple removals and installtions (like you see in 'Y'). Here I would like to calculate the difference by taking the installtion data followed by the date of the next removal.  I tried the Lead Function: DATEDIFF(DD, (Lead ( ('DATE'), ORDER BY ('DATE' DESC), PARTITION BY ('PART', 'WORK'),1)),  (DATE) ) The problem here is that this function calculates only the days between the removals.Do you guys have any idea how I can get the dates between the installation and removals dates? Thank you and best regards!

For some reason I am not able to scroll down or select the case ID. Maybe it is a UI issue?

Hello everyone, Is there a way for admins to delete bookmarks created by other users? We have a lot of bookmarks created by no-longer-existing users that are polluting our dashboards. Thanks in advance!

I'm in my first EMS project and it was to accompany the DATA ENGINEER activities.Unfortunately the Data Engineer was not hired and they asked me to take over and I don't know SAP BASIS. I've done the Get Data into the EMS training, but I don't know what the initial practical steps are to do to "Create sap connection in celonis ems".Does anyone have anything written from "Practical roadmap to "Create sap connection in celonis ems" to send and/or guide me?

This is a PQL question: - I have three THROUGHPUT calculations working (I think) - I now want to have a COUNT column next to each. But: I am counting ACTIVITIES not CASES. How can I count cases, not activities/tasks?

Hello everyone!I want to send an Action Flow weekly that displays the material numbers that qualify for an automatic ordering process (this process can be triggered by editing the material master data). Since employees might choose not to edit the master data due to various reasons, the one material number for example will show up every week in the CSV that is sent via the AF. It could be possible that this repetitive sending of material numbers that should not be automatically ordered might negatively affect the acceptance of the AF. Here's my idea: does somebody have an idea how to add a timestamp of the initial sendout of the data rows in the CSV file? So, for example, if one material number was already sent out via the AF on the 1st of January, in the next runs of the Action Flow the 1st of January will be visible in an extra column, so employees could filter it easily to the current date.  Thank you so much! BRJulia Bauer