Process Analysis

Hi all I am wondering how to best add a custom KPI defintion to the Variant Explorer.Mainly I want to add my custom process specific defintion of a througphuttime. Me and my endusers don’t care about the default End2End TPT that Celonis always uses as default but rather the time between two specific activities.Instead of (or at least additionally to) the “Avg TPT” Column in the selection panel I would like to use my Metric “Median CustomProcesstime”.Does anyone know if this panel can be changed? Maybe via YAML?  

Hi, has anyone created a data model for Accounts Payable using SAP FI-CA data?Could you please advise on its parameters - what do you take as case ID, which additional tables your add, which activities do you extract, etc.?

Hello,I am quite new to PQL and I tried to assign costs to spesific activities depending on the predecessor.When B is followed by C, only C should be assigned with certain costs. When A is followed by C, again C should be assigned with costs, but with a different value. The result should look like this:CaseID Time Activity Costs 150488 07:34 A   150488 08:30 B   150488 09:23 C 0,84 150488 09:45 D   150488 10:34 A   150488 11:45 C 1,56 150488 v E     I tried this with the following code: CASE  WHEN "ActivityTable"."Activity" = 'C'   AND MATCH_PROCESS_REGEX (    "ActivityTable"."Activity",    'A' >> 'C'   ) = 1  THEN 1.56 WHEN "ActivityTable"."Activity" = 'C'    AND MATCH_PROCESS_REGEX (    "ActivityTable"."Activity",    'B' >> 'C'    ) = 1   THEN 0.84 ELSE 0END Unfortunately the table looks like that, so it assigns the wrong costs: CaseID Time Activity Costs 150488 07:34 A   150488 08:30 B   150488

Hey People,I need help sorting a coloumn in a table where each item number appears twice with a corresponding "Potential Savings" value. My goal is to sort the "Potential Savings" coloumn in descending order while keeping duplicate Item Numbers together (as shown in the current table). However, when I try to sort "Potential Savings," the duplicate entries get separated.Does anyone know how to sort the table in a way that maintains both the descending order of "Potential Savings" and keeps the duplicate items next to each other?Thanks in advance! Vendor Name Business Unit Item Number Commodity Last Order Date Expected Delivery Days Unit Price Potential Savings Alpha Supplies P18 0410390025 I030 2004-01-29 27 10.45 52.66 Beta Industries P20 0410390025 I030 2004-02-09 0 6.90 0.00 Alpha Supplies P18 0437150201 A110 2004-07-31 40 40.67 69.35 Gamma Solutions P20 0437150201 A110 2004-08-26 50 32.00 0.00 Alpha Supplies

Hi team,I was trying to follow as per below screenshot.But i am not able to find a record in task list although added in knowledge model(Attached screenshot below of task list component and knowledge model respectively)Can someone please guide me on this?Thank you in advance!

We have created a OLAP table which we have connected to a skill.In the skill we have created Manual Sensor and enabled the manual selection option but it is not working correctly.In the OLAP table we have also added URL in "Allow Data Service Link" 

