- - Knowledge base overview
Product Updates

Welcome to the Celonis Community

3 months ago

Home
Community
Ask the Community
General Q&A

General Q&A

Can't find what you're looking for? Ask it here!

1,159 Topics
2,511 Replies

When you subscribe we will email you when there is a new topic in this category

1159 Topics

bunyod.sapLevel 4

Hi Celopeers, I wonder if someone had already use case where Action Flow can generate Salesforce Tickets?

8 months ago

jack.everaLevel 3

asked in General Q&A

I would like to add a filter in the 'load script' section in a sheet. that filters the content by the current month. How do I do that?

8 months ago

ugandhar.konapLevel 3

asked in General Q&A

I need to load data as Delta/Incremental load.

Suppose I have data for 3 months and using some connection I have imported the data in the Celonis for that 3 months and created Data Model. Again I got additional data for next 3 months, now I want to create another data model only for the new 3 months data. How can we use Incremental loading for these type of scenarios...?

8 months ago

marco.baren11Level 3

asked in General Q&A

Skill vs. Action Flow

Hi,is there any best practice when to use a Skill and when to use an Action Flow? As I understood so far, both technologies enables me to automate a process. Thanks for clarifying.Marco

110

8 months ago

knarik.sahak13Level 2

asked in General Q&A

Upload lists of values to filters

How can I upload a list of values instead of selecting each value individually? For example, when clicking on the hidden activities icon in the process explorer and choosing a list of activities to hide.

8 months ago

srijan.yadav12Level 1

asked in General Q&A

Whai celonis infterface ? And to connect celonis Interface with client ERP system ?

8 months ago

bennita.dutoi12Level 4

asked in General Q&A

What is the main differences between a validation cockpit and a process cockpit in an App or Demo? I looks like duplication to me but I am not sure if I am missing something.

8 months ago

omar.hasna11Level 2

asked in General Q&A

Duplicate checker using Pycelonis not possible !

Hello everyone I am trying to perform a duplicate checking of vendor master in the machine learning module following the tutorial in the link: https://celonis.github.io/pycelonis/1.6.0/tutorials/data_deduplication/00_Tutorial_Duplicate_Checking/ The problem i encounter is that all the libraries used in this tutorial seem to not function in the new version of Pycelonis 2.8.0 Is there any new tutorial for the data deduplication with Pycelonis ? otherwise how can i perform that using python without calling the library shown in the tutorial ? Any help will be extremely appreciated :) Best Omar

8 months ago

shyam.panugLevel 1

asked in General Q&A

Excel PERCENTILE.EXC formula functionality in Celonis

Hello Celopeers, I would need your help in understanding formula similar to percentile functionality within Celonis. Preferably within Pivot table. Thanks!

8 months ago

Lovise HellnerLevel 4

asked in General Q&A

Filter a KPI - PQL struggles

Hi team, I want to create a KPI to measure the proportion of items with missing routes. BUT I want the scope of my data to be filtered only on specific order types.I could add a filter on the component, but to make sure the KPI is always measured the same everywhere, I want to have the filter within the KPI calculation. I understand the below formula is not correct ('The aggregation function SUM cannot be used together with a dimension function input.') but I am struggling to find the solution. Any suggestion ? Thanks heaps CASE WHEN "VBAK"."AUART" IN ('ZCS','ZECH','ZEDI','ZCSG','ZEDC')THEN SUM (CASE WHEN "VBAP"."ROUTE" IS NULL THEN 1 ELSE NULL END)/ COUNT_TABLE ( "VBAP" )ELSE NULL END

100

8 months ago

joao.santo14Level 3

asked in General Q&A

Can we construct a Waterfall Chart with the defective invoices were it shows the number of defective invoices in the start of the period, the new defective invoices, the resolved ones and the number of defective invoices in the end of the period

douglas.henriLevel 4

Hello guys, can you help me with this error message below? It started out of nowhere, I didn't touch this job and it started to show errors in it. I've never seen this type of error, have you ever experienced this?

9 months ago

stefan.burkhLevel 2

asked in General Q&A

Flatten OCED Data using perspectives in Celonis Process Sphere

Is it possible to select objects and events so that the models correspond to the traditional Process Mining modells (single case notion..) If yes what steps are need?If not where is the limitation?

9 months ago

Sverre KleinLevel 6

asked in General Q&A

Where can I find my Celopeers bookmarks?

Hi everyone, There is a functionality within Celopeers to save posts in the "bookmarks". However, I can't find them anywhere. Does anyone know where to find the bookmarks within Celopeers? Thanks!

9 months ago

ugandhar.konapLevel 3

asked in General Q&A

I'm unable to get required output for the following type of data.

From the below data I need,1. Total Through put time by STAGES(I have used standard KPI of Total Throughput Time formula and component Filter by STAGE, even though not getting required output) 2.Total Throughput time by TYPE(I have used standard KPI of Total Throughput Time formula and component Filter by TYPE, even though not getting required output) NOTE: Getting total time for the both scenarios after giving the Total throughput time and component filter

9 months ago

julia.bauerLevel 5

asked in General Q&A

Augmented Attribute Tables - store historic data of a worklist with a timestamp

Hello everyone, I want to build a worklist in Celonis with exception messages that purchasers should process. New exception messages should be marked with an augmented attribute (Status: NEW). I also have another augmented attribute - Comment field. I now want to store every changes made manually (change status from e.g. NEW to in Clarification or changes in comments) into a table as this table is needed to train an AI model. Is this possible - has anyone made experience with this and is willing to share their experience? Thank you! Best regards,Julia Bauer

