Celonis Community | Community

Latest Posts

Recent activity
Help others

How to filter table rows based on aggregated column values in Celonis?

Hi everyone, I’m working on an analysis in Celonis and I have a question regarding filtering table rows.In my case, one of the columns in my table displays a sum of values retrieved from the backend (e.g., SUM("SomeColumn")). I would like to exclude all rows where this sum equals zero, so they don’t appear in the final table.How can I apply such a filter directly in the table configuration or via a filter condition?Thanks in advance for your help!

13 hours ago

Kamil DerenLevel 2

General Product Q&A

Active Action Flow list

Hi, I am trying to create a list of Action Flows using PyCelonis and I want to also add status if the Action Flow is currently active or not. I was trying to do it .get_action_flow(id).dict()/json()/json_dict() but there is no parameter there that would indicate if the Action Flow is activated or not.Thanks in advance for any replies :)

101

13 hours ago

harshshLevel 2

Community Connect

Trigger and Action Flow

I want to create trigger for a action flow. Im not sure how to do it, I am creating a trigger in the KM but that trigger is not showing up in the Watch Trigger module in the action flow

15 hours ago

Phuad KaraevCelonaut

Community Connect

🚀 Hype & Reality: Charting the AI Roadmap with Robb Wilson (Virtual Live Event)

Dear Celonis Community, AI is moving fast, and agentic AI is becoming a major focus. For many, it’s not just a buzzword but a direction they’re actively exploring. Still, figuring out what it means and how to get there can be a challenge. That’s why we’re excited to invite you to our next Face Value session: Hype & Reality: charting the AI roadmap with Robb Wilson📅 Tuesday, July 29 at 10am ET / 4pm CEST Robb is the CEO and co-founder of OneReach.ai, author of the bestselling Age of Invisible Machines, and host of the Invisible Machines podcast. His work has been called “prophetic” and “essential reading” by leaders at Google, Microsoft, AWS, and Meta. In this session, Robb will share:💡 What agentic AI actually is and where it’s going⚙️ How companies are moving from simple automation to hyperautomation📘 What strategies and technologies are helping businesses stay ahead If you’re thinking about the future of AI and want a clearer view of what’s next, we’d love to see you there. 👉

160

1 day ago

phil.cookLevel 3

Process Analysis

Identifying the First Instance of an Activity as well as Its Follow-up Activity

HelloIn a scenario where there are multiple instances of “WIP CB IP” activity, I am trying to identify the first instance along with the next activity taken by a user. I am easily able to identify the first WIP activity (highlighted in blue) using PU_FIRST. However, when I attempt to identify the next activity following the first WIP, I end up retrieving the activity for the 2nd WIP line (highlighted in yellow and red). I would like to report on the activity highlighted in green.I have tried wrapping the PU_FIRST within the ACTIVITY_LEAD but the syntax failed indicating that “/IRM/IPCBITM” is not within the Activity table. I have also attempted to use a CASE WHEN statement but that just generated two WIP lines. I am only interested in the first instance of WIP.Thanks in advance,Phil

150

1 day ago

harshini.gampa12Level 2

Process Management

Report Generation -- Standards and Standards Chapter matrix , Process performance analysis

Hi Team,We would like to generate the Reports in Process designer i.e Standards and Standards Chapter matrix , Process performance analysis .Can you guide us how to create the above mentioned highlighted contents in report.

1 day ago

CelonisAcademyLevel 4

Celonis Academy Group

Hot Topic: There is no AI without PI.

All technology needs the right input to succeed. AI is no exception. Let’s take the example of GPS - something we’ve all used. Imagine you were navigating through Manhattan but only had data on the streets, buildings, and bridges without any context on how they relate. Imagine how much easier it is to navigate when you understand how everything’s connected and fits together. But no system provides this for the enterprise today. That’s where Celonis comes in. It gives AI the same input that map data gives a GPS by creating a map of the enterprise and connecting all the data across your systems and making sense of it so AI understands how your organization uniquely runs and can effectively automate key tasks in your business processes.Do you want to find out more? We've got you covered!Celonis Academy enables you on our latest and greatest AI-backed products and solutions to ultimately transform your process understanding and drive significant business value. You'll learn all about the A

