- - Knowledge base overview
Product Updates

Welcome to the Celonis Community

1 month ago

Home
Community
Product Q&A
General Product Q&A

General Product Q&A

Not sure where to post? Ask your product-related questions here and get support from the community.

1,416 Topics
3,354 Replies

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

1416 Topics

Most replies

Most views

Newest first

AllstateCelonisLevel 2

asked in General Product Q&A

PyCelonis functionality question

I am working on a script in PyCelonis to search assets and compile a list of the data models/Knowledge models that the assets are using, with the aim of non manually figuring out which DM/KMs are currently in use by production assets. Using PyCelonis I have been able to navigate down to the asset level and find lots of information for each asset, but have so far not found anywhere that you can identify the DM/KM an asset is built on. The “.dict()” function provides a lot of information and I thought would be the intuitive place to include this kind of information but it is nowhere to be found, except when the asset is a view and the KM gets referenced in the yaml code that is provided in “.dict()” Does anyone know if this is information that we can pull from PyCelonis? And, if so, how to find this information on the asset level? Thanks in advance for your help!

7 hours ago

thomas.keimLevel 3

asked in General Product Q&A

New Studio: Table component "calculate share in percentages"

Hello Community,I'm currently migrating my analyses to the new views and have encountered a “problem”. I hope you can help me solve it:Within “Analysis” the table component has the function “calculate share in percentages”.Hee it is possible to calculate the percentage of a column per line, also what percentage of the total for a column a line represents.How does it work in the new views?Thank you so much for help.Best, Thomas

241

6 days ago

bennita.dutoi12Level 4

asked in General Product Q&A

concatenating in data jobs

Hi Everyone. I am trying to create a table in Data Jobs, but I want two zeros infront of a number. nothing I try works? what could the issue be? See ‘00’||”COL-1”

7 days ago

romayssa.bedjaLevel 2

asked in General Product Q&A

Multiple lines in the line chart within the new view

Hello Celonis community,I’m building a new view and I need to set-up a line chart with multiple lines. Basically, calculating the same value but for different types and plotting them in differently colored lines.In the analysis set-up I used to duplicate the metric for each type and force filter within the PQL metric for the specific type. Now, with the view set-up we can plot only one line, sicne we cannot add multiple Y-axis.Is there a new way (ex. like the “hue” attribute in seaborn library for python) to do this? Or a tip workaround to be able to do it ?

222

12 days ago

maximilian.alterLevel 2

asked in General Product Q&A

Hello, Is it possible to create a PDF Report of Views?

I created an Action Flow for PDF Reporting, but can only select my Analysis. Do you have an idea how to or if it is even possible to get my view(s) automatically into a PDF File.Kind Regards, Max

124

13 days ago

pierre.aless12Level 2

asked in General Product Q&A

Are we able to extract the user adoption via Pycelonis from a specific team?

Hello all, I would like to know if it's possible to extract the user adoption data/login history from the Platform Adoption View via Pycelonis 2.0.1 (I have the CSV export feature enabled, btw). I'm trying to navigate to the specific object, but I can't even reach the Admin & Settings panel. Thanks in advance for any help.

18 days ago

andrew.yenLevel 2

asked in General Product Q&A

Migrating connector from Linux 7 to 8

Hello,Our team is in the process of setting up Linux 8 on our production server and are seeking to migrate the Celonis Connector from our previous Linux 7 server.The Linux 7 server currently uses JDK 11 and a 2022 version of the JDBC connector without the aid of an on-premise client.Would it be recommended to install the current version of the JDBC connector (and JDK dependency) separately, or would installing an on-premise client package be better?

171

20 days ago

.146004188Level 2

asked in General Product Q&A

How does the workday calendar in data model look like?

Dear Community, we would like to use the workday calendar feature in the data model, so that we can calculate the lead time excluding all public holidays + weekend. Since our data source is not based on SAP, we don't have the TFACS-Table. Can someone help and tell me what kind of table I should update here as a workday calendar:which columns are mandatary?how should the table look like?what is the corresponding data format? An example table would be very helpful here. Thank you in advance. Kind regards,Liz

1010

20 days ago

dhruv.jinjh11Level 1

asked in General Product Q&A

Hey everyone, I have designed an Action Flow using the List Items module in Microsoft SharePoint Online, and it has a limit of 3500. Essentially, if my SharePoint list contains more than 3500 records, not all the records will be fetched.

Is there a way to fetch all the records present in the list?

22 days ago

bennita.dutoi12Level 4

asked in General Product Q&A

Secondary axis in new views

Hi All - How can I add a line on the secondary axis to this stack graph in the new views?

433

24 days ago

miguel.ferna11Level 3

asked in General Product Q&A

How to download a zip file from ML Workbench directory?

I have generated a zip file with the content-cli module and now I need to download it locally, but every time I press the “Download” button it creates an HTML file. That HTML redirects me to a “Secure download” which re-downloads the same HTML. How can I avoid the HTML and just retrieve the zip file?

202

1 month ago

tomnguyenLevel 2

asked in General Product Q&A

How to learning using Celonis

Hello everyone, I am an employee from a technology company called Terus. I am assigned to learn and know how to use Celonis, then bring it back to apply to the company's process, but I currently do not have a clear plan for this move because in my country, not many people use Celonis.By chance, when I was researching, I noticed that this community and everyone shared a lot of information related to Celonis. I want to ask about the roadmap that everyone learned to use and apply Celonis? I hope everyone can give me an answer!

