Product Q&A

Hi, does anyone have benchmark values for Mining and Metals industry? Particularly for the Asset maintenance process

Hi everyone, i am trying to create a view, where there is a process in the background and some KPI's in the front (please see screenshot). This lets the user know the value of the KPI at different stages of a process (e.g. # cancellations during order management process of O2C and # cancellations during logistic process of O2C).But i don't see any way of overlapping with layers (as in powerpoint) OR selecting a background image for a component/section/column in Views. All ideas are welcomed 😊 thanks

This might be a very specific issue, but, at the moment, CDPOS table shows the changes as follows: As you can observe, line 2 and 3 have the same OBJECTID, CHANGENR, DATE and TIME. Therefore I would like to keep them in a single row - expected result:Does anyone have a suggestion how to achieve this? Perhaps creating a temporary table to store some values and then update it with the value from the other row. But not sure how to get there. Thank you in advance! 👋

Hi, Does anyone know how to extract augmented attribute history data in Celonis? If I create a table to pick up the augmented attribute, I only get the most recent value and not the entire history (see example below). Thanks!Teun

Hello, I am using PU_LAST to find the last activity in each case to find the user.PU_LAST ("OCH_Cases", "OCH_Activities". "User_Group_NAM") But now I always want to find the second to last activity. How could I do that? Thank you Regards,Rene 

Hello, How can I push list of activities selected within analysis dropdown into variable maintained within Knowledge Model? It works fine only for variable stored locally... Regards, Lukasz

In Action Flows, I am modifying an augmented attribute. The augmented attribute automatically created a supporting table with an attribute changed_by. this attribute is getting a uuid reference to the user. But, I can't find any documentation to convert it to a name. Does anyone know how to do this?

Hi guys, do you have any use case where in we can send in 1 email for multiple selected id's in the front end? The trigger would work 1 email per selected id's in the table. I wanted to consolidate the id's selected and send 1 email for all of it.

Hello guys,I have created a table with some invoices and i want a filter only on the invoices when the last activity is 'to verify' I have tried many solutions like PU_count_distinct, PU_last,... but i dont see any other solutions ! Thanks for your help !

(COUNT(CASE WHEN KPI("VALUE_PAY") <'0' THEN 1 ELSE 0 END))/(COUNT(CASE WHEN KPI("VALUE_PAY") >'0' THEN 1 ELSE 0 END))

Hi, I registered as a Customer with my company account by mistake instead of Partner. How can I switch? I am now not able to create a Partner account with my company email address. Thank you for your help

Hi, Can someone please provide any architecture details or any docs related on how to setup PowerBI connection for Celonis action flow? I already checked the celonis docs but it looks like its not enough or there's no specific instruction on how to setup PowerBI connection actionflow to Celonis. We are planning to use this Celonis PowerBI Action flow modules but we are not able to setup the connection between celonis and powerbi as the 1st step. Thanks!Neil Cascante 

I am calculating freight cost (which is on header level) for orders and would like to show all orders along with order items in an OLAP table.Now there are certain order items which I would like to identify and be ignored for which I created a KPI called "identifier":Now when Identifier is 1, I want POSNR of such order items to be considered and take the first available "POSNR" and put the Freight cost against it.  The result however is coming on the first POSNR which should have been overlooked based on my identifier:

Hi I am creating smart sensor to generate signals but getting below error { "message": "Failed to create task. Augmentation Error: Client Error: The schema of table [DUPLICATE_INVOICES_CEL_TASK] contains [22] columns but [24] columns were given." }

Hi, I would like to use a formatNumber(...) function in the result of the SUM() function. The operation is unsuccessful, I receive information The operation failed with an error. Failed to map 'formula': Function 'formatNumber' finished with error! 'NaN' is not a valid number or using unsuitable separator. Do you have any advice?

I want to import a manually transformed table from datapool to ML workbench to do some operations. Is it possible to do that without loading the data model? Can i import the transformed table directly?

Hello All, I need to export all the Cases in sheet "Cases Explorer" but I can not find the way to do it. I used the method "Flat Files" to building the Event Log and build Data Model from this (not real-time connection, such as cloud, etc.) Does anyone know how to do it? Many thanks All.

initial output : C76_XX_XXXX_INVOICE_LIV_XXXX_XXX.001.pdf what i would like :C76_XX_XXXX_INVOICE_LIV_XXXX_XXX_001.pdf Thanks for your help

Does Celonis provide Snowflake connectors? If yes, Is it a paid subscription?

Is it possible to hide certain activities in the Process Explorer that are not relevant for X user? I was trying the sheet filter FILTER PROCESS NOT EQUALS [Activity Name] but this excludes the cases, not only the activity.

Hello Celopeers, I have a Studio analysis that is super slow because of many filters, it loads often slow when you switch between the sheets. Do you think that moving the common filters to analysis lvl can have a significant impact on the performance? Thank you for any opinion!Jan

Hey Celopeers community! I am attempting to create a change activity based on a changing list of values, below is an example of a case where a change activity should be created.  Case ID | Date | Value1 | 2021-8-20 | A1 | 2021-8-20 | B1 | 2021-8-20 | C1 | 2021-8-21 | A1 | 2021-8-21 | B As you can see the list of values changed from A, B, C on 8/20 to A, B 8/21  I looked at the VERTICA function library and found LISTAGG function that would help solve this by concatenating fields into one single row, but, unfortunately, it is not enabled in Event Collection.  Are there any workarounds you can suggest? 

The following PQL formula is the default for PQL KPI's. Am I correct in understanding that the following only calculates processes that start with a specific activity and cannot be calculated if the flow of a specific activity is included in the middle of a process? KPI("Ratio", PROCESS EQUALS START '' TO ANY TO '' END ) 

Please modify this code,  FILTER MATCH_ACTIVITIES ( "finalResult_0_01"."ACTIVITY" , NODE ['<%=display_code_1%>'] ) = 1; so that it also works with variables similar to display_code_1. I tried  FILTER TO_STRING(MATCH_ACTIVITIES ( "finalResult_0_01"."ACTIVITY" , NODE ['<%=display_code_1%>'] )) LIKE '1%';  this code and also some contains, regex_like etc but Celonis EMS does not recoginze both function. Thank you