- - Knowledge base overview
Product Updates

Welcome to the Celonis Community

1 month ago

Home
Community
Ask the Community

Ask the Community

Get answers to general questions and Academy-related topics from fellow users and experts.

1165 Topics

Recently active

Most replies Most views Newest first

jurgen.gakovLevel 3

asked in General Q&A

Get the time between 2 specific rows in a dynamic table (LEAD and LAG Function)

Hi there, I have the following table: We got for every part diffrent timestamps with a specific work done there. I would like to calculate the date between the installation and removal date. The problem ist, that for one part there can be historical data with multiple removals and installtions (like you see in 'Y'). Here I would like to calculate the difference by taking the installtion data followed by the date of the next removal. I tried the Lead Function: DATEDIFF(DD, (Lead ( ('DATE'), ORDER BY ('DATE' DESC), PARTITION BY ('PART', 'WORK'),1)), (DATE) ) The problem here is that this function calculates only the days between the removals.Do you guys have any idea how I can get the dates between the installation and removals dates? Thank you and best regards!

9 months ago

milan.ericLevel 3

asked in General Q&A

Are there more Celonis-Community Hubs online?

Hey everyone, I keep on struggling solving issues on Celonis and not being able to find questions related to my topic here on this website or online in general. Often quite "basic" questions or at least advanced ones where others probably were also stuck at that problem. Celopeers is really great but we all know the downsides of forums. Just look at the SAP documentation and help online. It is really hard to get things done efficiently. Programming languages have Discords, other forums and community hubs. Celonis is, compared to a programming language, obviously way smaller (community wise). But is there anything else similiar to Celopeers or e.g. a simple discord server for Celonis? Or any interest in creating such thing for faster and easier connections among celonis users. Including an easier way to help others and learn. I just dont want Celonis to be SAP 2.0 in terms of knowledge transfer.

010

9 months ago

marcin.konop13Level 3

asked in General Q&A

How to pull a specific value from a list-type variable?

Hello Celopeers. I have a variable that is a list based on a dropdown component.The end result looks something like this:'0014','0191','0311' Now I want to pull a specific value from this variable.Problem is, that any function calling it is either pulling only the first value, or doesn't really give me the value I need (in this case a second or third value) Examples I tried already:1.Input:<%= VARIABLE%> Output: 0014 2.Input: RIGHT(<%= VARIABLE%>,4)Output: Error, Operator 'RIGHT' requires 2 inputs but 4 were provided. 3.Input: CONCAT(<%= VARIABLE%>)Output: 001401910311 4.While combining the RIGHT or LEFT with CONCAT might be able to be helpful enough with some tweaks if the variables had all the same length, they have varying length. some being 4 characters long, some up to 14.Input: RIGHT(CONCAT(<%= VARIABLE%>),4)Output: 0311 Therefore is there some way to call specific value from the list like in Python it would be: Input:

9 months ago

bogdan.saroiLevel 2

posted in General Q&A

Dear Pablo,

Dear Pablo, Apologies for the late reply as I've lacked access to my celopeers account for the past couple of months which just today got restored (most likely through my colleague Thomas' ticket, although it seems to have been reset from scratch). Unfortunately, the issue persists although we haven't gotten any closer to the cause or a possible solution, see case 00278943. Sorry, again, for not having replied sooner. I received the emails on celopeers' behalf but literally couldn't log in at all regardless of method, nor was I able to reset my password (no mails came through). BR,Bogdan Saroi

9 months ago

lukasz.lutyLevel 3

asked in General Q&A

I would like to put within on component (OLAP table) formula that calculated 'no touch' rate calculated per case (column A) and no of activities. (column B).

