Product Q&A

  PU_COUNT_DISTINCT ("_CEL_OTT_CASE_TABLE_NWF_DD",FILTER_TO_NULL("_CEL_MERGED_ACTIVITIES"."ACTIVITY"),  "_CEL_MERGED_ACTIVITIES"."ACTIVITY" LIKE 'NWF: Due % & Release'   AND   "_CEL_MERGED_ACTIVITIES"."TEAM_LEADER" = 'Robben Ramatlo'  )

Good day, can someone please share with me the formula that is used in the PI Social to calculate the KPI "Users per case"

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?

I have a customer who also uses celonis. We would like to push them tables from our instance into theirs. Of course we could also make the raw tables available and they could extract them directly. But was assuming there was also a capability to share a data pool externally from my instance. Is that a possibility? I could not find any documentation on this...

How do I look at cycle time of mulitple events in my process. I want to know the cycle time of First Occurence of "Change" events 7 different events compared to the initial "Create" event. I can do this easily for each event but I want to look at all 7

Hi, is there is a way in Transformation center how to add a personal email as a recipient for email alerting? We don't need it for a long-term but we are having issues with showing the KPI charts in the emails and need to rule out potential causes.

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, We have developed a Github backup automation in the workbench based on this repo by @simon.klotz​ :https://github.com/celonis/pycelonis-examples/blob/main/pycelonis2/01_example_use_cases/01_use_case_version_control.ipynb The script was adapted to our needs so that analyses, knowledge models, variables, and transformations are assigned to the Celonis project and loaded directly into the corresponding Github repo as a backup zip. The next step is to test import the secured backups using content-cli.Is there a best practice for this?Which content-cli commands are there to upload the assets (analyses, knowledge models, variables, and transformations)? We only know of commands for pushing data pools and packages.Is there a way to import the zipped backup directly? I look forward to your contributions!Best regards,Conny

Hi, can a horizontal scroll option be added to bar/area charts in Views?

Hi all, is it possible to make a dimension in a OLAP table static. So when I click on another dimension it does not affect the value?

Is it possible to transfer the from Sandbox to Prod Environment or One team to another team..?

Example: KPI_A: 0% (weight 1)KPI_B: 90% (weight 2)KPI_C: NULL (weight 1)-> Expected outcome: 60% (2*0,9+1*0)/3 KPI_A: 0% (weight 1)KPI_B: 90% (weight 2)KPI_C: 0%(weight 1)-> Expected outcome: 45% However all I came up with is:((KPI_A*1)+(KP_B*2)+(KPI_C*1))/4 which is resulting in NULL if any of the KPIs is NULL. I could sove is using extensive nested CASE WHENs catching every possible combination but that seems quite cumbersome and hard to read/maintain. Does anyone have a better appraoch or PQL function I am missing? 

Can you explain the main differences between using the FILTER_TO_NULL and not using it in a PU function. I see that the results differ for the following 2 functions:  PU_COUNT_DISTINCT (    Domain_Table("CEL_ACTIVITIES_CMS_COMBINED"."USER_NAME")   , FILTER_TO_NULL("CEL_ACTIVITIES_CMS_COMBINED"."CASE_ID")   , "Grouping_All"."QUERY GROUPING" = '<%= QueryGroup %>' )  And PU_COUNT_DISTINCT (    Domain_Table("CEL_ACTIVITIES_CMS_COMBINED"."USER_NAME")   , "CEL_ACTIVITIES_CMS_COMBINED"."CASE_ID"   , "Grouping_All"."QUERY GROUPING" = '<%= QueryGroup %>'  )     

Hello Everyone,  I am currently facing the problem that after uploading the ABAP reports for the P2P Connector in Celonis i cannot run the transformation.   basically in the training about the ABAP extractor, they advise to run the transformation after uploading the reports. However as soon as i execute the data job for the SAP P2P full transformations I get the following error message.   I have the feling that the JOB does not find the ABAP reports that i uploaded. or i am missing a step here :(  I appreciate a lot your help to solve this matter. Thank you in advance. Omar

Hello everyone, I'm still quite new to Process Mining and PQL.  How can I create the Column chart of the "Rework Selection" as a standalone component for the dashboard? In my process, there is a process flow (loop) that can occur either 0, 1, 2, 3, 4, or 5 times per case. Therefore, on the X-axis, the number of loops should be listed (0, 1, 2, 3, 4, 5), and on the Y-axis, the frequency of occurrence of each number of loops should be shown.  I tried it with this: https://docs.celonis.com/en/calculations-on-activity-sequences.html   And that works well for an OLAP table, but it only provides me with the count of loops per case and not the count of cases for each loop count (0,1,2,3,4,5). However, I cannot or do not know how to access this OLAP table in another component and sum up the counts per loop iteration. Thanks for your help! 😊

Hello, I would like to automate the entire user access process like adding / removing/editing users and then adding users to the user group assigned. Any thoughts or leads if any of you worked on it? Thanks in advance

Hello All,We want to setup a action flow to refresh 1 table from a data model. Is there any way to do it using action flow? Thanks in advance.

What I'm trying to do is apply a filter in a Query Data bubble based on a dynamic variable. The variable is defined in a view, then the Action Flow is called and the idea is to check for a greater value than the variable in the queried data.  I've tried Action Flow Inputs, but those don't seem to be the answer since the variable can only be updated manually once the AF starts. Also, the idea is to execute the AF from the view, which apparently removes the write-in option for the input leaving it always blank. Can this be done?

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

Good morning! I want to do a filter like the picture (this are the filters used in Conformance Checking sheet in Celonis Free Plan, in this sheet I can't see the format of the filter or change nothing), I try replicate but I can't do it. Could somebody he

Hi all, I have a drop down list in my analysis with multiple values, but I want one value to always be selected and you must not be able to deselect that specific value. How do I do this?

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

We are extracting data in the Action Flow, formatting the text content of the email using the Excute Process Automation Skill, and then using the Send Email Skill to send the email using the Celonis email server. I have a question here.In the "Excute Process Automation Skill" settings, I have entered the text information I want to convey in "mail_text" and the extracted information assembled in an HTML table. In this text information, I have written a hyperlink (HTML) to link to the Celonis analysis.We sent it to our own email address (Gmail) for test transmission, but the result is that only the link tag has been removed. Only the text enclosed by the link tag is displayed.In other words, only text without a link is displayed. In the log of the sending skill, it is sent as described in the tag.Is it possible to delete the link tag on the Gmail side when the test is received on the Gmail side?(I am assuming that Gmail side parses the HTML and may alter the tags.) I