Skip to main content

Solved

362 Topics
.
Level 2
.146001036Level 2
asked in General Product Q&A
Why would Celonis throw errors saying there are multiple empty cells in my columns when there aren't any?

Hello All, I have a csv file (attached a screenshot of the same) which has the Case ID (column A), Activity (Column N) and the Timestamp (column O) in the correct format. There are also other columns in the file that I will be using for my analysis. The error (screenshot attached) says that there are more than 100 empty cells within the Acitivity, Timestamp and CaseID columns but I have double-checked and can confirm that, that is not the case. Has anyone experienced this before? What could be the issue over here?  This is an urgent matter so any quick responses would be much appreciated! Thanks!@1460045682​ ,@joos.buijs​ , @hugo.victo11​ 

22
.
Level 2
joos.buijs
Level 6
joos.buijsLevel 6
asked in Data Ingestion & Infrastructure
Calculate activity status duration, ignoring other activities' status changes

Hi Celopeers :) We have a specific use case, based on JIRA data. For a case a limited set of activities (~7, JIRA stories) need to be performed. For each activity (/story) we know when it was ready for pickup, in progress, and done (or rejected). If we would like to calculate the total time the activity/story spent in the status 'in progress' I was thinking of something like this: SUM( CASE WHEN "TABLE_STATUS"."STATUS" = 'In progress'   THEN HOURS_BETWEEN("TABLE_STATUS"."STATUSDATETIME",ACTIVITY_LEAD("TABLE_STATUS"."STATUSDATETIME")) / 24 --to get fractional days   ELSE 0.0 END) Where the dimension could be the different activity/story names for instance. However, the activity_lead often is a very different activity (/JIRA story), hence the calculation fails.I also cannot use a process pattern matching using first and last occurrence, as an activity can be 'in progres' multiple times and I would need to

146
joos.buijs
Level 6
G
Level 2
georg.sondeLevel 2
asked in Celonis Free Plan
First day of a month - thee month ago

In my analysis filter I need a range over three month exactly.With this formular I get the last day of the preceding month:ADD_DAYS(ROUND_MONTH(TODAY()), -1) Today: 07.06.2021 Result: 31.05.2021This is the secound part of the BETWEEN order.Now I'm searching for the first formular in the BETWEEN ordersImilar to VBA: DateSerial(YEAR(Date()),MONTH(Date())-3,1)Is there a chance? 

71
G
Level 2
M
Level 2
mel.schic11Level 2
asked in Data Ingestion & Infrastructure
I would like to count how often a Sales Order (Header) goes out of a credit block. The issue is while this activity happens at the header level, I only manage to get my KPI at the item level. Which means that it is multiplied by the number of lines.

So, I tried to solve it with a pull-up function. PU_COUNT("VBAK", "_CEL_O2C_ACTIVITIES"."ACTIVITY_EN", "_CEL_O2C_ACTIVITIES"."ACTIVITY_EN" IN ('Credit Approval Release') )   But the results do not seem correct to me:I do not think this offers a distinct valuewhen putting the KPI in an OLAP against the customer, I get duplicates for the customer. Another option that I could think of, made use of match_activity. However, this is then still at line item level.

106
M
Level 2
thorsten.schne
Level 3
thorsten.schneLevel 3
asked in General Product Q&A
KPI - Variable - Limit Characters of Expression

Hi everyone, I created a Chart and face the problem that the expression of the KPI does not fit into the tooltip.   Option 1: Is there a setting to change the size of the tooltip box? Option 2: Alternatively I wanted to limit the characters of the variables. Could you help me to insert a LEFT or RIGHT statement? My syntax does not work. <%= MyVariable %> --> Full text is shown<%= LEFT(MyVariable,10) %> --> Only show the left 10 characters

23
A
thorsten.schne
Level 3
thorsten.schneLevel 3
asked in General Product Q&A
Syntax - Replace "FIRST_OCCURRENCE" with a variable

Hi community,  I created a dashboard and would like to use a variable so that the end-user can easily switch between first-to-first // first-to-last occurrences. Could you help me with getting the syntax right. Thank you!

91
A
M
Level 2
mel.schic11Level 2
asked in Data Ingestion & Infrastructure
Aggregation to two dimensions

