General Product Q&A

Hi,I would like to know if there is any possibility to give the PQL formula for KPI inside view. Please let me know for any hints. Thank you in advance :) Best Regards,Shravya B

Hi all,I would like to know wheather celonis data job task have following features or not. 1. Code history feature to compare old to new code.2. Export all SQL on data job task, if #1 doesn't exist I'd like to store my SQL on my local.​Thanks and regards :) 

How can I assign a variable on the dropdown component? I want the result of the dropdown component act like a variable input Thank you

For example to calculate the share of items for each region. If I have an OLAP with all regions, I need to have the total number of items divided by the items for the region, but I want to have the total number dynamic to not update the total number manually.So the same output over all rows. Does someone knows how to do it?

Drag and drop also does not work.

Hi, can we create actions flows out of a Bookmark created in the system. That is sents out to users an email with the content or link to our dashboards?

 Imagine an activity table like this: Case 1 - Activity A - 1PMCase 1 - Activity B - 2PMCase 1 - Activity C - 3PMCase 1 - Activity D - 4 PM I want to aggregate on another column. I am using OLAP Table and my KPI is: Name: count of cases when Activity C happens < 2 hours from Activity B Formula:SUM(CASE WHENHOURS_BETWEEN(PU_FIRST(Cases,Eventtime,Activity=Activity B),PU_FIRST(Cases,Eventtime,Activity=Activity C)) < 2THEN 1ELSE 0END) When I run this against a list of all cases, I get the right answer 1, but when I aggregate it, I'm getting 4. I thought this would only evaluate once per case... is that incorrect?  Thanks,Matt

(Senior) IT Consultant Celonis Data Engineer (m/w/x) (Senior) IT Consultant Celonis Projects (m/w/x) ALDI SÜD/ALDI SOUTHLocation: Mülheim a.d.R. (Germany) Description: As one of world's leading (discount) retailers, process excellence is inherently key to our DNA - which is why ALDI SOUTH is using Celonis to accelerate our process excellence journey and continuously realise value by using process mining and task mining and by providing our business with real-time execution apps and ActionFlow based automations. Become part of our growing Celonis team and join our Celonis Projects or Celonis DevOps team. Not sure which position to apply to? No problem, let's jointly figure it out! (Check out the full description following the links) Apply here (Data Engineer), orApply here (Projects)

Recently we have got some questions from our clients about the baseline graph in the process explorer in process analytics. The question is, in the variant explorer, the most common variant has 5 different activities, but in the process explorer, only 4 of these 5 activities show up in the baseline graph. If we click to add activities, two new activities are added but none of them is the one from the "happy path" (the most common variant).  We have checked the help documentation about the process explorer, such as "The Happy Paths show you the most frequent starting activity and the most frequent ending activity as well as all edges and other activities that are included in the variant connecting those two". But this doesn't really solve the question in our case.  Could anyone please explain what the principle is to create the baseline graph in process explorer?

I would like to export an end to end representation of the Direct Follower Graph from the Process Explorer, e.g. as an image. My process consists of 60 activities, so I need to zoom in to have the full view. Therefore a screenshot doesn't work.

I want to know how to place my order about certification exam.​After fillied out the address information, credit card information, checked LMS provider Terms & Conditions, and clicked "place Your Order "​I got the ”Your card was delclined” message.I've tried defferent card blands these are all available in other servicies. I'm tring that from Japan. Is there any similar issues and solution?​

Sum(CASE WHEN "ActivityTable"."Activity" = 'something' THEN 1.0 ELSE NULL END) gives me the count when there is an entry "something" in the table.My challange is following: I need to count Distinct Case_ID, whenever "something" happens. It can happen more than 1 time for an Case_ID, so i need a PQL statement like:CASE WHEN "ActivityTable"."Activity" = 'something' THEN count (Distinct(Case_ID) ELSE NULL END, which is ofcourse not working like this. Ideas and solutions are welcome. Thanks a lot

I'd like to create table. Added a column (A-B FLAG) PQL to the OLAP table on the dashboard that determines A and B. (Not on the data table.) I want to create a pie chart on the Celonis dashboard that counts A and B and the number of each. In that case, what formula should I add for KPI and Dimension, respectively?

Can I arrange the columns in a CSV within an Action Flow? Seems this should be straightforward, but I cannot seem to organize columns as my customer has requested

Hi all,​I'd like to know where can I find prerequisites to use celoinis template in market place, which SAP table is required to use it, for example.should I need to check all SQLs or data connections to know it or do we have something Excel list to know it?

Like what information do we need to define a new non-standard activity, what tables we need to look at for Payment Proposal Creation!

Can Celonis be used as a data source to other tools?

I want to create a process map for my data. Therefore, I tried to load my data using Quickstart CSV. But during 'Generate analysis at the final step 'Creating your Analysis' ' I got an error: "The export failed: Table contains more rows than the allowed maximum per table of 100000 Please reduce the number of rows.". I want to keep more than 100000 rows for statistic purposes.

Hello everyone!​I have the code below:​AVG(   CALC_THROUGHPUT(    ALL_OCCURRENCE['Process Start'] TO FIRST_OCCURRENCE['Incident assigned to a new operator'],     REMAP_TIMESTAMPS("activity"."SYS_CREATED_ON", SECONDS)   ) / 60 /60  )​which calculates averate throughput time until activity "Incident assigned to a new operator" occurs. I have however changed the data transformation script, so that this activity can now either be "Incident assigned to an operator by service desk" OR "Incident claimed by operator from incident pool"Obviously this change broke my KPI, as what used to be one activity can now be either one of the two. I was hoping it would be possible to pass two strings to FIRST_OCCURRENCE[] (such as FIRST_OCCURRENCE['Activity A','Activity B']), indicating I want to measure time until occurence of either "activity A" or "activity B", similarly to NODE_ALL[] vs NODE[], but unf

I am getting error while uploading a file in Data Integration On Premises. The error is : File Upload failed: cloud.celonis.integration.services.datamodel.file.DataPushJobException: ["2023-04-11T04:17:23 - Starting execution, status set to RUNNING"]

How to write a if/else statement for runtime variable?

Hi,In one of the Apps, I got the logic for the KPI -3-way match. But when I tried to fix I am getting the error as below- Can you please help me? Please find the error first and then the logic I used - Error: Syntax error near [<] after reading [ (((1.0*"EKPO"."MENGE") - (1.0*PU_SUM("EKPO","EKBE"."MENGE","EKBE"."VGABE"='1' AND "EKBE"."SHKZG" = 'S'))) >= (-1*((1.0*"EKPO"."MENGE") *(] at line 21. Please refer to PQL documentation for available syntax. Logic: 100*(1.0*COUNT( DISTINCT CASE  -- No quantity match if order quantity is 0 WHEN "EKPO"."MENGE" = 0 THEN NULL WHEN -- Quantity match     --Order Quantity = GR Quantity   (((1.0*"EKPO"."MENGE") - (1.0*PU_SUM("EKPO","EKBE"."MENGE","EKBE"."VGABE"='1' AND "EKBE"."SHKZG" = 'S'))) >=

Is it possible to visualize graphs such as scatter plots, correlation plots, box plots, etc. in Celonis?

How to find your celopeer at the platform? I want to find my Celopeer. Eventhough I wrote her name in the search button I cannot find.