Success Hub
Product Updates
Groups

Home
Community
Ask the Community

Ask the Community

Get answers to general questions and Academy-related topics from fellow users and experts.

1255 Topics

charan.rajumLevel 2

setup scale picked based on annotation value of line chart

How to setup scale picked based on annotation value of line chart,I have three annotations lines upperlimit,lower limit and average if the average comes as 95% i want the scale to be displayed from 91,92,93... to 100,I know we can configure manually in component settings but is there any other way ?

1 month ago

thomas.keimLevel 4

asked in General Q&A

Using Variable in KPI/Attribute Unit possible?

Hello Community,I would like to give my users the option to display an amount (e.g. freight) in any currency. To do this, I use the function CURRENCY_CONVERT_SAP and pass the target currency via a variable. This works perfectly.My problem is the unit: Do you know of or is there a way to use my variable in the unit field so that the selected currency is automatically displayed as the unit?Thank for help, Thomas

344

1 month ago

ritesh3719Level 3

asked in General Q&A

Adding a checkbox or a button against each record in view table dashboard which will set the value of the column of that table in a variable.

I want to add a button or a checkbox against each record in a table component in view studio. This button or checkbox will dynamically set the value of a column in variable which will be used for filtering purpose in another view in same package.

192

1 month ago

sharon.josep13Level 2

asked in General Q&A

Edit Extensions in Open PO Management App

Hi, I want to edit the Extensions in the Open PO Management App but I am getting the following error message:Runtime variable ErrorThe variable Cannot read property 'PO_NUMBER' of null. Please make sure that this variable is defined.Which step am I missing? I tried to add PO_NUMBER as a View Variable and as a Runtime Variable.Thanks and best regards,Sharon

1 month ago

kandi.naiduLevel 4

asked in General Q&A

To get Count of Activities in Process Explorer

Hi Team, I am trying to write a pql query to extract value of activity count between two activities one of them is either process start or process end.Like I highlighted the value in the screenshot. please let me know, how to achieve it. Regards,Ajith Naidu.

SabaLevel 4

Hi,Is there a way to compare the value of the 2 row and return the one that is smaller and then sum all the smaller values together ?Sampleid 1 = 5id 2 = 20id 3 = 7sum = 5+20+7 = 32

1 month ago

CelonisAcademyLevel 3

posted in Academy Q&A

New Course: Maximize Data Value with AI Annotation Builder

Get the most out of your unstructured data and auto-classify data with AI Annotation Builder!The course is available here.

250

1 month ago

Iori OshimaLevel 3

asked in General Q&A

How to activate the process in Process Navigator?

Hi all, I’d like to confirm the common release process.I’m a article, and I’ve released the sub process but I couldn’t activate the process in Process Navigator. I’ve alredy checked the Permitted set and there is no permission set. What are common issues?I can’t click in Process Navigator

1 month ago

ramasrikari.donta12Level 2

asked in General Q&A

Initially I had four attempts to complete the Rising star technical assessment. I failed in the first two attempts of the first section. Now it shows 0 attempts remaining.I have competed all other sections.Please guide me how to restore those at

285

1 month ago

Hannah37310Level 2

asked in General Q&A

Bar chart including incomplete quarters

I’m attempting to create a bar graph that shows opportunities created by quarter (Q1, Q2, Q3, Q4). However, I want to include incomplete quarters (ex: Q1 - 2025, but I have no data for March 2025, only Jan 2025 and Feb 2025, but I still want to show this quarter). Is there a way to do this? I’ve tried a bunch of things, but none make the incomplete quarter appear. Thanks!

140

1 month ago

HakanLevel 2

asked in General Q&A

Experteninterview Bachelor-Thesis

Hallo zusammen,im kommenden Semester schreibe ich meine Bachelor-Thesis u.a. zum Thema Process-Mining. Hierfür bin ich auf der Suche nach Interviewpartnern und habe hierfür bereits mehrfach per e-Mail und am Münchener Standort angefragt. Eine Rückmeldung hierzu habe ich bis Dato nicht erhalten. Ist es möglich, dass Ihr mir einen Ansprechpartner nennt? Vielen Dank und viele Grüße

