Process Analysis

Hi community.I have a question regarding WORKDAYS_BETWEEN function, currently, I’m trying to get the number of workdays between the creation date of a ticket and its current date, according to Argentine calendar. This is the PQL I have so far.WORKDAYS_BETWEEN ("XXXX"."fields$created",TODAY(),  FACTORY_CALENDAR(            "FACTORY_CALENDAR_ARGENTINA"."START",            "FACTORY_CALENDAR_ARGENTINA"."END"        ))For some reason, the PQL doesn’t return any results for any case. I tried this calculation with other functions like DAYS_BETWEEN instead, and it works. However, I need to take into consideration only the Argentine workdays.I’m not sure if WORKDAYS_BETWEEN supports the TODAY() functions. Has anyone faced a similar problem? Best!

Hey, my goal is to setup a line chart that is showing the “open tickets by time”. The issue is that the status of the ticket is changing in the db, means i cannot say: Last week I had 20 open tickets (because the status of these “old” tickets changed already to closed and not open anymore), this week i am having 14 open tickets → trend is great. Do you have an idea on how i can establish such a graph? Maybe over the activity table or with somehow backups?

Hello, I have an issue with a large number of Action Flow connections being saved under every analyst’s account, and wonder if it is possible to remove them, so that every analyst will only have 1 connection (via their API key) associated with the Action Flows. If it is unclear what I mean, under some Action Flow module (e.g. Query Data), there is a list of connections that you can use to get the module working, which I am trying to delete and establish only 1.  

Hey, I am curently working on creating a dashboard for employees as a view where they can simultanously write back to each line in a custom “comment”-column. Basically the inline editing function from the new Views.Sadly I want to do this for a rather large data model.  Is there a way to have inline editing or something similiar for bigger tables that exceed 30M Rows? Or can I put some sort of filter on that table in the front end to minimize the rows below 30M. Or does it have to be in the back end? Thank you!

Good morning,I need to create a date filter for the start date on a graph, and the date is a user input, so I create a Date Picker as input box and save it as a variable.I struggle with the PQL in my graph FILTER PQL statement:FILTER “table”.”datecolumn” >= {d ‘${my_start_date_variable}’} But I get this error message  How do I adjust my PQL to get the date format correct? The date picker has a standard format that cannot be changed. I also tried this, and it does not work:FILTER “table”.”datecolumn” >= ({d '${my_start_date_variable}'}, FORMAT ( '%Y-%m-%d')) Any assistance will be appreciated.  Thank you,Denise

Hi Team, I used Get Rows and added column names. Then created a Text Aggregator but i can;t see the columns created in the Get Rows, can anyone help me on this.  I need my column name like  “ 4.Invoice ID “ but i got only the Total number of bundles and Bundle Order Position. I tried publishing, ran only get row, re-loaded, even logout and retired.

I have a usecase in which I want to create an object-centric datamodel. According to the linked video below, it is possible to create events based on the attribute of an event (e.g. the event is order, but there are orders in different domains, e.g. games, clothing, …. which is saved as an attribute of this event). Populating this category as the event is possible in a simple case-centric example like explained in the video, but currently this seems impossible for object-centric models? Is this correct or am I missing something? I would like to avoid creating single events for each category.https://academy.celonis.com/learn/video/create-events-based-on-their-attributes

How do I get to see what is the trend of events and connections as a business user? Order count with common number of events/connections - default view nowOrder count with least number of events/connectionsOrder count with most number of events/connections Finally, I want to build a histogram to determine what is average number of events/connections for orders to identify trends. 

BackgroundThree tables and their relationship as below:VBAP(1) : VBFA(N) : Memo(1) RequirementI want to create a table with three columns: Column #1: “Reason Code”( From table: Memo , it is a dimension column)    , it is doneColumn #2 : “Memo#” ,  with PQL: COUNT(DISTINCT "memos"."vbeln" || ' ' || "memos"."mandt"   , it is done Need your help on this:Column#3:  “Total number of VBAP” . I don’t want the value of “Reason Code” cross filter table “VBAP” which means the all the value should be the same , for example: 13298   I have tried 2 PQL below:PQL#1:Global (  SUM (    PU_COUNT (      "Memos" ,      BIND (        "VBFA" ,        "VBAP"."VBELN"      )    )  )) PQL# 2:                GLOBAL ( COUNT_TABLE ( "VBAP"