PROCESS FLOWNeed some assistance, I have a CaseID, Activity and Timestamp. I need to get all the cases where the activity flow is A to B to C. (NOTE: the activities don't have to be directly followed by) I cannot use MATCH_PROCESS_REGEX or any other commads. I need to used CASE WHEN, AND, ACTIVITY_LEAD etc... to solve this. Please help me out. My approachCASE WHEN "tab"."Activity" = 'A'AND ACTIVITY_LEAD(CASE WHEN "tab"."Activity" = 'A' THEN "tab"."Activity" END) = 'B' AND ACTIVITY_LEAD(CASE WHEN "tab"."Activity" = 'B' THEN "tab"."Activity" END) = 'C'  THEN CaseIDEND

Is it possible to enable/disable or hide/unhide a button in Celonis Studio Views. Basically i want to enable the button on certain conditions applied in the filter dropdown inputs.

Hi I, I am configuring my PAM but keep running into these errors.  ErrorSupport Id: faafa039-b13e-47e6-88cd-7e64c7f898e6PQL Error during operation: Events - Count. Repeating the request will always result in error. Fix this by changing the current asset state. If the error persists, please contact support. ErrorThere are event logs in your selection which are no longer available or valid:EL_CUSTOM_OTTPAYMENT__ACTIVITYI created a second eventlog with the required names for my activities and this works when I use it for process explorers and case explorers, but when I try and use it for my PAM I get the error messages. Here are my eventlogs: 

I am working on use case where i want to filter the view when user log in into celonis .user has two types one general buyer and second tactical buyer so when general buyer login he should access only general buyer data and when tactical buyer log in he should access only tactical buyer data so i need help to create this filter if its possible how i build it in celonis Thanks in advance

I am aware of PQL that checks if activity A directly follows B. Can someone help me with PQL to check if first/last occurrence of A directly follows first/last occurrence of B?

I want to write PQL that gives me number of instances of object type O1 which is related to n instances of object type O2. Ex: Number of Purchase Order which is related to 2 instances of payment. There is no 1:N relation between these table. In this scenario, is it still possible to get number of instances of one object based on how many times it is related to other object type?

I am new to Celonis. I have this dilemma on ‘Why do tables exists when we have OLAP tables’.What is the purpose of two of them existing?I know tables are present only in views while OLAP tables in analysis.What are all the differences or things we can do with tables and OLAP tables seperately? 

How to setup scale picked based on annotation value of line chart,I have three annotations lines upperlimit,lower limit and average if the average comes as 95% i want the scale to be displayed from 91,92,93... to 100,I know we can configure manually in component settings but is there any other way ?

I have some confusion as to why analysis and views exist as separate entity. When both of them serve the same purpose despite the differences in availability of some features.

I want to add a button or a checkbox against each record in a table component in view studio. This button or checkbox will dynamically set the value of a column in variable which will be used for filtering purpose in another view in same package. 

Hi,How can i filter it to show the values from last year?PU_LAST("o_celonis_MaterialMasterPlant", "O_celonis_PurchaseOrderItem"."NetUnitPrice")Thanks!

Is there a way to remove duplicate values in a coloumn ? 

Hi,Is there a way to compare the value of the 2 row and return the one that is smaller and then sum all the smaller values together ?Sampleid 1 = 5id 2 = 20id 3 = 7sum = 5+20+7 = 32

Hello everyone,I hope you can help me understand the difference between the two PQL functions CASE WHEN and STATIC CASE WHEN.I can't find the difference using the documentation, and unfortunately, I couldn't find any content about it in the forum either. I would really appreciate your help and hope someone can explain it.Thank you for your support!Best regards,Robert

Hi fellow Celonis user,For some reason i cant make use of selections ( at the top). In the screenshot below you can see that this option is not available. Also i can't change this in the general settings. Hope someone can help out. Thanks!  

I’m attempting to create a bar graph that shows opportunities created by quarter (Q1, Q2, Q3, Q4). However, I want to include incomplete quarters (ex: Q1 - 2025, but I have no data for March 2025, only Jan 2025 and Feb 2025, but I still want to show this quarter). Is there a way to do this? I’ve tried a bunch of things, but none make the incomplete quarter appear. Thanks!

Hello everyone, have you thought about integrating line breaks into Tables of the new views? Can you please give us a brief update on this.Thank youStephan

Hello,I’m new to Celonis, currently trying to estabilish Action Flow that sends PDF reports.Is it possible to send “Email from Celonis” from Skill in Action Flow?RegardsFilip Kin 

Hey,I have an activity that every case has to go through. I would like to know how long the time is between each case. (This is interesting for me because only 1 case can go through the activity at a time and we want to analyze the “empty” time).Does anyone have an idea how to calculate this?Thanks for helping!