Skip to main content

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,456 Replies
1456 Topics
leonardo.spina
Level 3
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
leonardo.spina
Level 3
josmi.agnes
Level 2
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!

80
josmi.agnes
Level 2
jan.vajse12
Level 3
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
jan.vajse12
Level 3
jan.vajse12
Level 3
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
jan.vajse12
Level 3
Mst11
Level 3
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!

545
J
Celonaut
NHARNIS
Level 2
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
NHARNIS
Level 2
Saba
Level 4
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
matthias.gielk11
Level 3
deeksha.r12
Level 3
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
matthias.gielk11
Level 3
Saba
Level 4
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
Saba
Level 4
MrAj
Level 2
MrAjLevel 2
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?

181
jonas.hess
Level 3
gauri.pai11
Level 2
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
jonas.hess
Level 3
Saba
Level 4
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
Julie Shih
Celonaut
jonas.hess
Level 3
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

50
jonas.hess
Level 3
omar.elmou
Level 3
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!

192
Poovarasan
Level 2
andres.naran12
Level 4
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?

212
andres.naran12
Level 4
marcin.konop13
Level 3
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
rita.kiss12
Level 4
Hafsa
Level 2
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
Hafsa
Level 2
P
Level 1
puneet.duaLevel 1
posted in General Product Q&A
Can anyone confirm if we can extract the KPI data in excel format

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

133
bruno.castr
Level 2
thomas.keim
Level 4
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
thomas.keim
Level 4
Saba
Level 4
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
abhishek.chatu14
Level 7
Saba
Level 4
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
abhishek.chatu14
Level 7
Saba
Level 4
SabaLevel 4
asked in General Product Q&A
Duplicate

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

181
Sverre Klein
Level 6
robert.ledig
Level 2
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
robert.ledig
Level 2
antonio.figue
Level 2
antonio.figueLevel 2
asked in General Product Q&A
Create and send automated PDF reports from Views

Hi, I currently have a dashboard in Studio Analysis for which I built an Action Flow that picks up a distribution list with certain filters so that i can send out automated emails with a pdf attachment (each with different filters). Now I wanted to do the same with a View and this is not possible.50 users should receive an automated pdf of a View on a weekly basis filtered only on their set of Divisions/ Product Groups. What is the best alternative to automate this?BR  

200
antonio.figue
Level 2
stephan.kosch
Level 2
stephan.koschLevel 2
asked in General Product Q&A
Line Break in Tables

Hello everyone, have you thought about integrating line breaks into Tables of the new views? Can you please give us a brief update on this.Thank youStephan

241
A
Celonaut

Badge winners

  • Qualified to Build Analyses
    javier.lafuehas earned the badge Qualified to Build Analyses
  • First Post
    Edwin Danielhas earned the badge First Post
  • Qualified to Build Analyses
    rafael.amanthas earned the badge Qualified to Build Analyses
  • Qualified to Write PQL Queries
    tasavhas earned the badge Qualified to Write PQL Queries
  • Qualified to Build Action Flows
    tasavhas earned the badge Qualified to Build Action Flows
Show all badges
Terms & Conditions

ANY QUESTION?

Talk to an expert
FAQs
Contact us

MORE CELONIS

Academy arrow_outward
Documentation arrow_outward
Support Portal arrow_outward
Partner Portal arrow_outward
Marketplace arrow_outward

CHECK US IN

LinkedIn
YouTube
Instagram
Facebook
Imprint
Disclaimer
Privacy Notice
Cookie Notice
Terms and Conditions
Celonis © 2025