Product Q&A

Hello, I was trying to get the Median of a column. But no matter which way he calculates, he just gives me a rounded number. Even if I enter the numbers manually, the correct solution would be 4.54. Anyone have any idea what it is? Rundungsfehler2.png938969 33.4 KB Rundungsfehler.png873927 50.9 KB Thank you in advance

HelloI am trying to filter a OLAP table with the component filter. I have a KPI that is comparing three date values and is capturing the lastest date. I want to filter the OLAP table in the component filter where the Latest Date is blank to not appear in the table.I have tried the following and have been unsucessful:FILTER KPI(LatestDate) != NULLFILTER KPI(LatestDate) != Error message: Operator implementation could not be found or wrong types. Comparator is not implemented yet.Thank you

Hello !I am trying to compare payment terms (ZTERM) from two tables: LFB1 & EKKOCurrently my formula below is not working because the cases where LFB1.ZTERM is showing as - in an OLAP table and EKKO.ZTERM has a value, is not marking it has Different Terms. I have tried ISNULL(column) and = and = NULL.CASEWHEN LFB1.ZTERM= AND EKKO.ZTERM != THEN Different TermsWHEN LFB1.ZTERM != AND EKKO.ZTERM = THEN Different TermsWHEN LFB1.ZTERM != EKKO.ZTERMTHEN Different TermsWHEN LFB1.ZTERM = EKKO.ZTERMTHEN Matching TermsELSE NULLEND

Dear All,in my source data I have a field that I need to convert to Date.My field mask is DDMMYYSerialnumbe and represents barcode.I have used TO_TIMESTAMP and SUBSTRINGTO_TIMESTAMP(SUBSTRING(BSEG.ZUONR,0,2)||.||SUBSTRING(BSEG.ZUONR,2,2)||.||20||SUBSTRING(BSEG.ZUONR, 4, 2), DD.MM.YYYY)Sometimes however bardode has incorrect format. Can I have a function that will convert to date if format is ok and leave NULL is format is not ok?

Hello AllI am trying to capture the latest date of a field.Ex: For VENDOR 1234 which has three separate PO Dates:PO Entry Date 1/1/18PO Entry Date 3/1/19PO Entry Date 2/1/19I would like the result of this formula to display Most Recent PO Entry Date: 3/1/19Thanks !

I have successfully connected via the python API to my Celonis instance.I can see that each folder or analysis has an attribute to access which project it belongs to. ie: folder.projectHowever, if i start from a specific project how do i obtain a list of folders and analyses within it?Im essentially aiming to get something like this to begin with:for p in Project.load_all():print(p.name)for f in p.Folder.load_all():print(\\t\\t+ f.name)for a in p.f.Analysis.load_all():print(\\t\\t\\t + a.name)

I often export results: to Excel, PDF of PNG. However, even more often I make screenshots/screen clippings of charts/items to paste in e-mails, presentations, notes, etc. It would be really neat if the visual representation of a component (/sheet) could be copied to clipboard as an image to be pasted later on.

Hello everybody, Im struggeling with the analysis for my thesis of an ITSM process and hope there is a simple solution, which I just overlook. Explanation: A service ticket is considered as solved in RESOLVED status, the status automatically changes to CLOSED status after 10 days, in any way. So, what can I do to deposit in ALL analyses that these 10 days do not flow into the troughput time never? DLZ.jpg848958 62.5 KB Thank you very much in advance

Hi all, We use the date picker quite frequently in our dashboards; however since we are still loading data manually it is quite important for our users to see what the most current data available is. The date picker already formats the days until data is available dark grey whereas the color is light grey for dates where no data was loaded. Unfortunately, we have different countries with different data sets available (e.g. Data for Germany might be loaded until 15th of March 2019 whilst Bulgaria is available until 1st of April 2019). The date picker shows, in this case, per default always every day until 1st of April 2019 in dark grey, even when the user selects Germany (data only available until 15th of March). In order to not confuse users which date is the most current available data set Id like to add a color coding based on the selection of the country (so that when selecting Germany the last dark grey date is the 15th of March 2019). Any ideas how to do that? And, if not possible

I am trying to check the Number of records that do not comply with std format (XX-XXXXXXX) within a specified field.Any help is greatly appriciated !

