Process Analysis

Hello Celopeers, im new to Celonis and have created a view. There i use a Kpi which drops a lot of zero values. When trying to filter them out i always get the error that aggregated functions can not be used in combination with the FILTER function, and that i should try PU functions. The KPI i'm using is this:SUM( CASE  WHEN round_day("o_custom_KnotenpunktAuftrag"."AusgangForecast") = round_day("o_custom_KnotenpunktFuellstand"."Date")  THEN 1  ELSE 0 END)or alternetively this : COUNT(DISTINCTcase when round_day("o_custom_KnotenpunktAuftrag"."AusgangForecast") =round_day("o_custom_KnotenpunktFuellstand"."Date") then  "o_custom_KnotenpunktFuellstand"."KnotenpunktAuftrag_ID"end) is simply want to calculate for each KnotenpunktFuellstand.Date, how many Order.IDs i have where the filter condition is met.So i can have a table where im us

The reports section is intended for viewing scheduled reports, we do not see any option to configure them. 

Hi Community,I'm working on a use case in Celonis Studio where I want to take inputs from users directly via Studio Views  — such as dropdown selections, text inputs, or button clicks — and then store those inputs in a backend SQL table (in a Celonis data pool).What are the recommended ways to capture user inputs from Studio Views (e.g., via Input Controls or custom components)?

Hi Community,I’m building an Action Flow that sends email alerts based on a flag column (e.g., Alert_Status = 'Yes').The email subject and body should change dynamically based on the record’s status (like Pending, Approved, Rejected).I have a config table that maps each status to a subject and body template.Appreciate any suggestions!

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: 

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

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!