When I put only formula for 'no-touch' rate is shows correct value (if 1 out of 3 cases meets criteria then it returns 33%). But if I add no of activities (total: 37) it changes to 46% (calculates no of activities within case that fulfils criteria and divides by all). Any tips how to come up with no of activities (37) in column A and correct ratio per case (33%) in B? Thanks in advance for any guidelines. *** AVG( CASE WHEN PU_COUNT("VBAP","_CEL_O2C_ACTIVITIES"."USER_TYPE","_CEL_O2C_ACTIVITIES"."USER_TYPE" IN ('A','B','C') AND "_CEL_O2C_ACTIVITIES"."ACTIVITY_EN" IN ('X','Y','Z')) = 0 THEN 1.0 ELSE 0.0 ***Case A # of Activities No TouchA 17 yesB 10 noC 10 no

9 months ago

andré.tafurLevel 4

asked in General Q&A

Action Flow Life Cycle Methodology

Hi celopeers!I would like to know if any of you when implementing a solution using an Action Flow have used any framework to ensure its lifecycle. I mean what steps have you followed to build, test, release to production, monitor and manage the changes of an Action Flow? Thanks!

9 months ago

.1463214Level 2

asked in General Q&A

Hi all, Can anyone tell me why is this happening because I am not able to get the list of columns even table is there in data pool ..?

9 months ago

gevik.nalbaLevel 1

asked in General Q&A

What is the process to becoming a technology partner?

As a software/saas provider, how do we become a tech partner to Celonis?

9 months ago

matt.slocu12Level 3

asked in General Q&A

How to dynamically calculate quartiles using data from pull-up aggregation

Given a set of process data that determines a time in process using pull up aggregation, I would like to generate the different time in process averages for an attribute for 1st quartile, 2nd quartile, 3rd quartile, and 4th quartile attributes. Remember the average time in process is calculated via pull-up aggregation, which I believe means I can't run pull up aggregation on it again. I tried to research Domain Tables, but I wasn't sure how to apply them here. see image for example:

9 months ago

zeliha.otgözLevel 4

asked in General Q&A

It is indicated in the Celonis Academy that "As an improvement action, you might choose to implement Celonis Machine Learning and Action Flows".Do you know any other option for improvement actions when improving the business value?

It is indicated in the Celonis Academy that "As an improvement action, you might choose to implement Celonis Machine Learning and Action Flows". Do you know any other option for improvement actions when improving the business value?

9 months ago

chaitanya.telukLevel 1

asked in General Q&A

What is the ratio for the process deviation “Maverick Buying” for the material “Leather bag professional”?

9 months ago

fatima.belabLevel 2

asked in General Q&A

in E2E there are some data missing like i found the data in OMS but i didn't find them in E2E ?

9 months ago

Sverre KleinLevel 6

asked in General Q&A

Hubspot Sales Pipeline

Hello! I wanted know if anyone was able to successfully have a Hubspot use case, I am currently in the middle of creating the tables for Celonis, but I wonder if anyone else did it before me. 😎

9 months ago

gabriella.koopmLevel 2

asked in General Q&A

Add a graph with the maximum count of cases with a specific activity on a day per hour.

On the X axis, I have Hours (event. timestamp)On the Y axis, I want to have a graph with the maximum amount of cases that have happened. but on a day. ( So for example 1-01-2022 at 9 hours the count was 10 and on 2-01-2022 at 9 hours the count was 30, I want the output for 9 hours to be 30) At the moment I use this to calculate the averageCOUNT ( DISTINCT CASE WHEN "eventlog_T1"."ACTIVITY" = 'activity'' THEN "eventlog_T1_CASES"."cases" END )/( COUNT ( DISTINCT Round_Day ( "eventlog_T1"."TIMESTAMP" ) ) ) Does any one has a suggestion how to get the maximum value on a day per hour

9 months ago

bhavyasri.kodalLevel 1

asked in General Q&A

how to delete my account in this

102

9 months ago

nathalie.magalLevel 1

asked in General Q&A

How to link the BSEG table with either /OPT/VIM_1HEAD or /OPT/VIM_1ITEM to retrieve the DOCID field?

We have an OLAP table and most of the columns are from the BSEG, BKPF, and LFA1 tables. However, we would like to also have the DOC ID field from either /OPT/VIM_1HEAD or /OPT/VIM_1ITEM tables. How do we connect these tables? Thank you!

9 months ago

stuart.johnsLevel 2

asked in General Q&A

Fairly simple - we are using C4C EMS and would like to know the costs/commercial model once you have used up your free entitlement - cannot seem to find that information easily anywhere

9 months ago

jonas.friscLevel 3

asked in General Q&A

I would like to remove leading zeros in the Replication Cockpit before they are loaded into the pool.

Hello everyone, I would like to remove the leading zeros from some attributes. This is not a problem with the normal extractions and can be done with an update command. The question arises as to how I can implement this in the Replication Cockpit. The data is stored in a view, which I cannot update. Does anyone already have a solution for this or a suggestion as to how I can implement this?

9 months ago

bowei.huoLevel 1

asked in General Q&A

I suddenly lost access

9 months ago

muhammad.kashi14Level 1

posted in General Q&A

Community FAQ: How do I join/subscribe to a Community Topic?

Community FAQ: How do I join/subscribe to a Community Topic? Answer:To join/subscribe to a community topic, please follow these steps: 1. Visit our community topics from the main navigation bar.2. Click on the topic you are interested in.3. Locate the "Follow" button on the right side and click on it. Once you follow a topic, you will see two options for email notifications as shown in the screenshot below.Same applies for other topics that are not listed here. Also, feel free to follow as many topics as you want!

9 months ago

apurva.patha12Level 3

asked in General Q&A

Can anyone tell me how can I change the background color of view from grey to white?

9 months ago

marcos.hirak12Level 3

asked in General Q&A

what are the initial practical steps to take to "Create sap connection in celonis ems"?

I'm in my first EMS project and it was to accompany the DATA ENGINEER activities.Unfortunately the Data Engineer was not hired and they asked me to take over and I don't know SAP BASIS. I've done the Get Data into the EMS training, but I don't know what the initial practical steps are to do to "Create sap connection in celonis ems".Does anyone have anything written from "Practical roadmap to "Create sap connection in celonis ems" to send and/or guide me?

9 months ago

uma.penmeLevel 3

asked in General Q&A

I created action flow and now i am trying to add email module to celonis query Data module. I am unable to add email to email module as it is showing it is restricted by our company laptop, Is there any possibility or alternative to send mails.

9 months ago

muhammad.kashi14Level 1

posted in General Q&A

Community FAQ: How do I update my contact information?

Community FAQ: How do I update my contact information? Answer:To update your contact information in Celopeers, please go through the following steps: 1. Click on your profile picture on the top right corner.2. From the dropdown, go to your Profile Page.3. Once there, click on the "Edit" button on the top. A prompt will appear that will allow you to change your name, title, and background information. Please leave a like if you found this helpful!

9 months ago

johannes.holst11Level 3

asked in General Q&A

I've an issue renaming a column.When executing the codeALTER TABLE tablename RENAME COLUMN oldname TO newname;I get the error: Execution error: Incorrect syntax near 'RENAME'what is my mistake? The error appears whether i use quotes or not

I've an issue renaming a column. When executing the code ALTER TABLE tablename RENAME COLUMN oldname TO newname; I get the error: Execution error: Incorrect syntax near 'RENAME' what is my mistake? The error appears whether i use quotes or not

410

9 months ago

Page 11 / 47

Badge winners

alessio.vasinhas earned the badge Celonis Technical Expert
alessio.vasinhas earned the badge Qualified to Build Action Flows
eric.gring11has earned the badge Qualified to Manage Implementation Projects
pranav.prashant.pattehas earned the badge Celonis Technical Expert
pranav.prashant.pattehas earned the badge Qualified to Build Action Flows

Show all badges

Terms & Conditions

Sign up

Already have an account? Login

Login with SSO

Login to the community

Login with SSO

Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.

Enter your e-mail address

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

ANY QUESTION?

Talk to an expert

FAQs

MORE CELONIS

Academy arrow_outward

Documentation arrow_outward

Support Center arrow_outward

Partner Portal arrow_outward

Marketplace arrow_outward

CHECK US IN

YouTube

Instagram

Facebook