210

9 months ago

lize.erasm11Level 3

asked in General Q&A

Hi all, is it possible to use a global statement in a PU function. I want to keep the filters global in the PU function.

PU_COUNT_DISTINCT ("_CEL_OTT_CASE_TABLE_NWF_DD",FILTER_TO_NULL("_CEL_MERGED_ACTIVITIES"."ACTIVITY"), "_CEL_MERGED_ACTIVITIES"."ACTIVITY" LIKE 'NWF: Due % & Release' AND "_CEL_MERGED_ACTIVITIES"."TEAM_LEADER" = 'Robben Ramatlo' )

9 months ago

vincent.witteLevel 3

asked in General Q&A

Calculation / duration between a start and a list of possible events?

Hi, how can I achieve a calculation with an OR / INLIST('RESOLVED','RESTORED')This formula is not working. Do I need to construct a case when first? AVG( CALC_THROUGHPUT( FIRST_OCCURRENCE['QUEUED'] TO FIRST_OCCURRENCE['RESOLVED'] OR FIRST_OCCURRENCE['RESTORED'] , REMAP_TIMESTAMPS("eventlog"."TIMESTAMP", HOURS)) ) The part without OR FIRST_OCCURRENCE['RESTORED'] works fine

9 months ago

lize.erasm11Level 3

asked in General Q&A

The main differences between using the FILTER_TO_NULL and not using it in a PU function.

Can you explain the main differences between using the FILTER_TO_NULL and not using it in a PU function. I see that the results differ for the following 2 functions: PU_COUNT_DISTINCT ( Domain_Table("CEL_ACTIVITIES_CMS_COMBINED"."USER_NAME") , FILTER_TO_NULL("CEL_ACTIVITIES_CMS_COMBINED"."CASE_ID") , "Grouping_All"."QUERY GROUPING" = '<%= QueryGroup %>' ) And PU_COUNT_DISTINCT ( Domain_Table("CEL_ACTIVITIES_CMS_COMBINED"."USER_NAME") , "CEL_ACTIVITIES_CMS_COMBINED"."CASE_ID" , "Grouping_All"."QUERY GROUPING" = '<%= QueryGroup %>' )

9 months ago

katsuhito.naraLevel 2

asked in General Q&A

When I send an email to Gmail with Celonis' Send Email feature, the link is deleted and I cannot access the link.

We are extracting data in the Action Flow, formatting the text content of the email using the Excute Process Automation Skill, and then using the Send Email Skill to send the email using the Celonis email server. I have a question here.In the "Excute Process Automation Skill" settings, I have entered the text information I want to convey in "mail_text" and the extracted information assembled in an HTML table. In this text information, I have written a hyperlink (HTML) to link to the Celonis analysis.We sent it to our own email address (Gmail) for test transmission, but the result is that only the link tag has been removed. Only the text enclosed by the link tag is displayed.In other words, only text without a link is displayed. In the log of the sending skill, it is sent as described in the tag.Is it possible to delete the link tag on the Gmail side when the test is received on the Gmail side?(I am assuming that Gmail side parses the HTML and may alter the tags.) I

9 months ago

apurva.patha12Level 3

asked in General Q&A

Pivot table in new view

Hello There,Any advise to build pivot table in new view. In analysis we do have pivot table component table itself. But in view please advise.

9 months ago

louis.forst12Level 3

asked in General Q&A

Hi Everyone :), i have a list of all Customernumber in an Excel File, how can i import them into Celonis, so that i can use them for a Selection in an Analysis Sheet

9 months ago

kapil.gaurLevel 2

asked in General Q&A

Hi Team, How can I get access to Partner Portal? I had mistakenly selected myself as Consultant and would want to change it to partner. My company is already a partner to Celonis.

P.S. : I have already raised a support ticket which is pending for more than a month now without any reply from the team.

9 months ago

tim.tak11Level 2

asked in General Q&A

i am trying to enroll for the course: Object-Centric Process Mining: Foundations https://academy.celonis.com/courses/object-centric-process-mining-foundations-1But there is no enroll button. Any one that can help?

i am trying to enroll for the course: Object-Centric Process Mining: Foundations https://academy.celonis.com/courses/object-centric-process-mining-foundations-1 But there is no enroll button. Any one that can help?

9 months ago

ugandhar.konapLevel 3

asked in General Q&A

In Views, while creating 2*2 or 2*3 components I can't find any border option between components or even for the entire view border.And also the background is grey in color, is there any option to change the background color in view.?

In Views, while creating 2*2 or 2*3 components I can't find any border option between components or even for the entire view border. And also the background is grey in color, is there any option to change the background color in view.?

9 months ago

Page 8 / 47

Badge winners

rohit.shukl12has earned the badge Solution Creation Expert
charlie.rigbyhas earned the badge Qualified to Write PQL Queries
mona.naghahas earned the badge First Post
yuu.motokhas earned the badge Qualified to Manage Implementation Projects
maxime.psbpmhas earned the badge Qualified to Build Analyses

Show all badges

Terms & Conditions

Sign up

Already have an account? Login

Login with SSO

Celonaut Login Celonis ID Login

Login to the community

Login with SSO

Celonaut Login Celonis ID Login

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