General Product Q&A

Hi All,We are trying to implement the machine learning model Linear Regression in our ML workbench, Can anyone suggest us in what all parts of celonis will it be useful or a business use case were we can implement it successfully.

Could you please explain what exactly is happening here. does that mean that for the mentioned tables complete data is not loaded?

Even after being added to a team, the dashboard created by my team is not getting updated on my profile.

Complete the statement. When creating a pie chart in Celonis, … A. ... at least two KPIs need to be selected. B. ... an endless amount of KPIs can be selected. C. ... only one KPI can be selected.

Hi, i want to make a button that connects dashbaord information (data got from KPIs) to an external URL , but i can only use variables. So, i want to know if is possible to use this data (KPIs) into my URL button.

We are plotting Dpo vs payment date and have a requirement to display the data of the selected time period in the chart. But we are not able to do it. We did try using dropdowns but only selected date data is displayed and not the period between the days.

How can I copy bookmarks from one analysis to another? We keep around 200 bookmarks shared across multiple users. All of these should now be migrated into a different dashboard inside another package. Is there any official method for such task?

Hi, Can you help us with a question, please? What standard does Celonis use for JSON calls via API? RAW or X-www-form-urlencoded? Could you cite examples of these configurations within Action Flows? Thanks

Can i create a Conformance Ratio KPI (like on the Conformance Overview) using the conformance query

Hi Everyone, I'm trying to create a table using ML workbench by using this code  pool = celonis.data_integration.get_data_pool(id_ = pool_id) pool.create_table( df = input_table,         table_name = table_name,         drop_if_exists = True,         force = True,        )While running this i'm getting PycelonisNotFoundError for my instance. Here is the attached screenshot for reference. 

 CASE WHEN (ROUND_DAY("PAYMENT_TABLE"."Payment registered date")) < PU_MAX(DOMAIN_TABLE("PAYMENT_TABLE"."CG Key"), "PAYMENT_TABLE"."Payment registered date", ROUND_DAY("PAYMENT_TABLE"."Payment registered date") IS NOT NULL)THEN ROUND_DAY("PAYMENT_TABLE"."Payment registered date") ELSE NULL END 

Hello, I have been facing some issues accessing the Asset Library. I fill in with my credentials but messages like this appear: "You do not have access to the Apex class named 'qsydFileExplorerController'." Can anyone tell me why and how to solve it? Thanks

Hi there!I've a problem using a variable in a formula of OLAP_TABLE.I've two variables (Interv_1, prueba_var1) text/replacement Type, with values:Interv_1=OTHERPrueba_var1=3 If i want to use it in a text component, with variable "prueba_var1" is OK, but if i use the Variable "Interv_1" i have a formula error. I don't understand why..... Thanks in advance    

Hi Everyone, Hope your all doing well, I want to create a table where the data stored in it will be values selected from the dropdown in the view. Please share any suggestion asap. Thanks, KANDI AJITH NAIDU.

Hi Everyone!. I have a query. How do I transfer entire production instance data to another instance?. If possible, please let me know asap.

Good afternoon,  We have an Action View configured that has a Send Email Action Flow attached that, for each record invoice code, will send an email to a Customer with information. To this end, we have been looking for a way to preview the email, via a click for example, so that you can view the specific email being sent and possibly make any changes.   How could we achieve this?   Thank you Maicol Munevar

I would like to know how the "data_consumption_updated_events updates" works, since for some tables the "_CELONIS_CHANGE_DATE" is related to a very old date, and this field should show the current DateTime for each table that I want to track.  So the data consumption in the monitoring for each table is different from the one that is being generated in the custom monitoring pool. I would like to understand the reason for this.

Can i create a Conformance Ratio KPI (like on the Conformance Overview) using the conformance query

Hello,In a use case we have 4 activities where we are trying to find the throughput time between 2 events from 2 different activities tables , when we used event log merger it pops up an error message showing the row limit exceeds to 5 billion rows , though we have 6.11 million in one and 29 million in one event count (Distinct event) .

I would like to retrieve the second and third approver of the timesheet. Can you help me? I'm trying this logic, but it's not working :  PU_FIRST (    "ESSR_MIRO",   "_CEL_ESSR_ACTIVITIES"."USER_NAME",   "_CEL_EBAN_ACTIVITIES"."ACTIVITY_PT" = 'Release'   INDEX_ORDER ( "_CEL_ESSR_ACTIVITIES"."USER_NAME",       ORDER BY ( "_CEL_ESSR_ACTIVITIES"."EVENTTIME" ASC),       PARTITION BY("_CEL_ESSR_ACTIVITIES"."LBLNI" ) = 2)  

I'm reaching the limit of the Microsoft 365 Email Send Message in Action Flow. Since Celonis does not support a service account what else I could do? Thanks in advance, 

Hi everyone! I created a action flow using webhooks custom, but when I run it, th csvs are arriving separated, I want to get all in one email, does anyone has any ideas?

Hi All, We are trying to analyze IT project approvals in the organization.Our internal customer asked us to order the columns based on the duration time.We did it by adding "SortBy" to the YAML configuration of the bar charts,Once done, the values of the number of project (second layer of 'Points') are increased.Can someone explain me the reason? How can it be resolved?Adding images before and after the change: Before: After: Count of projects increased to 4000 from 800. Values also increased. *Change marked in blue. Best regards,

May i know how to change the partner portal admins?