- - Knowledge base overview
Product Updates

Welcome to the Celonis Community

2 months 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,422 Topics
3,364 Replies

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

1422 Topics

Most replies

Most views

Newest first

daniel.magalLevel 2

asked in General Product Q&A

It is possible to create a table whose feed is variables that perform operations such as counting

It is possible to create a table that is filled with defined variables that count certain tasks.You see, in my organization we have 2 people responsible for the tasks, which would be the User and the Supplier. The User is responsible for 3 tasks and the Supplier for another 2, so I would like to make a table that appears Responsible #Quantity of tasks completedUser 30Supplier 5 I can only add them as a columnCOUNT (DISTINCT CASE WHEN "_CEL_CRED_ACTIVITIES_ARIBA"."[APRO] Estado de la tarea" like 'Approved' OR "_CEL_CRED_ACTIVITIES_ARIBA"."[APRO] Estado de la tarea" like 'Reviewed'and "_CEL_CRED_ACTIVITIES_ARIBA"."ACTIVITY_EN" like 'Revisión Usuario' THEN "_CEL_CRED_ACTIVITIES_ARIBA"."ACTIVITY_EN" ELSE NULL END )

1 day ago

frederick.coutr12Level 3

asked in General Product Q&A

Transformation Hub roadmap

Hi everyone,We’ve recently started trying the Transformation Hub, which looks like a fantastic tool for tracking the realization of value. While exploring its capabilities, we’ve noticed a few limitations (though we might be mistaken, as it’s still new to us).Is there a roadmap available that outlines when new features might be added? Specifically, we’re curious about the potential inclusion of:Custom processes Custom objective types Custom currencies (e.g., $CAD) Ability to track value based on something else than a financial amountThanks in advance for your guidance and any updates you can provide!

172

2 days ago

nicolas.kazekLevel 2

asked in General Product Q&A

Restrict Scope of People for Task Assignment

Hi,we are looking for an option to restrict the dropdown of an “Asignee” component to a selected number of persons. Currently the dropdown shows ALL persons / groups in our tenant (see example below): Is it possible to restrict the dropdown to display only pre-defined users or user groups? If so, how can this be achieved?BR,

212

5 days ago

rithu.kaLevel 2

asked in General Product Q&A

how to change the nanme

145

6 days ago

junwei.chaiLevel 3

asked in General Product Q&A

Action Flow filter date

Hi,I want to create an action flow by querying a data within a specific range of date (e.g. total number of PO created from 01 November 2024 to 01 December 2024). How can I achieve that?

132

8 days ago

jesus.hernaLevel 2

asked in General Product Q&A

When i try to create an augmented attribute in the new views experience it gives me the error variable[0]. value, does anyone know how to solve it? (there´s already an identifier in the data model)

10 days ago

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!

272

16 days 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.

262

16 days ago

vamsimadhavgLevel 2

asked in General Product Q&A

Merge two parallel paths in action flow

Hi, I am trying to query data in Celonis module in the Action flow . However, I have requirement to split the data into two paths and then prepare a csv and then merge it back into one using a text aggregator. Is there a module that can merge paths in action flow. Or is there a way to split data based on filters and merge or append it into one file

16 days 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

462

17 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”

25 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 ?

282

1 month 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

144

1 month 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.

115

1 month 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

1 month 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

1310

1 month 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?

112

1 month 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?

513

1 month 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?

222

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!

352

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

132

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

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.

151

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

Page 1 / 57

Badge winners

tim.sandehas earned the badge Qualified to Get Data Into Celonis
abubakkar.sanad11has earned the badge Solution Creation Expert
abubakkar.sanad11has earned the badge Qualified to Build Action Flows
abubakkar.sanad11has earned the badge Qualified to Build Views
abubakkar.sanad11has earned the badge Qualified to Manage Implementation Projects