Hello, Sometimes we struggle that how we can define activity correctly. Thats why we search for more data driven approach to define activities. For example, for change activities , we get count of changed fields and , then evaluate if it gives any inside or not. As a summary we search for more data driven, automated way for activity detection. Could you please share with your ideas ? Best Regards, Vahide.

Hi Celonis Community, Ive recently started working in PM and am faced with my first real challenges. To answer complex questions of the process owner I would need to execute more complex calculations in Celonis. Im unsure to which extent this is supported. Ive read through the functions documented in the help section and functions highlighted here but could not find any that provide what Im looking for. Is it possible to base a calculation in Celonis on a previously calculated column? An equivalent of what Im trying to achieve might be subqueries in SQL. Im unable to go give insight into the process and will provide a much simplified example. My activity table looks like this: grafik.png886138 2.98 KB Based on this I can calculate a new table with the automation rate per CASE

Dear Colleagues,I have built a custom Process Explorer Activity KPI, that takes the number of activity occurences from Case Level (BSEG table) and aggregates on header level (BKPF). This is because some activities are happing on header level, regardless of how many invoice lines we have. For example I post invoice only once and want to show value 1, even though it can be posted on 5 vendor item lines (BSEG=5).I want to apply the same for Process explorer connection KPI, but I dont know how to handle it.Can you please help me understand how to apply the logic to connection KPI? Details in attachement.Thank you very much (173.9 KB)

Hello, I am building a OLAP table. I was wondering if there was a way to re-structure the table so instead of the single KPI information flowing vertical, it can flow horizontal? I have thought about using a pivot table, however because the data set is so large, it does not seem to be a suitable option. Please let me know. Cheers, Anna

Hello everyone, is there a way to calculate a duration between a specific activity (lets say A) to the next activity (whichever it was). Thank you!

Weve got the challenge that one data model (for O2C) is used by several different business areas like Sales, Logistics or Finance. Every business area likes to get their specific process activities defined in the data model and number of activities increases significantly. In order to avoid that every business area needs to deal with very detailed activities they are not interested in Id like to provide a customized data model for each business area just showing their relevant process activities. Due to license restrictions we could not simply multiply the data model. Now Im looking for ideas how to solve this issue.

Today I loaded the BPIC 2017 event log and noticed that although the event log contains both event and trace level attributes, Celonis flattens all to event level attributes. Feature request: XES import results in both an activities as well as a case table. Minor feature request: support for gzip-ed XES files (BPIC17 is 560Mb as XES XML file, but less than 30 Mb as xes.gz, something you notice when youre working from home).

Hello Celonis Team,Today I am using a variable that is defined within an analysis.How can I define the variable at the Data Model level so that we can use the variable throughout all the analysis that is created using that Data Model?Regards,Sachin

Hello, can someone please tell me how to put R code in Celonis? It is working in RStudio, but when I put it in RCALL or RAGG it gives me errors I do not understand. Can someone please explain to me how exactly RCALL or RAGG works? Thanks Vaclav Juren

Hello, I don`t know what is the correct PQL Syntax for this Activity Selection for my KPI Component option (see screenshot). Thanks in advance for your responses :o)) image.png1061476 22.5 KB

Currently axis ranges can be set to automatic or manual. Issue: What I observe is that the axis range is determined on the >visual< bars/dots/etc. However, this is confusing as scrolling causes the axis to dynamically change. Proposal: Add a third option which either sets the scale to all data points visible and not. Alternatively, but less user friendly in some use cases, allow PQL in the manual ranges (MIN/MAX() would need to be added by the user manually and in sync with the displayed KPIs so not that user friendly.

Currently when adding dimensions/KPIs in the code editor there is a list with PQL functions and a summarized explanation of the feature. It would be really helpful if there would be a direct link from this summary to the Celonis help documenation with usually more extensive explanations and examples.

Dear all,I have a time series plot of the automation rate like the following:x- Axis: ROUND_MONTH(EKKO.AEDAT)y-Axis: KPI(Automation Rate) (standard automation rate formula; should work then with any KPI)My Goal is to calculate the difference in the automation rate between the current month and the previous one i.e. get as result 4.8%.How to do this in celonis? In the end I want to have a list of KPIs which from design point of view look like the followingIs there a simple way to calculate the 4.8% in a dynamic way (the 7.33% is coming from 2 years of data)?Thxs & Br,Stefan