Hi,I am looking for a PQL code to solve the following.We have data for multiple dimension over a period of time. I would like to get the data aggregated on one dimension per month.All the data is within one table.|Dim1|Dim2|Dim3| Month | KPI ||----|-----|-----|------|---|| A    | X1   | Y1   | Jan-21 | 300 || A    | X2   | Y2   | Jan-21 | 200 || A    | X3   | Y3   | Jan-21 | 400 || A    | X1   | Y1   | Feb-21 | 200 || A    | X2   | Y2   | Feb-21 | 100 || A    | X3   | Y3   | Feb-21 | 500 || B    | X1   | Y1   | Jan-21 | 300 || B    | X2   | Y2   | Jan-21 | 200 || B    | X3   | Y3   | Jan-21 | 400 || B    | X1   | Y1   | Feb-21 | 200 || B    | X2   | Y2   | Feb-21 | 300 || B    | X3   | Y3   | Feb-21 | 500 | What I would like to get is.jan-21feb-21diff.A900800-100B900100200 I have been trying with the domain table and PU functions but I was not able to make it work.Thank you

52
W
Level 1
.
Level 2
.14600921Level 2
asked in Process Analysis
Jumping to SAP sales order from Celonis

Dear All, I remember linking SAP CRM URL to Celonis so from detailed Tab, I can jump to the transaction in URL. I dont find the steps to do that. Can someone help here? Thanks

71
M
Celonaut
salma.zeped
Level 4
salma.zepedLevel 4
asked in General Product Q&A
How to manage standardization and quality control when you support the self-service approach for users to create their own analyses? Besides, offering established templates for it.

After viewing the "Thought Leader Panel: Managing Real Organizational Change: The New Center of Excellence on CoE" I wonder: How to manage standardization and quality control when you support the self-service approach for users to create their own analyses? Besides, offering established templates for it.

21
L
Celonaut
joos.buijs
Level 6
joos.buijsLevel 6
asked in General Product Q&A
Celonis Community Archive available?

Today I noticed we moved from the Celonis Community to CeloPeers.com. This needs some getting used to of course. My main question however is if the Celonis Community will be available for archive purposes (e.g. read only), as I found it a valuable resources and it will take time before Celopeers will be at the same level.

31
EBrozio
Level 2
.
Level 3
.14600835Level 3
asked in Process Analysis
Index sheets - Front end

Hello All, Anyone knows how to use and what is the benefits of using index sheets on front end analysis? I tried using and seems its scanning open requests but not sure how is it working? Thanks, Kalpesh

23
M
Level 1
thomas.keim
Level 5
thomas.keimLevel 5
asked in Data Ingestion & Infrastructure
PU_COUNT_DISTINCT - No Common parent between tables could be found

Hello,Im looking for an solution for this challenge:We have 3 SAP ERP TablesVTTK (Shipments)VTTP (Shipment Items)LIKP (Deliveries)LIPS (Delivery Items)VTTK is linked 1:N with VTTPVTTP is linked 1:1 with LIKPLIKP is linked 1:N with LIPSI want to count the distinct material numbers per shipment.Count per delivery works fine: PU_COUNT_DISTINCT(LIKP, "LIPS"."MATNR")But I need it per shipment for further calculating KPIs, like this:PU_COUNT_DISTINCT(VTTK, "LIPS"."MATNR")Here I get the following error:No common parent between tables could be found - Please check your schema. The tables VTTK und LIPS do not have a common parent in the schemaWithin the help I found the BIND function. I tought, this can be the solution:PU_COUNT_DISTINCT(VTTK, BIND(LIKP, "LIPS"."MATNR"))But here I get an error in the formula.How can I solve this with a formula und without changing the data schema.Thanks for you helpThomas

127
D
Level 2

Badge Winners

  • Qualified to Build Views
    Pablo MChas earned the badge Qualified to Build Views
  • Qualified to Build Views
    amanpreet.sethihas earned the badge Qualified to Build Views
  • Qualified to Build Analyses
    pandiri.ravishas earned the badge Qualified to Build Analyses
  • Celonis Technical Expert
    Marlijnhas earned the badge Celonis Technical Expert
  • Qualified to Write PQL Queries
    Marlijnhas earned the badge Qualified to Write PQL Queries
VIEW ALL
Community Code of Conduct