Success Hub
Product Updates
Groups

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,457 Topics
3,459 Replies

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

1456 Topics

Most replies

Most views

Newest first

MrAjLevel 3

asked in General Product Q&A

Failed to auto save the View. Please save your changes manually

I'm encountering a persistent error in the View: "Failed to auto save the View. Please save your changes manually." Even when I attempt to save the changes manually, the View does not get saved, and none of the modifications to the UI are being retained. Is anyone getting the same issue? what could be the possible resolution?

212

11 hours ago

sayan.chakr12Level 3

asked in General Product Q&A

I am trying to access transformation scripts from ML worbench with pycelonis 2.6 . But i am not able to fetch SQL scripts from transformation jobs which belongs to a template with visibility type protected. How to open the protected from task te

4 days ago

.1460096356Level 2

asked in General Product Q&A

Change the name to an event

Hi! I would like to personalize the event names for a client demo. How can we do it? Regards

4 days ago

leonardo.spinaLevel 3

asked in General Product Q&A

Daily Average of IDs, daily period is dynamic (depends on Graph)

Hi all,I have a set of IDs/Case Keys that is spread accross 2023-2025. Focusing on 2024, I would like to calculate the daily average based on the Last activity dates.These IDs are divided in products, so when I create an OLAP table in Studio Views, then it takes the IDs per product, for large samples it’s closer to a correct daily average. On the other hand, when the product has 1 or 2 case IDs, then the Daily average is far from correct.Instinctively, I believe I should create a DOMAIN_TABLE but it doesn’t work. I tried using GLOBAL but it is not accepted.Hereby the code i’m using:Originaly:KPI("number_of_cases")/( MAX (REMAP_TIMESTAMPS (PU_LAST("PROD_CASE_TABLE_DR", "PROD_ACTIVITY_TABLE_DR"."EVENTTIME"), DAYS, WEEKDAY_CALENDAR ( MONDAY TUESDAY WEDNESDAY THURSDAY FRIDAY ) ))-MIN (REMAP_TIMESTAMPS (PU_LAST("PROD_CASE_TABLE_DR", "PROD_ACTIVITY_TABLE_DR"."EVENTTIME"), DAYS, WEEKDAY_CALENDAR ( MONDAY TUESDAY WEDNESDAY THURSDAY FRIDAY ) ))+1) orKPI("number_of_cases")/(DATEDIFF ( dd, PU_LA

151

11 days ago

josmi.agnesLevel 2

asked in General Product Q&A

Multi value search for filtering Views

Hi everyone,With the latest views in Celonis, is there a way to filter multiple values across one or more dimensions in one go?For example, I want to filter all the purchase orders where field vendor name contain any of the following: ‘zxc’,’et’,’corp’ - without having to manually select each value one by one from filter dropdowns.Is there a more efficient way to achieve this instead of configuringdropdowns to select dimensions, input boxes to enter search patterns, and variables?For multiple dimensions, this setup becomes impractical.Thanks in advance!

12 days ago

jan.vajse12Level 3

asked in General Product Q&A

Package Dependencies - Update of Views

Hello Celopeers, we would like to start using the Package Dependencies to maintain several package as DEV and one package as PROD. For KMs seems everything working fine with the KM extensions. We want to follow similar approach also in case of Views. Creating a View in DEV package and automatically synchronize the change made here to the PROD package.After some tests, we realized that changes made to View in DEV package are not reflected in the PROD package when updating the dependency.As per following description, we understood that this shoud be possible:By adding a package as a dependency, its Views and Knowledge Models can be reused using this extension mechanism. Does someone has experience with the Dependencies usage on Views and could help us overcome our issue? Thanks a lot.Jan

100

12 days ago

jan.vajse12Level 3

asked in General Product Q&A

Shared link opens last user's selection

Hello,our users face regulary the issue that if someone sends them link with a certain selection, what opens is their last selection of the view and not the selection that was shared with them. Is there any known way how to overcome this setup? If you send somebody a selection, this selection should alway show up if the person clicks on the link. Thank you for any advice.Jan

204

12 days ago

Mst11Level 3

asked in General Product Q&A

Font size

Hello everyone,Does anybody knows what is happening with the font size of numbers in KPI Cards. Some of them are extremely big and some seem to be normal sized. Thanks a lot!

565

13 days ago

NHARNISLevel 2

asked in General Product Q&A

Using Pu functions instead of Aggregates to be able to Filter KPIs

Hello Celopeers, im new to Celonis and have created a view. There i use a Kpi which drops a lot of zero values. When trying to filter them out i always get the error that aggregated functions can not be used in combination with the FILTER function, and that i should try PU functions. The KPI i'm using is this:SUM( CASE WHEN round_day("o_custom_KnotenpunktAuftrag"."AusgangForecast") = round_day("o_custom_KnotenpunktFuellstand"."Date") THEN 1 ELSE 0 END)or alternetively this : COUNT(DISTINCTcase when round_day("o_custom_KnotenpunktAuftrag"."AusgangForecast") =round_day("o_custom_KnotenpunktFuellstand"."Date") then "o_custom_KnotenpunktFuellstand"."KnotenpunktAuftrag_ID"end) is simply want to calculate for each KnotenpunktFuellstand.Date, how many Order.IDs i have where the filter condition is met.So i can have a table where im using the date plus KPI to see, how many outgoing orders i can except for each date. How can i have a row-count, based on a condition formulated as a PU functi

302

20 days ago

SabaLevel 4

asked in General Product Q&A

Classiffy

Hi everyone,I have a column with many numbers, and I have uploaded a screenshot as an example. I want to classify them into groups. FYI: I know the maximum, minimum, and median, and I also know the total number of numbers.How can I do that?Thanks in advance!

9215

20 days ago

deeksha.r12Level 3

asked in General Product Q&A

Accessing and Configuring Scheduled Reports

The reports section is intended for viewing scheduled reports, we do not see any option to configure them.

151

20 days ago

SabaLevel 4

asked in General Product Q&A

Sorting

Hey People,I need help sorting a coloumn in a table where each item number appears twice with a corresponding "Potential Savings" value. My goal is to sort the "Potential Savings" coloumn in descending order while keeping duplicate Item Numbers together (as shown in the current table). However, when I try to sort "Potential Savings," the duplicate entries get separated.Does anyone know how to sort the table in a way that maintains both the descending order of "Potential Savings" and keeps the duplicate items next to each other?Thanks in advance! Vendor Name Business Unit Item Number Commodity Last Order Date Expected Delivery Days Unit Price Potential Savings Alpha Supplies P18 0410390025 I030 2004-01-29 27 10.45 52.66 Beta Industries P20 0410390025 I030 2004-02-09 0 6.90 0.00 Alpha Supplies P18 0437150201 A110 2004-07-31 40 40.67 69.35 Gamma Solutions P20 0437150201 A110 2004-08-26 50 32.00 0.00 Alpha Supplies

182

26 days ago

gauri.pai11Level 2

asked in General Product Q&A

Involve business user with task - unable to find record in task list

Hi team,I was trying to follow as per below screenshot.But i am not able to find a record in task list although added in knowledge model(Attached screenshot below of task list component and knowledge model respectively)Can someone please guide me on this?Thank you in advance!

163

27 days ago

SabaLevel 4

asked in General Product Q&A

Classification

Hello everyone,I have a coloumn with a lot of numbers and as an example i have uploaded a screenshot of it.I wanted to classify them into groups so i wrote a case when like this :CASE WHEN KPI("max_potential_saving") BETWEEN 7000 AND 70000 THEN 1 WHEN KPI("max_potential_saving") BETWEEN 1000 AND 7000 THEN 2 WHEN KPI("max_potential_saving") BETWEEN 800 AND 1000 THEN 3 WHEN KPI("max_potential_saving") BETWEEN 600 AND 800 THEN 4 WHEN KPI("max_potential_saving") BETWEEN 400 AND 600 THEN 5 WHEN KPI("max_potential_saving") BETWEEN 200 AND 400 THEN 6 WHEN KPI("max_potential_saving") BETWEEN 0 AND 200 THEN 7 ELSE 8 ENDbut when i sort it based on the classification it does not show the Max Potential Saving in order from highest to lowest. Does anyone have an idea ? Thanks in advance !

543

1 month ago

jonas.hessLevel 3

asked in General Product Q&A

Anyone familiar with Skills?

Hello, id like to create a skill which is triggered on every first of the Month. I Created an kpi like this if Left(Today(),2) = ‘01’ then KPI = 1. So my KPI logic is working fine but, i do not found any way to use this kpi as a trigger for a Smart Sensor. I included the KPI into a Record, but when i try to use this record in smart sensor, it does not show me created attribut with my KPI. Did anyone had a similiar Projekt with triggering Smart Sensor at the first of the Month, and could maybe help me? Kind Regards Jonas

1 month ago

omar.elmouLevel 3

asked in General Product Q&A

Dear Celomates,I would like to add the rework rate as a KPI without using PQL.

I have added an OLAP table with three columns where the Count of activities is compared to the Distinctcount activity for each case key. Please find attached the OLAP table. Besides the OLAP table i would like to show the rework rate as one number by referring to the formula and outcomes of the OLAP table. How can i add a number (without using PQL) where the ration of cases with a YES", as displayed in the OLAP table, is returned as one percentage. Many thanks!

222

1 month ago

andres.naran12Level 4

asked in General Product Q&A

How to get the timestamp for an specific activity?

Hi community, I have the following challenge that I’m trying to figure out.I need to calculate how many hours were spent on a holiday, since the connection is not through SAP, I cannot use the functions that PQL provides for that.My idea is to get the timestamp related to the last activity that happened on holiday and calculate the throughput time between 9:00 AM and that specific time in order to get how many hours were spent.Example:Activity 1 → Day 1 Activity 2 → Day 2 (holiday) Activity 3 → Day 3 Activity 4 → Day 4In this example let’s suppose activity 2 occurred at 13:00, so in this case I should do the following calculation. 13 - 9 = 4 hours → This is the number of hours that were spent on holiday. Does anyone have a similar experience?

222

1 month ago

marcin.konop13Level 3

asked in General Product Q&A

Custom Attribute not available for KPIs

Hi all I have created a simple attribute that calculates a metric I will be averaging out. And in the table it looks fine. However whenever I try to call it I get an error Please assist. I presumed as documentation states that those calculated attributes are treated the same as values in a column. KindestMarcin

338

1 month ago

HafsaLevel 2

asked in General Product Q&A

celonis Vs camunda

Hello,I want to know why using Celonis and not Camunda for process improvement? I made some research and I found that with Camunda optimize I can get visualisations ..., logs from Camunda execution. So I need to know the ++ of Celonis compared to Camunda in term of improvement results and process optimization and not the approach.Thank you

180

1 month ago

puneet.duaLevel 1

posted in General Product Q&A

Can anyone confirm if we can extract the KPI data in excel format

133

1 month ago

thomas.keimLevel 4

asked in General Product Q&A

Check if a Variable (New Views) is null

Hello Community,how can I check if a variable from the new views is NULL? My challenge is to not use an filter in a PU_FUNCTION when the variable is empty.Variable: VAR_CONDITION_FILTERExample Value with multiple selection: ‘Y001’, ‘Y020’, ‘Y300’I want to use the variable in a PU_SUM Filter statement like in this way.PU_SUM("VTTK", "FREIGHT"."FREIGHT_CONVERTED", CASE WHEN '${var_condition_filter}' IS NOT NULL THEN "FREIGHT"."CONDITION" IN (${var_condition_filter}) END )But this don’t work. Error:A PQL error is preventing this query from executing.Syntax error near [IN] after reading [PU_SUM("VTTK", "FREIGHT"."FREIGHT_CONVERTED", CASE WHEN '${var_conditon_filter}' IS NOT NULL THEN "FREIGHT"."CONDITION" ] at line 9. Please refer to PQL documentation for available syntax. This here works, but I need the check if the variable is empty to avoid errors and to avoid that users has to select all the possible values.PU_SUM("VTTK", "FREIGHT"."FREIGHT_CONVERTED", "FREIGHT"."CONDITION" IN (${var_c

301

1 month ago

SabaLevel 4

asked in General Product Q&A

Filter Date in PU

Hi,How can i filter it to show the values from last year?PU_LAST("o_celonis_MaterialMasterPlant", "O_celonis_PurchaseOrderItem"."NetUnitPrice")Thanks!

221

1 month ago

SabaLevel 4

asked in General Product Q&A

Merge or Combine

Hello Everyone,In my View, some numbers appear twice — one row contains lead time and price for version A, and the other row contains lead time and price for version B.So for a specific number, you either see data for version A or version B, but I want to combine them into a single row for that number.Here’s an example of how my data looks now:Number Lead Time A Lead Time B Price A Price B 12345 28 - 10.88 - 12345 - 7 - 6.94 And this is what I want to get:Number Lead Time A Lead Time B Price A Price B 12345 28 7 10.88 6.94 Is there a way to do this?Thanks a lot!

1047

1 month ago

SabaLevel 4

asked in General Product Q&A

Duplicate

Is there a way to remove duplicate values in a coloumn ?

181

1 month ago

robert.ledigLevel 2

asked in General Product Q&A

Difference between CASE WHEN and STATIC CASE WHEN and when to use it?

Hello everyone,I hope you can help me understand the difference between the two PQL functions CASE WHEN and STATIC CASE WHEN.I can't find the difference using the documentation, and unfortunately, I couldn't find any content about it in the forum either. I would really appreciate your help and hope someone can explain it.Thank you for your support!Best regards,Robert

472

1 month ago

Page 1 / 59

Badge winners

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
karin.khourhas earned the badge Qualified to Create and Deliver Demos
karamdeep.singhhas earned the badge Celonis Certified Data Engineer