General Product Q&A

Hi There,  I would like to get Average throughput time between activity A and whatever activity coming after A. For example;Case 1 / Activity Sequence: A->B->C->D->A->ZI need the sum of throughput times case level (A->B) + (A->Z)I also need number of occurrences of A case level (2)..Finally my resulting KPI formula will be like;Total throughput time (A and next activity) / Total Number of Occurrences of A How can we make it happen in PQL? Thanks in advance, Best Regards,Oguzhan    

In the attached photo, the number of cases is duplicated and counted.I want to know the PQL that solves this.

I have gone through the explanation in documentation, but didn't find it to be detailed enough. Can somebody please explain with certain examples ?

Ready to seize unlimited opportunities?Visit the EMS Marketplace from your EMS team and discover the different new Apps, Extractors, Connectors, Action Flows added every week we are offering to our global customer base made by Celonis and Partners.Visit the EMS Marketplace or find your team. Recently Added: IBM work order management for manufacturing IndustryWork Order Management application provides an operational dashboard to monitor, plan and streamline the end to end lifecycle of a work order, Identifying bottlenecks and processing differences based on various dimensions for continuous improvement and faster lead times, digitally transforming the work order process to improve data quality and reporting & providing automation for faster fixes. IBM record to analyze month end close:A recurring challenge faced by F&A operations team is the ability to control and monitor the close of each financial period. The Month end close (MEC) process is pretty complex and intense as it is

Some times working fine and some times getting below error  Change log extraction failed!. Change log strategy not specified. Celonis Support ID: 889395d9-5218-4e84-a325-da537c6a4aa5

I have a question - how does the function "having" work in Celonis PQL? I need to select case where Count(Activities)>3. How can i do it is Celonis? Thank you so much!

Dear all, I have checked with Coupa and Oracle both connectors, its shows the below error. How to resolve these issues. Thanks Regards,Jayaraman.M

Good evening guys,I would like to calculate the total throughput time of a sub process which can occur multiple times within one case. The subprocess always starts with a unique activity and ends with a unique activity. There might be different activities between the start & end activity (see picture). I tried my best by using the MATCH_PROCESS_REGEX function but didn't succeed. Thanks a lot for any hints and suggestions! Cheers,Alex 

Hi all,  I am trying to transform the data from multiple excel files into a single activity table but while I am transforming the timestamp field. it shows the error below:Execution error: ERROR: Column "_EVENTTIME" is of type timestamp but expression is of type varchar When I upload the file I have already indicated the field as DATETIME field Therefore i am not so sure about how this went wrong, appreciate your time and help in advance!

How to create bar chart and line chart in Celonis as the way we create in excel with secondary excess.

Where i can find Celonis Analyst training ?

Has this product been used with an ETRM/CTRM system? If so what systems?

Hi,  I am trying to display the time difference in days on the 2nd column between each task on the 1st column (which is shown in the process flow explorer already) but I would like it in a table format.  So instead of giving me the overall throughput time from process start to end, is it possible to get the days between tasks? This can be seen below: 

We are working on one use case here, we have two systems one is SAP & other is readsoft workflow. when ever an invoices is processed then that invoice will enter into SAP from readsoft means SAP BSEG table consists of the processed invoices and readsoft table consists of both processed and non processed invoices. where in the data model we are taking BSEG table as a case table and joining with readsoft table. when we load the data model we are able to see only processed invoices in the studio but unable to see the non processed invoices from the readsoft table. could anyone you please help us how can we get those non processed invoices into stuido.

The session I want to enroll in, has a link I cannot press because it is hidden behind the screen of another course

I've created an activity table in which I've created a level column that will contain 1 or 2 depending on what I would like to display. In a dashboard, I have made the following tests with no desired results: Created a process explorer sheet and add the activity table to it. Add a filter to the sheet in order to display on the process explorer activities of level 1.Created a new sheet to which I added a process explorer component and added a filter to the component itself. None of above cases worked. Is is possible to filter activities display in a process explorer? Thanks

I would like create a single KPI that uses a conditional count. This KPI should display the count of the number of cases within a process that has a duration < 60 days between two specific events.

Can we create Boxplot in View ?

Problem: In the dataset I am working with, a mistaken batch process in the source system added extra timestamps which are throwing off throughput times.  Objective: My objective is to map to null all activities in my activity table which are repeated back to back. Example: In the simplified table below, I would want the final activity to map to null since it is a repeated activity &quot;c&quot; of the same work order &quot;3&quot; Table = &quot;Celonis_Remap_Practice_csv&quot; Partial Solution:I created a custom dimension on a variant explorer with the following code: CASEWHEN   &quot;Celonis_Remap_Practice_csv&quot;.&quot;Activity&quot; = ACTIVITY_LAG (&quot;Celonis_Remap_Practice_csv&quot;.&quot;ACTIVITY&quot;)   AND INDEX_ACTIVITY_ORDER ( &quot;Celonis_Remap_Practice_csv&quot;.&quot;ACTIVITY&quot; ) &gt; 1THEN NULLELSE &quot;Celonis_Remap_Practice_csv&quot;.&quot;Activity&quot;END; This effectively removed the duplicate activity from the variant explorer, but I want duplicate activi

We are trying to obtain the profile name of our Team URL for using it in the Machine Learning Workbench. So far, only one of them works correctly.

If yes - can this include parallel gateways to reflect activities that can de done at the same time?

Am i able to amend the 'Happy path' flow of tasks? If yes - can this include parallel gateways to reflect activities that can be done at the same time?

Hi, I have this pie chart and was wondering if there&#39;s a way to hide null values? (the grey area)  thanks,terence

When I log into my environment I see this message:The data model assigned to this analysis could not be found. Please assign a valid data model.What is going on?

Hi all, suppose I have the following activities in my process (there can also be other activities in the process but they are irrelevant for the cycle time calculation):Send POChange Price, andReceive Vendor Confirmation --------------- In my process, possible process variants are: 1.Send PO --&gt; Change Price --&gt; Send PO --&gt; Receive Vendor Confirmation or 2. Send PO --&gt; Receive Vendor Confirmation  or (and this is where things get tricky) 3.Send PO --&gt; Change Price --&gt; Send PO --&gt; Change Price --&gt; Send PO --&gt; Send PO --&gt; Receive Vendor Confirmation  --------------- -&gt; My goal is to find an expression that always calculates the cycle time between the FIRST Send PO activity that happens after the LAST Change Price occurred and the FIRST Receive Vendor Confirmation activity.Now, it is relatively easy to define the second part of the cycle time calculation because I can simply take PU_FIRST for the Vendor Confirmation activity. However, I am unsure how to re