Hello everyone,I want to connect a whole dashboard via profile view to another dashboard. The connection is EKKO.EKGRP → the profile view dashboard will be filtered according to the purchasing group EKKO.EKGRP - so that works fine. My question is whether it is possible to map further criteria to be synced automatically with the profile view. In my case, the sync filter functionality standalone does not work as the time dimension e.g. in dashboard 1 != dashboard 2. So in case, I have selected the year 2025 in dashboard 1 (Base _CEL_P2P_ACITIVITIES.EVENTTIME) - the sync filter does not work as the time dimension in dashboard 2 (CUSTOMIZEDTABLE.ERDAT) is not the same. Is this somehow possible? The profile view which I have connected also contains a filter bar which is not accessible when connecting it. Is this also possible? Thanks for your help! Best regardsJulia Bauer 

Hi all,I’d appreciate your help with creating a stacked bar chart.In my dataset I have cases which are generated due to 1-4 issues. I have Error_count (type INT) and Product (type STRING) as case attributes and have a KPI defined for case count.I’ve selected the component Stacked bar chart. I’ve selected Count of cases as the first stack, while Error count is a dimension.How do I stack the chart per product? I’ve attempted adding Product as an additional dimension, but that doesn’t get me the outcome I want.I look forward to hearing from you. Thanks.Kind regards,Vladimir

Hi team,I have an issue with the Throughput Time Explorer in one of our Views. When I add it to a existing or New Tab, I get and error:Throughput Time Explorer [id:  ...]: Syntax error near [FIRST] after reading [“] at line 3. Please refer to PQL documentation for available syntax.Please see attached screentshot:I’d really apreciate your help with this. For context, I use the Througput Time Explorer in other packages with no issues whatsoever.Kind regards, Vladimir

Hello Community, maybe I am just blind and didn’t find it yet in the documentation, but could it be that there isn’t any possibility to determine if there is a number in a specific pattern?I’ve got a column “unit” which got values like ‘A123’ and ‘AB12’ - I need to filter out every unit which got no number on second position.Like in regex, I can do: ^(.)\d to get if the second character of my string is a number.SQL Patindex also can do very basic capturing groups like %[0-9]%  - which will give me 2 if the first number is on second place. At the moment I am doing this with this PQL:TO_INT( SUBSTRING("TA_MR_PKC_EVENT"."BEARBEITENDE_ORGA",1,1))Which results in NULL if the second position isn’t a number - I can work with that, I am totally fine about it -  but I am a little bit curious if there is an more elegant way in doing this. Best regards,Fabian

COUNT(  CASE    WHEN PROCESS EQUALS (      "_STD_CEL_AP_ACTIVITIES_TABLE"."ACTIVITY_EN"      EQUALS (("_STD_CEL_AP_ACTIVITIES_TABLE"."ACTIVITY_EN")* to ANY to 'Remove Payment Block' END )    )    THEN      "BSEG"."MANDT" || "BSEG"."BUKRS" || "BSEG"."GJAHR" || "BSEG"."BELNR" || "BSEG"."BUZEI"  END)I haven’t used PROCESS EQUALS before, and I’m finding it difficult to understand its syntax even after going through the documentation. I want to use it in view, so if you have any insights or examples on how to use it, please let me know.

After creating my target model in the Process Adherence Manager, I want to be notified about:Missing events Unexpected events Incorrect event orderWhat is the best way to connect the results from the Process Adherence Manager to an Action Flow, so that I can automatically trigger alerts or follow-up actions based on these deviations?