100

2 days ago

CelonisAcademyLevel 4

Celonis Academy Group

Follow Your Learning Journey!

At Celonis Academy, we understand that every individual plays a unique role in leveraging the power of Process Intelligence.That's why we've crafted dedicated learning journeys for each user role, from Business Users who focus on day-to-day operations and insights, to Data Analysts who build powerful analyses and automations, all the way to Celonis Leads who drive strategic adoption and manage Centers of Excellence. Each of these tailored paths ensures that you can effortlessly discover and engage with the most relevant training for your specific needs, providing a clear and structured progression designed to help you master Celonis and unlock its full potential for your role.Watch the video below for a quick overview! Discover your learning journey here!

2 days ago

CelonisAcademyLevel 4

Celonis Academy Group

What is the Celonis Academy Group all about?

Welcome to the Celonis Academy Group, your dedicated space within the Celonis Community for all things learning!This group is designed to be a dynamic hub where Celonis learners like you can connect, collaborate, and grow. Here, you'll be able to engage in lively peer interactions, share your learning experiences with others, and directly interact with Celonis Academy experts. We encourage you to share your best practices, discuss anything related to online or instructor-led training, and even showcase how you've applied your Celonis Academy knowledge in your daily work!We're thrilled to have you here and can't wait to see the knowledge sharing and connections that will flourish. To get started, we invite you to become a member and create your very first post! Share with us your experiences with Celonis Academy so far, and tell us: what's been your favorite course or training track, and why? Let's build a vibrant learning community together! 🚀

2 days ago

julia.bauerLevel 5

Process Improvement

Add Powerpoint Attachment to Mail Sent by AF

Hello everyone, this is my current AF setup: The setup works fine, however, I have received the requirement to add a powerpoint attachment to the mail sent via the AF. This powerpoint is static and is only a training document for the recipient. Is it possible to add attachment from your computer to be sent out by the AF itself? I cannot add this via the data and title fields since it’s already ready and static. Thanks! BRJulia Bauer

2 days ago

Yannick NoubissiLevel 2

Process Analysis

How to filter table rows based on aggregated column values in Celonis?

13 hours ago

Kamil DerenLevel 2

General Product Q&A

Active Action Flow list

101

13 hours ago

phil.cookLevel 3

Process Analysis

Identifying the First Instance of an Activity as well as Its Follow-up Activity

150

1 day ago

harshini.gampa12Level 2

Process Management

Report Generation -- Standards and Standards Chapter matrix , Process performance analysis

1 day ago

julia.bauerLevel 5

Process Improvement

Add Powerpoint Attachment to Mail Sent by AF

2 days ago

gayathriLevel 3

Community Connect

Request to Swap First and Last Name on Profile – Urgent & No Response from Support

Hello Celonis Community Team,I’m reaching out regarding an important update I need on my Celonis profile. I would like to swap my first and last name – currently, they are displayed in reverse order.Despite emailing support three times over the past few weeks, I haven’t received any response. This update is crucial for my certifications and professional visibility. I kindly request your assistance in getting this corrected at the earliest.Please let me know if any additional information is required from my end. I appreciate your help and look forward to a quick resolution.Thank you,[Gayathri Vanam ][vanamgayathri13@gmail.com]

464

6 days ago

carmen.kaluzLevel 3

Data Ingestion & Infrastructure

Use App Key for content-cli in ML workbench

Hi all,I would like to export datapools as json using content-cli in the ML workbench in order to backup them in Git. I have created an API key in my profile and used it in a python script with content-cli pull data-pool --id data-pool-id, which successfully generated a json of the datapool.However, I don't want to do this with a user-based API key but with an Application key (created under admin&settings).When I run the same command using the Application key, I get the error "error: The provided team or api key is wrong."With get_celonis(api_token=“applicationkey”, key_type="APP_KEY") however, I can see the Application key and all its permissions.Is content-cli possible with an Application key and if so, how can I use it?

