Product Q&A

I am trying to make an action flow which gets triggered when the data load is more than a day old i.e., when the data load failed, and we are unaware of the failure. Current problem is that I am able to get the last refresh date from event log which is the MAX of the time stamp but to put a trigger to see if the MAx is more than a day old, the FILTER function in general does not allow aggregations. Is there a way out of it or any other path that can be taken to create an action flow to trigger a mail if the last refresh date is more than a day old.

Hi, I am trying to query data in Celonis module in the Action flow . However, I have requirement to split the data into two paths and then prepare a csv and then merge it back into one using a text aggregator. Is there a module that can merge paths in action flow. Or is there a way to split data based on filters and merge or append it into one file

Hello Community,I'm currently migrating my analyses to the new views and have encountered a “problem”. I hope you can help me solve it:Within “Analysis” the table component has the function “calculate share in percentages”.Hee it is possible to calculate the percentage of a column per line, also what percentage of the total for a column a line represents.How does it work in the new views?Thank you so much for help.Best, Thomas  

Hello crowd,I need your swarm knowledge for this issue:I selected July + August in date picker, which is 9 calendar weeks.My objective is to calculate the average sales orders per customer per calendar week.You can see it in my screenshot. One customer per line, count of sales orders and count of calendar week where sales orders are created.The challenge is, that not every customer is ordering in every week.My question is: How do I get the total number of calendar weeks (9) from the date picker in my formula?I would like to divide the “number of orders” by the “total calendar weeks from date picker” and not by the calendar weeks in which the order was placed.Best, Thomas   

Hi, I am just learning about Trigger with Action Flow in an academy.But I am in a trouble how to use a trigger for Action Flow that I made in KM.After making this, I tried to use it but It could not be shown in a setting field.How do i solve this problem?  

Hello, I have received the data set I want to analyze in several CSV files (due to the row limit of 1 million rows). Now I would like to merge this split CSV data set in Celonis, but I have not found the function to do so. The data set is structured in such a way that CaseID, Activity, Timestamp and other case information are each in one line, as can be seen in the screenshot. Thank you for your help.Edit: Sorry for posting in the wrong category, it looks like it can't be changed.

Hey, I wasn't logging into celopeers for some time, congrats on being first! :)Celonis defenitely should send you a t-shirt or something else! Thanks for engagement, probably I'll also return to helping some people here.

We are working on linking the ordernumber from Celonis to a link in SAP perferably to 4hana. Does anyone know of a way we could automatically generate such a link?

Hi Community, while using Send Email action in Views table, there are 2 options:Launch default email program and Send from serverbut second option is disabled and status is ‘In Progress’ (unable to select it and proceed with this option). what’s the meaning of this? is it a permission issue or what?please check attached image as well. 

Hello,  do you know if it’s possible to hide/unhide tabs in a new view as a business user in apps?  

Hi Everyone. I am trying to create a table in Data Jobs, but I want two zeros infront of a number.  nothing I try works? what could the issue be? See ‘00’||”COL-1” 

Hi,is it possible to resend invitation after 14 days of unaccepted invitation, as using “Sharing invitation” task is not working. It is showing message “only user with pending status can be selected” but I selected exactly those users. Would be good if I can resend invitaiton with one click, rather than using blue button “invite new users” and type all emails again..Thanks. 

what insights generation can be done for production order

Hi All, I need a filter that filters out all activities where activity “A” is not first. So i only want to see all cases where the correct acitivty sequence is A → B → C → D...

Hello Celonis community,I’m building a new view and I need to set-up a line chart with multiple lines. Basically, calculating the same value but for different types and plotting them in differently colored lines.In the analysis set-up I used to duplicate the metric for each type and force filter within the PQL metric for the specific type. Now, with the view set-up we can plot only one line, sicne we cannot add multiple Y-axis.Is there a new way (ex. like the “hue” attribute in seaborn library for python) to do this? Or a tip workaround to be able to do it ?

I got the following message. but I do not know how should I solve the problem. Could you please explain the detail? Data model load failed during load to engine: Could not load data model. Load failed. Error Message: Could not execute foreign key join: there are duplicates on both sides of the specified key relationship. Table "A": key column ("E"), key ('00058B2D25244258B806'), rows 1 and 2. Table "B": key column ("E"), key ('EEE3E74B186040F48522'), rows 29 and 35. Celonis Support ID: e9012fd3-bf7c-4e59-9d7a-6b92484458a2

I created an Action Flow for PDF Reporting, but can only select my Analysis. Do you have an idea how to or if it is even possible to get my view(s) automatically into a PDF File.Kind Regards, Max

Hi all, The Celonis module that creates PDF's in Action Flows can't find my View. The Connection seem to work with the App Key that also has the right permissions and the View is also published. I always get the error "Something went wrong while handling the request. Please contact Celonis customer support. Celonis Support ID: e9c4bdad-04c3-49ea-b834-0e2dc618323b" from the 'Analysis' dropdown within the module. Does the Module even work with the new Views (JAB) since the next Parameter I need to fill in is 'Sheets' but the new View doesn't have Sheets, it has Tabs?

I've been experiencing a recurring issue with the sign-in process for both my Bentley and ABB projects. I often get the same error message, and while clearing cookies and history sometimes helps, it doesn’t always solve the problem.Has anyone else encountered this? Any suggestions for a more permanent fix, or is there someone specific I should reach out to for support?

Hi all,I encountered some problems with the Conformance Checker Sheet in the Analysis.I did model a BPMN model and its rather simple but has some AND parallel arcs as illustrated below.In natural language “A,B,C has to be finished before D starts,but the A->B arc and C can happen independently of each other”.In the Overview I can now see Violations like:A is followed by C B is followed by C C is followed by DAll of which I would consider allowed in the sense of the model. Of course I can manually whitelist all of the violations, but this is rather high maintenance and distributes the single point of truth which should be the model. For me it is about understanding if this is a limitation of the Conformance Checker.Did anyone experienced something similar and solved it?Or is my model wrong? 

Hello,As a new user of Celonis, I wanted to check if it's normal that some process connectors, such as the Service Request Management connector (for ServiceNow), don’t come with out-of-the-box applications. In such cases, is it up to us to build our own package from the ground up?

Hi everyone! I am trying to built a Celonis query where I calculate the median time in a process between the Event “DRAFT” and the Event “FINAL”. I would like to additionally get the median value only for one country (e.g. Norway (NO).I have the following query which seems to work without a country condition:MEDIAN( PU_MEDIAN( DOMAIN_TABLE("ACTIVITY_TABLE."ProcessId"), CALC_THROUGHPUT( FIRST_OCCURRENCE['DRAFT'] TO FIRST_OCCURRENCE['FINAL'], REMAP_TIMESTAMPS( "ACTIVITY_TABLE"."TIMESTAMP", hours ) ) ))Now I have problems adding the country condition which would be found in the column ACTIVITY_TABLE.”country”. Maybe I have been starring at the query for too long :D. How do I add it? Best regardsAlex

Everything I’m doing on my OCPM projects (saving and previewing transformations, publishing, running data jobs, loading data models) is taking an obscene amount of time. I’m talking 2+ hours for something that used to take minutes…Is anyone else experiencing this?

Hello all, I would like to know if it's possible to extract the user adoption data/login history from the Platform Adoption View via Pycelonis 2.0.1 (I have the CSV export feature enabled, btw).  I'm trying to navigate to the specific object, but I can't even reach the Admin & Settings panel. Thanks in advance for any help.

Tried with Python script to extract table from the web page, however it didn't work.