1 month ago

marilyn.tortaLevel 2

asked in General Q&A

Requested column of table is not present in the according parquet file

HI everyone! I’m getting this error message when trying to Load my data model with a new table: “The requested column EKKO.INCO1 of table Agreements is not present in the according parquet file” .However the table “Agreements” is created in the data job with the same functions as any other table in the data model (“Create table Agreement AS ( Select CAST (EKKO.INCO1 AS VARCHAR) AS "EKKO.INCO1"...etcetc) so I don’t understand where this “parquet file” format is coming from… any idea?

douglas.souzaLevel 3

How do I calculate the Cycle time in OCPM, when my process starts in one object and ends in another?I tried PU functions + bind but I didn't get good results. If anyone can help me I'd be grateful.

222

2 months ago

leonardo.spinaLevel 3

posted in General Q&A

Consistency in Studio Views - no visible errors for the user

Hi all,What are your methods to crosscheck all information is correct in a Studio View?Using Variables and the Knowledge Model is a very important practice, when changing formulae in the KM, then the components automatically update.However, when using a KPI from the KM is not possible, how do you ensure consistency throughout different tabs? How do you guarantee to the users that they won’t find any misalignments or mistakes?Is there a specific methodology at hand, besides suggesting a manual check tab-by-tab?Thank you for your guidelines.

2 months ago

PhuongBHNLevel 3

asked in General Q&A

Updating a Variable in Celonis Studio when Date Filter Changes

Hello everyone,I am facing an issue while working with Celonis Studio. I have created a variable as follows:YEAR(ADD_MONTHS(ROUND_MONTH(MAX("view_meviy"."timestamp")), -1)) ||MONTH(ADD_MONTHS(ROUND_MONTH(MAX("view_meviy"."timestamp")), -1))Now, I want this variable to respond to the date filter in my report. Specifically, I want the variable to update its value to reflect the previous month based on the selected date in the filter.I would appreciate any assistance and guidance from the community on how to properly set this up.

130

2 months ago

kandi.naiduLevel 4

asked in General Q&A

How to configure input dropdown in views

Hi Team, I’m working on input dropdown where my timestamp should be convert into daily,weekly,monthly and if it is daily I need 8 hrs , for weekly 40 hrs and monthly 173 hrs in one single dropdown. How I can achieve it. Regards,Ajith Naidu.

253

2 months ago

manuel.wetzeLevel 5

asked in General Q&A

Filtered Cases: Ring Chart-> Pie-Chart Update ?

Hi all,I was wondering about a minor style change of the platform I noticed yesterday.Next to all the applied filters where there is the a small visual indicating how many cases (in % and absolut by hovering over it) are currently selected. This was for a long time a Ring chart. Suddenly it became a pie chart yesterday. Introducing the added problem, that the % number in the middle is poorly visible if the background is split in half into darkblue/light grey by the pie cutting trough it.For a colleague of mine the change was already present yesterday. For me only today.I haven’t about any release plans about this and am wondering about it.My Question is if I as an Analyst can influence that or if it is tied to the user account, of if it is just a given by the platform and we have to accept it.

101

2 months ago

ayush.gupta11Level 2

asked in General Q&A

Getting Error while trying use domain table function for two different tables

HI Team,I have One table which has Vehicle ID and other Table which has PartDetails. I want to count claim number from this but both columns are coming from different tables. When I tried using this with DOMAIN TABLE it is giving me following error message:-Pull-Up-function could not be executed. PU_COUNT_DISTINCT: Cannot execute PU-function on tables [<DOMAIN_TABLE ( "O_CUSTOM_CLAIM"."VEHICLE_ID" , "O_CUSTOM_CLAIMLINEDETAILS"."PVTXT" )>] and ["o_custom_Claim"], since they do not have a 1:N relationship. You might want to make use of the BIND function. Join path: [DOMAIN_TABLE ( "O_CUSTOM_CLAIM"."VEHICLE_ID" , "O_CUSTOM_CLAIMLINEDETAILS"."PVTXT" )]1 --> N[o_custom_ClaimLineDetails]N <-- 1[o_custom_ClaimLines]N <-- 1[o_custom_Claim]. For more information on the join path, search for "Join functionality" in PQL documentation.Can anyone assist?

323

2 months ago

mateusz.skurzLevel 2

asked in General Q&A

How to open a filter bar from the view that was opened in overlay?

Hi all,In my View analysis I added the filters into the ‘Show Filter Bar’ that resided on the right side of the view. However, once the same view is opened in overlay, the ‘Show Filter Bar’ is not visible - hence I have no access to the filters. Is there a way to include a Filter Bar into a view opened in overlay? Thanks and kind regards,Mateusz

301

2 months ago

douglas.souzaLevel 3

asked in General Q&A

Action Flow partial result http

Hello celonauts, I have a question. I'm creating an action flow that will access an API, but it needs to generate a token and then go to access. In the first step, I generate my token, but it comes composed. I would like to get only the part that brings the token: Example{"token_type":"Bearer","expires_in":3599,"ext_expires_in":3599,"access_token": "value-token"}.I need to get only the "value-token" part after the "access_token":Is there any way I can do a spit or something like that? I don't know how to get out the other side.

502

2 months ago

kandi.naiduLevel 4

asked in General Q&A

How to write pql for this tables.

Hi Team, I am trying to create a column chart where I am using 2 tables custody and activity_table .However I am end up with no common table error. The joining in the datamodel as follows:custody(N) ← MCA_CA_ID_NEW(1) → Line_table(N) ← Head_table(1) → Activity_table(N).How I can write the pql statement for this .

310

2 months ago

David.KönigLevel 2

asked in Academy Q&A

Problem with personal EMail in a Workflow with Trigger GMail

Hello guys,I am currently taking the pathway “Automation” in the Rising Stars Program and in the Module “Process Automation Basics” / Automate with Action Flows (https://academy.celonis.com/learn/course/automate-with-action-flows-i/automate-with-action-flows-i/course-outline?client=academic-alliance-celonis&page=2) I have a problem with setting up the GMail Trigger. I set up the API and the OAuth-Client just as presented in the tutorials. the only change was that, because we dont have the affected persons Email I used my regularly GMail. As I am setting up the Trigger I have to sign in in Google and just like the tutorials i use (the same) Gmail Account. As I want to proceed following error message pops up: I hope somebody can help me, because I have absolutely no idea left what I could try to fix it.Thanks in advance for helping me out!Best wishes,David

191

2 months ago

utkarsh.rasto11Level 2

asked in General Q&A

How to create OLAP Tables with sub-categories?

As evident from the above image, there are further sub categories in the metrics column. Can we create an OLAP table in similar fashion?

431

2 months ago

Mst11Level 3

asked in General Q&A

Changing the color of the textbox

Hi, in the legacy view there was possible to change background color of textbox, buttons etc. but I cannot find a way how to do it within the new views. I tried to do it through the YAML but it’s not working. So if someone has an idea it would be awesome!

571

2 months ago

milan.ericLevel 3

asked in General Q&A

ActionFlow: Update Augmented Attribute

Hello, I am trying to create an ActionFlow for updating augmented attributes but its keeps giving me errors. The operation failed with an error. 400: Failed to update augmented attribute. Failed to query engine to map identifier from one value to separated columns. Unknown query engine failure I created an augmented attrobute in legacy views with a unique identifier. Now in the ActionFlow I do all my selections with the correct identifier: And I get the correct result in the input: But it doesnt update the augmented attribute due to the error: As you can see the identifier is the same. What am I doing wrong here?

781

2 months ago

Page 2 / 51

Badge winners

zayneb.alsum11has earned the badge Qualified to Create and Deliver Demos
samer.odehhas earned the badge Qualified to Deliver Business Value with Celonis
Vladimir Smoleyhas earned the badge Value Realization Expert
Vladimir Smoleyhas earned the badge Qualified to Deliver Business Value with Celonis
zayneb.alsum11has earned the badge Qualified to Manage Change and Scale Adoption