- - Knowledge base overview
Product Updates
Groups

Welcome to the Celonis Community

5 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,192 Topics
2,557 Replies

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

1192 Topics

Most replies

Most views

Newest first

matias.pinto12Level 1

asked in General Q&A

Hi! i want to integrate a dynamic pareto front to scatter plots in my analysis. I want to integrate the pareto front point as red points into the plot. The optimals could change depending on the actual filters of the dashboard. Do you know how t

9 months ago

jonas.skjolLevel 1

asked in General Q&A

Hi Celopeers,In my activity table, I have some activities that describe different variations of an activity. I now want to calculate the throughput time of these activities to an X activity.

This means I want to calculate the throughput from A OR B OR C OR D to X. Is there any way of doing this?

9 months ago

jack.heggeLevel 2

asked in General Q&A

PQL comparing dates at activity level

140

9 months ago

deeksha.r12Level 3

asked in General Q&A

Filter for the KPIs in a table component

Hello Everyone, Can we apply a filter only for certain KPIs in a table component. Different filters for different KPIs.

9 months ago

akshay.koulLevel 2

asked in General Q&A

Difficulty extracting VendorDataWorkspacesRegistration from the Ariba SAP API

Hey guys, We are trying to export tables from SAP Ariba via API Supplier but we are receiving the return below message in Celonis extract Has anyone experienced this problem in this extraction?. Has anyone had this problem and could help me? Reached Supplier Data API limit waiting for 1 seconds. Current rate limits are; --- X-RateLimit-Limit-day: "25000" X-RateLimit-Remaining-day: "24935" X-RateLimit-Limit-hour: "4500" X-RateLimit-Remaining-hour: "4435" X-RateLimit-Limit-minute: "150" X-RateLimit-Remaining-minute: "86" X-RateLimit-Limit-second: "3" X-RateLimit-Remaining-second: "0"

9 months ago

andzela.debelLevel 2

asked in General Q&A

Can I split a bar chart with two colors but on one of those colors would be impossible to apply a filter?

Hello, the blue part is supposed to interact with filters that are applied to the entire view and change according to those filters. The green part is NOT supposed to interact with the filters and still stay with the same values. Is it even possible to make the green part still with the same values and not interact with filters across the view? Note: The blue part is status 1. The green part is status 2. E.g. when I change the filter on April blue part changes values but the green part disappears because the values of the green part are only on the actual month. I'd like to blue part to show other months and the green part only the actual one even when I filter across the view.

9 months ago

sankarganesh.jayak12Level 2

posted in General Q&A

want to read the file through machine learning, could you please help me

102

9 months ago

deeksha.r12Level 3

asked in General Q&A

Partitioning of a KPI over Time

Hello Community, I want to view the value of a KPI on monthly basis (Not in form of a chart). How can I partition the KPI value for different months in a year.

9 months ago

chiara.vozzeLevel 3

asked in General Q&A

Exercize on Key Metrics to monitor Value

Hi, I can't see the solution here. Can someone give me a hint? is in the Value Realization course- Manage change & scale adoption

9 months ago

reddy.vijayLevel 2

asked in General Q&A

I have used academic credentials but I'm unable to connect. Could you kindly share practical credentials for database connection purposes?"

10 months ago

ishiduka.misaLevel 3

asked in General Q&A

I would like to get the throughput time between specific activities, averaged per unit.

How can we calculate the average throughput time per unit without errors? ーー AVG( CALC_THROUGHPUT ( FIRST_OCCURRENCE [ '伝票登録画面表示' ] TO FIRST_OCCURRENCE [ '伝票保存' ] , REMAP_TIMESTAMPS ("t_Activity"."日時", MINUTES ) ) ) ーーーーErrormessageーー The aggregation function AVG is applied on a column from table "t_Case" which has a 1:N relationship to the common table "t_Activity". This means that one input value can contribute to the aggregation result multiple times. For more information search for "Join functionality" in PQL documentation. ーーErrormessageーー

310

10 months ago

tapan.sharmLevel 2

asked in General Q&A

How to connect to SAP Concur (Marketplace Connector)?

Hello All! Hope you all are doing great! We are working on a use case for which we are using Sap Concur connector available in Celonis market place. Wanted to check if anyone has used this connector. What is the method of extraction is uses? For now what I have seen in the connector settings, it seems it is using API. Could anyone confirm it. Regards, Tapan

100

10 months ago

abdul.azadLevel 1

asked in General Q&A

Hi. I'm a new user, while I created the account / login incorrectly created as 'Guest' it is supposed to be 'Partner'. In the same I have completed welcome kit and Foundation. I planning to undergo certification. I need help to change access to Part

10 months ago

sachin.sinhaLevel 3

asked in General Q&A

Sending csv file to "Email Address" through 'Action Flow. The email address is available in a table column. Is that possible?

Hi, I have a table of 5 columns. Eg: Ticket_No, Description, Priority, Closed_Date, Owner. The 'owner' column has different email addresses. The requirement is to send the first 4 columns 'Ticket_No, Description, Priority, Closed_Date' in a CSV file to whatever email address available in the 'Owner' field. Can it be done via Action FLow - If yes, please let me know what are the steps/modules? If it is possible via ML code ? If yes, what are the steps. Your help would be appreciated. Thanks!

160

10 months ago

naveensatyasai.utuku11Level 1

asked in General Q&A

I failed rising star technical assessment 4 times only one module i complete 75% please give me a solution i need to complete the assessment

130

10 months ago

christian.schro13Level 1

asked in General Q&A

Hey is it possible that hte Process Automation Bootcamp basically became the Rising Star Programm?Thanks in advance

Hey is it possible that hte Process Automation Bootcamp basically became the Rising Star Programm? Thanks in advance

10 months ago

andzela.debelLevel 2

asked in General Q&A

How to show the whole filter dimension?

Hi, the filter dimension reacts with the filter button, but after the button is pressed, the dimension is cut. When the section next to the dimension has a width less than 1, it doesn't work at all and when the width is more than 1, it's cut even more... Does someone know how to show the full dimension?

10 months ago

nikhil.moreLevel 1

asked in General Q&A

Process Cockpit (starter kit) --> Invoices (FI) tab --> Posting User column, populates some users as both Automatic as well as Manual. How can I validate if the users filter is configured correctly or not?

10 months ago

volker.domkeLevel 2

asked in General Q&A

We are having an issue connecting to a new Snowflake environment and need more detailed information (like a log file) on what is causing the issue. The error message is not helpful (... Extractor responded with an internal error.)

10 months ago

akshay.koulLevel 2

asked in General Q&A

Difficulty extracting VendorDataWorkspacesRegistration from the Ariba SAP API

10 months ago

thirumani.sravaLevel 1

asked in General Q&A

I don't get any email

10 months ago

michael.kaempLevel 3

asked in General Q&A

Views 2.0: same dashboard for multiple teams

I'm supposed to present the same dashboard to several teams. But: each team is only supposed to see their data (identifiable by an attribute). Note: I want to have something like a master view so that I have one single place to make changes, and I don't want to deploy future changes with a copy-paste approach to the team views. Using legacy views I realized such scenarios by extending or embedding views from a master view as team views, setting predefined filters, and giving permissions on object level.

10 months ago

andzela.debelLevel 2

asked in General Q&A

Hi,does anyone know how to not filter certain components? I have filters applied to the entire view, but I would like to not filter certain KPIs (they already have own filter in YAML) and ceratin charts (they already have own filter in YAML).

Hi, does anyone know how to not filter certain components? I have filters applied to the entire view, but I would like to not filter certain KPIs (they already have own filter in YAML) and ceratin charts (they already have own filter in YAML).

340

10 months ago

phil.cookLevel 2

asked in General Q&A

How could I apply a FILTER to an OLAP table to show only those records having a COUNT > 1? For example, there are 10 distinct names in the table with only "David" and "Susan" having counts of 50 and 10, respectively. All other names have a

The table in question is on the 1 side of a 1-to-many relationship, so PU_COUNTs will not work.

320

10 months ago

steven.berndLevel 3

asked in General Q&A

Time interval between 2 activities

Hello everyone, I am currently calculating the time interval between 2 activities for my department, see formula... TRIMMED_MEAN(CALC_THROUGHPUT(FIRST_OCCURRENCE['toPAS: QT5.2 - Check successful'] TO FIRST_OCCURRENCE['XI release'], REMAP_TIMESTAMPS("T_CEL_AT_HP5"."EVENTTIME", DAYS, MONDAY TUESDAY WEDNESDAY THURSDAY FRIDAY)), 5, 5) Now it can and may also be the case that the activities are swapped, how can I then incorporate this option into the formula? TRIMMED_MEAN(CALC_THROUGHPUT(FIRST_OCCURRENCE['toPAS: QT5.2 - Check successful'] TO FIRST_OCCURRENCE['XI release'], REMAP_TIMESTAMPS("T_CEL_AT_HP5"."EVENTTIME", DAYS, MONDAY TUESDAY WEDNESDAY THURSDAY FRIDAY)), 5, 5) OR TRIMMED_MEAN(CALC_THROUGHPUT(FIRST_OCCURRENCE['XI release'] TO FIRST_OCCURRENCE['toPAS: QT5.2 - check successful'], REMAP_TIMESTAMPS("T_CEL_AT_HP5"."EVENTTIME", DAYS, MONDAY TUESDAY WEDNESDAY THURSDAY FRIDAY)), 5, 5) This formula clarifies what I want, but it doesn't work. Maybe someone can help me. Thanks

190

10 months ago

Page 8 / 48

Badge winners

amit.debna12has earned the badge Qualified to Get Data Into Celonis
akiko.tsuzuhas earned the badge Qualified to Create and Deliver Demos
nataliia.vasil12has earned the badge Value Realization Expert
syam.ankihas earned the badge Celonis Certified Data Engineer
nataliia.vasil12has earned the badge Qualified to Deliver Business Value with Celonis