332

1 month ago

preethimani.sundaLevel 1

asked in General Product Q&A

I have not completed my celonis rising star assessment as I have taken the assessment 2 times now the assessment is not opening plss help me to complete the assessment

Please help me to complete the assessment

1 month ago

julio.bolan12Level 2

asked in General Product Q&A

FILTER some data only when a condition is true.

I want to filter based on a condition like this:FILTER Color = 'blue' WHEN Shape = 'square'. I'm having trouble creating a formula like this because what I have tried is filtering all instances where Color = 'blue', but I want to filter only for blue color when the shape is square.I think this should be something very easy to do, but I'm having trouble. Thanks in advance :)

1 month ago

pruthvin.v11Level 3

asked in General Product Q&A

Do anyone know the PQL formula to find PR which is not converted to PO within 2 days

1 month ago

vamsimadhavgLevel 2

asked in General Product Q&A

Need to Trigger Action Flow for Last Refresh Date

I am trying to make an action flow which gets triggered when the data load is more than a day old i.e., when the data load failed, and we are unaware of the failure. Current problem is that I am able to get the last refresh date from event log which is the MAX of the time stamp but to put a trigger to see if the MAx is more than a day old, the FILTER function in general does not allow aggregations. Is there a way out of it or any other path that can be taken to create an action flow to trigger a mail if the last refresh date is more than a day old.

151

1 month ago

astha.jLevel 3

asked in General Product Q&A

How to delete trigger subscribers?

I have a trigger which is link to 2 subscribers. I'm not able to delete the subscribers, so when I delete the trigger, it gives following error.

141

1 month ago

karl.guentLevel 4

asked in General Product Q&A

In Warranty Claims and I want to isolate ("include") Claims over -$10,000 and below over$74.99. I am doing it in the filter bar (see red box below). However, I'd like to add it as a component, like the Date Picker (purple box below). I can't

101

1 month ago

denise.kruge12Level 4

asked in General Product Q&A

Finding an error in transformations

Good day, When I get an error message in my transformation “error at character 28152”, how do I find character 28152? Thank you,

262

1 month ago

suraj.kumar14Level 1

asked in General Product Q&A

I want to connect Azure MySQL to celonis. I am not able to connect. Getting error message "Connection test failed. Please check the data connection and ensure that the system is running. Extractor responded with an internal error."

1 month ago

javier.marti14Level 2

asked in General Product Q&A

Link new version view to an old version view using a button

I have a question regarding a development I’m working on. I have an old view where I would like to add a button that, when clicked, opens an auxiliary filter view. This auxiliary view is newly created, using the latest version of the views, and has already been published.However, when I try to configure the button to link to this new view using the "link views" function, the view I just created does not appear as an option.I suspect this might be because it's not possible to link new views to old views, but I’m not entirely sure. Could someone confirm if this is the case, or if there's another reason why the view isn't showing up?

331

1 month ago

praveen.ojha12Level 3

asked in General Product Q&A

How to find a proper documentation for Microsoft 365 Email modules that I want to use in my Action Flow?

I wanted to use Get Message module of Microsoft 365 email in my Action Flow. But I don't know what does each field mean and what are the accepted values for those fields. For example in the screenshot below.I checked Celonis as well as in make.com documentation, but none of the place I found the proper documentation. Thus, can someone suggest where I should look for documentation on Microsoft 365 module.

131

1 month ago

akihiro.nishi13Level 1

asked in General Product Q&A

How to set up the Share Link button?

Could you tell how to set up the Share Link button?(Attached below) The permissions are also fine for the administrator in the target environment.I would be grateful if you could let me know.

161

1 month ago

jan.van.d12Level 3

asked in General Product Q&A

How to count unique cases with multiple occurrences of an activity?

In my output (OLAP) table I want to have each activity name from the activity table and then an overview of the number of cases in which that activity name has occurred. Then I want to get an overview of the number of cases in which that activity name has occurred two times, three times, or multiple times etc. I know that with the following code I can get the number of cases where the activity happened at least 1 time, but I do not know how to calculate the number of cases where the activity happened 1 time and not more often. SUM(CASE WHEN INDEX_ACTIVITY_TYPE ("ACTIVITY_TABLE"."ACTIVITY") = 1 THEN 1 ELSE 0 END) The other thing I still miss is how I can calculate the number of cases in which that activity occurred >=2 times. When I change the formula to >=2, I get the wrong count as then a case with 4 activity occurrences is counted as 3 instead of 1 (it counts the second occurrence, third occurrence and fourth occurrence all as one 'case'). Is there

501

1 month ago

danelle.visse12Level 2

asked in General Product Q&A

I am trying to configure a comment component in the new views. I followed all the steps in the documentation but it is still not working. Is there additional documentation or other steps to configure the component that is not in the documentation?

110

2 months ago

Page 1 / 57

Badge winners

zachary.flynn12has earned the badge Qualified to Write PQL Queries
zachary.flynn12has earned the badge Qualified to Build Analyses
Nkosiyamntuhas earned the badge First Post
gaurav.shekh12has earned the badge Celonis Certified Data Analyst
nikhil.gauta11has earned the badge Qualified to Write PQL Queries

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