Hi,I have a defined KPI in my knowledge model to calculate the median throughput time for my process: MEDIAN (CALC_THROUGHPUT ( CASE_START TO CASE_END , REMAP_TIMESTAMPS ( "CONSUMER_APR_ACTIVITY_TABLE"."EVENT_DATE" , DAYS ) ))I’d like to be able to compare median throughput times for all cases and only for cases which include a certain activity (for example: PENDING). I’d like to use either a table or a bar chart for this comparison.What would be the best way to achieve that, considering that table filters apply on all columns? Can I introduce another KPI which will determine the median for cases which include PENDING only? If yes, how can I do that?I look forward to receiving advice. Thanks.Kind regards, Vladimir

Hi,Shall we consider Production Order Journey as Work Order Journey.   

How can i enroll for introduction to process mining course. I do not see the enroll option….

はじめまして。Celonisのバリアントエクスプローラーのエラーについて、投稿いたします。現在、View内に設置したバリアントエクスプローラーを開くと以下のエラーが発生します。・直接開いた場合　Variant Explorer [id:variant-explorer-531a92c8-92cd-4f1f-a10e-86a23a3ae35c]: Invalid PQL query. VARIANT: The specified activity column ["_CEL_PGM_WLM_VE_ACTIVITIES"."ACTIVITY_EN"] contains 36487 distinct activities. However, this component only supports 32767 distinct activities. Please review your PQL statements in the Knowledge Model and in the View YAML filters.原因と対応策について、ご意見いただけないでしょうか。よろしくお願いいたします。　

Using Intelligence API, how to get to the pql statement behind the filter

Hello,I’ve just finished the OCPM training. In there you create objects with multiple object to object relationships and events with multiple object to event relationsships. So e.g. the object “Expense” has a relationship to the “Report” object and the event “Approve Report” has multiple relationsships, e.g. to the object “Expense” and “Report”. The resulting Process Explorer can be seen in the right picture. As another test, I’ve duplicated the events and deleted all but one event to object relationsships. So each event has only one relationsship to one object. When displaying a Process Explorer with this Event Logs (see left picture), I get the same result as with multiple event to object relationsships. Also when filtering on tables with data from the source systems, i get the same filtered results on each of the Process Explorers.Am I missing something or what are the benefits of multiple event to object relationships? 

Hi everyone, We have several ABC Classifications that we need to implement in Celonis and I’m simply curious:Why is the ABC classification resulting in a 1, 2, 3 ranking? I’m ending up having to convert to string and remap the values for each classification so that it makes sense for the users and while it’s not a huge issue, I think it would be easier if the function just resulted in A, B, C directly. Is it for efficiency by using integers?  Or does this allow for some further analysis that I’m not seeing at the moment maybe? Best regards,Benjamin

Hello everyone, 👋I’m building an overlay view to show case details, using number as a variable.Currently, the overlay view has a predefined filter like this:FILTER "sc_req_item"."number" = '${number}'; However, I’d like to make the overlay more dynamic — for example, use another variable ${case_table} to replace "sc_req_item" (or even "sc_req_item"."number") so that the same detail view can work for multiple case types, such as Requests, Request Items, and Tasks. Has anyone successfully used a variable for table or column names in a FILTER statement (or found another way to make one detail page work dynamically across multiple case tables)?Any insights or workarounds would be really appreciated! 🙏 Thanks!BR,Xiangxiang

Hi everyone,I’m using the Grouped Column chart in Celonis Views, and I noticed that the data label position (currently displayed in the center of each bar) can’t be changed to the top or outside end — unlike in Analysis charts, where this option is available under formatting.Can anyone confirm if the label positioning feature is planned for a future Views release, or if it’s already available in any recent update?I reviewed the documentation below but couldn’t find a clear mention for Views specifically: Analysis — Charts and Tables — Settings

Hi everyone,I'm currently working on a use case in Celonis and could use some help with a PQL rule I'm trying to build.I have a table called HOTEL that contains travel records, each with a start date and end date. I want to validate that every single day within the travel period is marked with a "J" in a calendar table called CALENDAR.For each travel record in HOTEL, I want to:Iterate over all dates between STARTDATUM and ENDDATUM. Check if the corresponding calendar entry for each date has the value "J". If any date within the range does not have "J", I want to flag it as an error.Does anyone have an idea how to solve this problem in a pql formula as a KPI?Thanks in advance 🙌Niels