General Product Q&A

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

Hi! I have a large activity table and am confused how to calculate the difference between current line timestamp and prior line timestamp. example: line 2 timestamp - line 1 timestamp, then line 3-line 2, etc through all the steps of the case I can do this in the PQL with a lag function but was advised to look into this from a Celonis calculation. Is there a particular function I should be looking at or a way to do this? While the case explorer, this seems to be done automatically, but I cannot figure a way to do this within a dashboard. Thanks!

I am trying to update an activity table in an ongoing analysis, I tried to follow this guide https://community.celonis.com/t/how-to-update-the-activity-table-with-a-new-version-of-a-csv-file/3764 But I get the error 403 (same as discussed in the question). I have updated the table once sucessfully but updating a second time yields this error. Is it. a restriction in Celonis that this feature is only available one time per user?

Hello,I have manage engine skills that I created from my olap tables.Whenever some cases occurs I want to take some actions with my action flow sequence.But how do I get these datas from my skill. Celonis data query module does not confirm my needs because my query uses match activity etc.

Hello, Does there exist any existing documentation or external links that can be used to start a customer training roadmap? You have a client that you have engaged with C4C+. As expected, the client is excited with your findings, presentations and what Celonis can do. The client wants to go to the next step: purchase Celonis and start ramping up.. Is there any material, documentation or other that could be provided as a roadmap to the client to bring them up to speed so they could be adept at using Celonis? I suspect this would include Celonis Academy but what topics for what role? (before the Academy upgrade there was a good list of courses to take per client role but that is no more). thank you.Rob

Hi, i&#39;m starting working with views, and I couldn&#39;t find any options or YAML code to visualize the values of a bar chart on views mode. I&#39;ve been looking on Celonis cloud help as well but couldn&#39;t find it. Any help would be appreciated. Thanks!

I have raised a ticket but i did not get any response from Celonies , how to escalate this ?Can you please suggest on this

I see the in Configure Response, the XML but the values are not in there. Problem i have now is that I can not use this end point as a dependency for another end point due to no values.

Is it possible to sort the Celonis In-built dropdowns for Filter Selections (In Component Filter) in an alphabetical order? We do have the table names sorted alphabetically but not the column names (It is shown in the order as we defined with the Data Jobs). Is there a sorting function available so that our users can easily identify the column name in case large number of columns. Thank you 

Have somebody already use Celonis with BMC Helix for process mining ?

Hello,We want to write a formula to collect the NOV amounts of the people with all two constraints, can you help? CASE WHEN &quot;_CEL_P2P_ACTIVITIES&quot;.&quot;USER_NAME&quot;=&#39;X&#39; AND (&quot;_CEL_P2P_ACTIVITIES&quot;.&quot;ACTIVITY_EN&quot; = &#39;Submit Purchase Order&#39;) AND &quot;_P2P_TCL_POSITIONS_V3&quot;.&quot;eylem_sahibi_division&quot; = &#39;CORPORATE LEGAL AFFAIRS&#39;THEN KPI(NOV)WHEN &quot;_CEL_P2P_ACTIVITIES&quot;.&quot;USER_NAME&quot;=&#39;Y&#39; AND (&quot;_CEL_P2P_ACTIVITIES&quot;.&quot;ACTIVITY_EN&quot; = &#39;Submit Purchase Order&#39;) AND &quot;_P2P_TCL_POSITIONS_V3&quot;.&quot;eylem_sahibi_division&quot; = &#39;CORPORATE LEGAL AFFAIRS&#39;THEN KPI(NOV)...ELSE 0END

My case: (  SUM (    CASE      WHEN        PU_COUNT (          &quot;Vorgänge_mElement_xlsx_Sheet1_CASES&quot; ,          &quot;Vorgänge_mElement_xlsx_Sheet1&quot;.&quot;Aktivitätsbezeichnung&quot; ,          &quot;Vorgänge_mElement_xlsx_Sheet1&quot;.&quot;Aktivitätsbezeichnung&quot; = &#39;&lt;%= Abbruchaktivitaet %&gt;&#39;          AND          &quot;abgeschlossen_xlsx_Sheet1&quot;.&quot;ABGESCHLOSSEN&quot; = 1        )        &gt;        0      THEN        1    END  ))/( SUM ( CASE WHEN &quot;abgeschlossen_xlsx_Sheet1&quot;.&quot;ABGESCHLOSSEN&quot; = 1 THEN 1 END ) ) If I only calculate the dividend, the correct value appears, also if i individually calculate the divisor. But when I try to calculate the quotient, the result is wrong. For example the dividend = 4 and the divisor = 9 the result need to be 0.444 but it appears 0.797 as result. Is that a bug by Celonis or what did I make wrong? Thank you in advance. Kind regards,Ivo

In content.training celonis. We have demo packs for P2P and order Management , can we access similar demo packs for any Sustainability package?

The account type is selected as guest instead of partner when signing up. How could I change the account type?

Hello, I want to create a custom dimension for the variant explorer in order to remap certain activity values to NULL. However the activities need to be remapped based on a corresponding table which holds information regarding which activities need to be remapped to NULL. For Example -&gt; In the above images which are connected to each other in the process data model. What should basically happen is that activities A,B,D should not be changes but activity C should be remapped to NULL. Is there any way to implement this using PQL while building the analysis?

Hi,adding custom KPI such as &quot;Automation Rate&quot; can by done in the Process Explorer of an Analysis. But this option is not available in the Process Explorer within a View. Is this by purpose? If yes, what&#39;s the intention behind it? I would like to show a low automation rate in order to use ML to automate incoming orders. Thanks!

I am going through Business Architect Value courses specifically in 'Guided Tours: Create Benchmarking, Dynamic Drilldown Table' and the Guided Tour, "Create Benchmarking", in the Academy icon is nowhere to be found. How can i retrieve this guided tour?