283

7 days ago

christine.gentrLevel 2

Process Analysis

Need Help Fixing PQL script to look for a variable direct after a wildcard search using the LIKE function

Hi,I need help fixing my PQL scriptCASE WHEN "SHOPPING_DETAILS_DESC" LIKE '%CRIT% 1%' THEN 'Criteria 1' WHEN "SHOPPING_DETAILS_DESC" LIKE '%CRIT% 3%' THEN 'Criteria 3' WHEN "SHOPPING_DETAILS_DESC" LIKE '%CRIT% 5%' THEN 'Criteria 5' ELSE NULLEND I am trying task search in a text field (Shopping_Details_Desc) for cases where ‘%CRIT%’ is identified. I would then like the code to assign a Criteria when the number ‘1’, ‘3’ or ‘5’ follow directly after the we wildcard search. I am pulling errors because there are other numbers in the text description and the code is incorrectly assigning them because it is find any any ‘1’ (as an example) that comes after ‘CRIT’ and then calling it a ‘Criteria 1’, even when it is a Criteria 3. My issue is that sometimes our operators are miss writing the text so we are trying to capture either CRIT or CRITERIA, or anything in between - which is why I want a wild card. I was able to write a statement in DAX to be able to look for a number assigned direc

204

8 days ago

emilia.stepiLevel 2

Data Ingestion & Infrastructure

Restricting access to specific data model column

Hello everyone,I want to restrict access to a specific column in a data model so that non-admins cannot see the values in that column or the column itself. Is there a way to achieve this using data permissions? Thank you!Best,Emilia

201

8 days ago

julia.betzlLevel 3

Process Analysis

Error message: Calculated attribute ["MARC"."COND_MBEW_COMPL_VPRSV"] cannot be used inside a FILTER because it takes filters into account.

Hi all, I created an attribute (“MARC”.”cond_mbew_compl_vprsv”) as a boolean with the following formular:CASE WHEN( ( "MARC"."BESKZ" = 'E' AND ( PU_FIRST("MARC",FILTER_TO_NULL ("MBEW"."VPRSV")) NOT IN ( 'S' ) OR PU_FIRST("MARC",FILTER_TO_NULL ("MBEW"."STPRS")) = 0 )) OR ("MARC"."BESKZ" = 'F' AND ( PU_FIRST("MARC",FILTER_TO_NULL ("MBEW"."VPRSV")) NOT IN ( 'V' ) OR PU_FIRST("MARC",FILTER_TO_NULL ("MBEW"."VERPR")) = 0)))THEN 1 ELSE 0 END Now I want filter like followed: FILTER "MARC"."cond_mbew_compl_vprsv" = 1 This does not work and I got the following error message: Calculated attribute ["MARC"."COND_MBEW_COMPL_VPRSV"] cannot be used inside a FILTER because it takes filters into account. Can you help me what I should change? Thank you. Regards

172

8 days ago

Leaderboard

VIEW ALL

Awarded Badges

rafael.souza11has earned the badge Celonis Certified Data Engineer
mohini.tomar11has earned the badge Celonis Certified Data Analyst
santhosh.s19has earned the badge Qualified to Create and Deliver Demos
ramses.contr12has earned the badge Celonis Certified Data Analyst
zachary.flynn12has earned the badge Qualified to Get Data Into Celonis

VIEW ALL

Trust the Process

Celonis Podcast

The podcast where process pioneers reveal the science, stories and secrets to make processes work — so you can, too.

Listen now

How can we help?

Explore Community

All about Community

All Community Categories

Product Updates

Celonis Academy

Celonis Support Center

Celonis Partner Portal

Featured Topics

The latest and greatest from Community

Latest Posts

Leaderboard

Awarded Badges

Trust the Process

Need More Help?

Celonis Documentation

Celonis Support Center

Resources

How can we help?

Explore Community

Featured Topics

The latest and greatest from Community

Latest Posts

Leaderboard

Awarded Badges

Trust the Process

Need More Help?

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded