- - Knowledge base overview
Product Updates
Groups

Welcome to the Celonis Community

5 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,439 Topics
3,399 Replies

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

1438 Topics

Most replies

Most views

Newest first

dimari.slabb11Level 2

asked in General Product Q&A

Stacked bar graph in Analysis with a line graph

I would like to stack bar graphs on top of each other like this - I see there is an option to "Stacked (on Primary Axis)": But it looks like when I add a secondary axis that option disappears - Does that mean it is not possible in Analysis to combine a stacked bar graph with a line graph on the secondary axis? Or is there a way to combine a stacked bar chart on the primary axis with a line chart on the secondary axis?

400

5 months ago

jonas.schei12Level 3

asked in General Product Q&A

"Scroll from right" doesn't seem to work in View

5 months ago

sridhar.turag14Level 3

asked in General Product Q&A

"Chart" options in Studio to "Pin scrollbar to the right" and "Maximum elements shown" in View Components of studio

I created a "Chart" component in studio, and it shows the chart from the entire duration of the data on a monthly frequency. I want to show the data month-wise but limit it to 12 months with an option to scroll to the left to see the earlier months data. There is no such option. We have this option in Process Analytics but not when creating the Execution App / View. Is this a product limitation?

5 months ago

karl.guentLevel 4

asked in General Product Q&A

Something wierd is happening with my environment ... the labels are lost and I am seeing variable names. Is this happening to other people as well?

5 months 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 a

5 months ago

arturo.orteg11Level 3

asked in General Product Q&A

How to make a relationship with no direct tables

Hello everyone, I'm trying to connect table ekpo and lips in order to get the sum of the field LGMNG for every PO and its corresponding VBELN from VBAP and VBELN from VBFA. The pql code I am using is the following one:BIND("EKPO", PU_SUM("GSR_VBAP", BIND("GSR_VBFA", "GSR_LIPS"."LGMNG"))) This works well when I only have unique VBELN from VBFA for a VBELN from VBAP. My problem is when I have differents VBELN from VBFA for one same VBELN from VBAP, as it sums all te quantities as one, when I want it sepparated. In my OLAP TABLE I only want to show the first VBELN from VBFA, so I use this code: BIND("EKPO",PU_FIRST("GSR_VBAP","GSR_VBFA"."VBELN")) but i get the quantities from LGMNG for all the other VBELN from VBFA which belong to the same VBELN from VBAP. I hope can help here. Many thanks.

5 months ago

laura.jenseLevel 1

asked in General Product Q&A

How to apply a custom dimension in component

We would like to create a bar chart in views where the dimension input is not directly available from any field in the model and where the measure logic depends on the value of this custom dimension. The idea was therefore to create a table in the model and use this as custom input for the dimension while using a CASE WHEN statement to create the different measures depending on the value of the customized dimension like this: CASE WHEN “Custom Dimension” = ‘X’ THEN KPI("KPI1") CASE WHEN “Custom Dimension” = ‘Y’ THEN KPI("KPI2")..... etc. Since the custom table is not linked to the model we get a PQL error that ‘No common table could be found....’. Is there any workaround for this in order to be able to use custom dimensions in an easy way?

210

5 months ago

noaa.mamanLevel 1

asked in General Product Q&A

I got some error in my console: You have reached your 1GB data upload limit -> in celonis error what can I do What can I do to resolve this ?

5 months ago

louis.forst11Level 2

asked in General Product Q&A

Hi all :), is it possible to upload a excel file to the data model and connect it to the other tables only via action flows, or perhaps via the ML workbench. Links and Steps how to do it would be perfect, thanks in advance all :)

160

5 months ago

andré.tafurLevel 4

asked in General Product Q&A

Does anyone else have problems with the execution of their skills?

Hello celopeers,Between yesterday and today my team has noticed problems in the execution of Skills execution apps from the Marketplace and skills developed by my team, in different productive environments.I opened a support ticket but we have not received a response. Maybe someone else is experiencing the same problems or someone from the Celonis team can give us more information? Best regards.

5 months ago

brad.morroLevel 1

asked in General Product Q&A

Does Cleonis 4.6 On-Prem support OS version SLES 15.5?

5 months ago

chanyut.boonkLevel 1

asked in General Product Q&A

Dear Celonis Experts,Is there a way to change the language of the activity names in the "Case Explorer" from German to English? Although I have changed the Celonis system language to English, the activities are still displayed in German. BR Chanyut

5 months ago

muskan.singh11Level 1

asked in General Product Q&A

I have created a custom extractor to Extract Success Factors Data using Basic Authentication. When I am generating response, I either get no response or incorrect response for datetime columns. Has anyone faced this before?

5 months ago

siddhant.koseLevel 1

asked in General Product Q&A

Permissions required to read excel fill from SharePoint to celonis ML workbench?

5 months ago

arturo.orteg11Level 3

asked in General Product Q&A

I would like to define a process to do some calculations (activity_lead, pu_first)

Hello everyone, I'm trying to calculate wit PQL different metrics like the Number of cases which flow through a certain process with specified activities . I'm using activity_lead and pu_first for that. For example (this is the PIZZA CASE): SUM( CASE WHEN PU_FIRST("CASE_TABLE", "EVENT_TABLE"."ACTIVITY_EN") = 'Order by phone' AND ACTIVITY_LEAD("EVENT_TABLE"."ACTIVITY_EN", 1) = 'Start preparing pizza' AND ACTIVITY_LEAD("EVENT_TABLE"."ACTIVITY_EN", 2) = 'Start baking pizza' AND ACTIVITY_LEAD("EVENT_TABLE"."ACTIVITY_EN", 3) = 'Baking pizza ready' AND ACTIVITY_LEAD("EVENT_TABLE"."ACTIVITY_EN", 4) = 'Plan route' AND ACTIVITY_LEAD("EVENT_TABLE"."ACTIVITY_EN", 5) = 'Departure pizza' AND ACTIVITY_LEAD("EVENT_TABLE"."ACTIVITY_EN", 6) = 'Pizza arrives at customer'

5 months ago

arturo.orteg11Level 3

asked in General Product Q&A

kpi in knowledge model

Hello everyone.I'm having some trouble trying to understand how this kpi works. KPI(PURCHASING_LEAD_TIME_MARC_PU_AVG_PARAMETERIZED,${SSL_TIMEFRAME_VARIABLE},0) PURCHASING_LEAD_TIME_MARC_PU_AVG_PARAMETERIZED--> this is another kpi in KM which I have figured how it works. My problem is that I do not know how the other part (,${SSL_TIMEFRAME_VARIABLE},0) is exactly affecting the result of the main KPI. Hope someone can give me a hand here. Thank you all!

5 months ago

niklas.birnbLevel 2

asked in General Product Q&A

How to change the language of courses? I am new to Celonis and I'm doing the kickstarter course, whereas the should be a green dropdown menu to change the language of the course, but there is none. And the old method with rescheduling also doesn

5 months ago

shikha.puri11Level 1

asked in General Product Q&A

Are there selection views available in Views?

I was not able to find selection views functionality in Views which is present in Analysis and which helps very well in slicing and dicing the data.

5 months ago

kailash.potha12Level 5

asked in General Product Q&A

Adding Custom object to perspective

I am trying to add Custom object to the perspective without linking it to any object. Similar to currency conversion object. Table/Object that i am trying to add is TFACS for Workday Calendar, But result in below error.

6 months ago

parvathi.choudLevel 4

asked in General Product Q&A

I have merged two files paid invoices and unpaid invoices into one main case table, now in data model, when im assigning case table to activity table it showing error as Could not execute foreign key join: there are duplicates on both sides of

6 months ago

Anonymous

asked in General Product Q&A

I need to know if anyone out here is using an inexpensive OCR solution to extract data - e.g. from invoices -- and load into Celonis.asap.

I was under the impression that Task Mining has this capability and, EEK, I found out differently just days before closing this deal. Please answer quickly as I need an answer tomorrow, if possible. If you can give me maybe the cost per invoice, that would help.

6 months ago

richanda.wrighLevel 3

asked in General Product Q&A

Hello All, I want to check of the fourth character in a phone number and make sure it's / and also make sure the 8 character is a dash - How would I do that? Example 314/789-9696

6 months ago

richanda.wrighLevel 3

asked in General Product Q&A

PQL - I am trying to find duplicate phone numbers within my table. Does anyone know how I can write this PQL?

6 months ago

parvathi.choudLevel 4

asked in General Product Q&A

How can I Merge the 2 tables (Paid invoices and Unpaid invoices) to one main case table. After uploading the above files.

6 months ago

margaret.daven12Celonaut

posted in General Product Q&A

Automatic tailoring of PQL queries using Static PQL checks (2024-08-28)

Automatic tailoring of PQL queries using Static PQL checks (2024-08-28) You can now write PQL queries that run based on the outcome of one or more data model conditions, such as the data type of a column or the existence of match list elements in comparison operators. Before your query is run, Static PQL dynamically checks some properties of your data model and modifies or cancels your PQL query depending on the outcome of these checks. This lets you define business applications that can be used with a range of different data models, helping drive standardization. For more information, see Static PQL functions.

6 months ago

Page 3 / 58

Badge winners

marcos.candi12has earned the badge Value Assessment Expert
marcos.candi12has earned the badge Qualified to Identify and Drive Opportunities
manuela.gomeshas earned the badge Qualified to Create and Deliver Demos
antonio.figuehas earned the badge First Post
Sabahas earned the badge First Post