- - Knowledge base overview
Product Updates

Welcome to the Celonis Community

8 days ago

Home
Community
Ask the Community
General Q&A

General Q&A

Can't find what you're looking for? Ask it here!

1,123 Topics
2,445 Replies

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

1123 Topics

Recently active

Most replies Most views Newest first

ashwin.hosbe

asked in General Q&A

SOURCE - TARGET

Hi I am trying to calculate the time elapsed since the occurrence of a particular activity and all subsequent activities in the case.For example, if there are 5 activities in a case, of which the activity 'Lodgement' is the second activity. I would like to calculate the time take between 'Lodgement' and the 3rd activity, 'Lodgement' and the 4th activity and 'Lodgement' and the 5th activity.Note:1.The number of activities per case is not a fixed number.2.The occurrence of 'Lodgement' activity is not fixed in the activity order. Any pointers on how this can be done in PQL is much appreciated.Many ThanksAshwin Hosbett

Hi All,I am trying to find out how long a case officer spent time on a case on a daily basis.For Example - If there are two officers - Alex and Rick, I would like to find out how much time Alex and Rick spent per case every day.Any pointers on how this can be done would be helpful.Many Thanks!RegardsAshwin H

3 months ago

douglas.souza

asked in General Q&A

ORACLE EBS - COLUMNS ERROR FLOAT

HELLO, CAN YOU HELP WITH THIS ERROR: The load failed: Load failed. Error message: Error joining table ["OE_ORDER_LINES_ALL"] with table ["HR_ALL_ORGANIZATION_UNITS"]. The data type [FLOAT] of column ["OE_ORDER_LINES_ALL"."ORG_ID"] does not match the data type [INT] of column ["HR_ALL_ORGANIZATION_UNITS"."ORGANIZATION_ID"]. I HAVE ALREADY PARAMETRIZED THE COLUMNS AS FLOAT IN ALL EXTRACTIONS BUT THEY STILL HAVE AN ERROR

3 months ago

peder.stenb

asked in General Q&A

Hello; I get the error message "Extraneous ''' "when I try to write the following PQL-Query in Views.KPI("REPEATED_CASE_COUNT_SELECTED", VARIABLE('Scan Invoice', 'Send PO Auto (Jaggaer)'))Does anyone recognize what the problem is here?

Hello; I get the error message "Extraneous ''' "when I try to write the following PQL-Query in Views. KPI("REPEATED_CASE_COUNT_SELECTED", VARIABLE('Scan Invoice', 'Send PO Auto (Jaggaer)')) Does anyone recognize what the problem is here?

3 months ago

ugandhar.konap

asked in General Q&A

Hi Celopeers, How to apply saved filter(i.e., saved in KM) for a component in Views..?(getting error while applying the saved filters)

In analysis we can use component filter to filter by using saved formulas whereas in Views able to filter only by selecting attributes but not saved formulas. Even I have created filter in KM and published & tried using that filter for a component in Views getting error like PQL ErrorA PQL error is preventing this query from executing.KPI with name "Case_type_new" could not be found.

3 months ago

ana.alves14

asked in General Q&A

If I change all filters in the Replication Cockpit Configuration to: "directly delete data from the data Pool table", would all dashboards be affected? or would it only be possible for certain dashboards?

if so, do I need to make this change in all Filters? Thank you BRAna

3 months ago

pruthvin.v11

asked in General Q&A

I'm getting "undefined [id:table-380082fa-c77c-4d37-9710-9408474b11d1]: Table could not be found. Table with name INEFFICIENCIES_AUGMENTED_FRAMED_VALUE cannot be found." Error in the Procurement Starter KitI have added INEFFECIENCIES as well kin

3 months ago

andrej.barto

asked in General Q&A

Is it possible to update package dependencies automatically (via pycelonis, action flows...)? My base knowledge model is extended in multiple different packages and I would like to automatically update all extension KMs.

3 months ago

angelika.klemeLevel 1

asked in General Q&A

Hi, I am working with Views and trying to create two process explorers within one page and, to make benchmark possible, I need independent filter dropdowns.

Is there any way to somehow connect one filter with one specific process explorer instead of filtering both simultaneously?Was trying with the YAML editor, but with no success.

3 months ago

bhupendra.singh.thaku

asked in General Q&A

Why i am getting error : Table with name INEFFICIENCIES cannot be found?

System: SAP S4/HANAApp Name: Accounts receivable Starter Kit Section : Value Discovery App undefined [id:table-380082fa-c77c-4d37-9710-9408474b11d1]: Table could not be found. Table with name INEFFICIENCIES cannot be found.

3 months ago

taira.ito

asked in General Q&A

How can I extract the 10 most recent records based on the timestamp for each Innercode in　the table?

Hello. I work as a data analyst in a logistics warehouse, and I am totally new to Celonis and not very experienced in SQL servers either, but I was given the seat, since former analyst has retired.My task is to create a Item-weight master that daily updates unit weight , with average of unit weight calculated from 10 most recent weighted record. Since there are no RANK or TOP functions in Celonis, I am confused how can this be done.Can anyone tell me how is it possible to be done on celonis? Thank you.

3 months ago

milan.eric

asked in General Q&A

How to use the D3 Formatting to align a single column?

Hey, I cant really find a lot of information about how to use the D3 Format for columns.How do I align a single column to the center here?It says to use "^" but I cant implement it. Thanks!

3 months ago

akshay.harid

asked in General Q&A

How can we extract data related to Action Flows using python.

Hi All, I would like to know if anyone has any idea on how we can extract data of Action Flows into machine learning workbench using python.(NB: I am using pycelonis version 1.7.2)

3 months ago

apurva.patha12Level 1

asked in General Q&A

How to limit the filter for the one table only in new view?

3 months ago

volker.zies

asked in General Q&A

My company is changing its brand name, also all employee e-mail addressses change. How can we manage this change with Celonis?

3 months ago

apurva.patha12Level 1

asked in General Q&A

I want to create a variable in new view which would add every current year automatically into the table.Please help.

I want to create a variable in new view which would add every current year automatically into the table. Please help.

3 months ago

muhammad.azeem

asked in General Q&A

I know it might seem simple question but i am struggling with uploading BPMN file for my conformance sheet. can anybody tell where and how to upload it ?

3 months ago

gabriel.cifueLevel 1

asked in General Q&A

I want to know who is my Partner Manager Urgently: Thanks gabriel.cifuentes@cliptecnologia.com

4 months ago

harini.p26

asked in General Q&A

How to add the action send an email in the enhanced view

I have add the action send an email for the enhanced view for a table but when i select the button to execute the action it is giving me a pop up. Any way to resolve it

4 months ago

hariprasad.tanak

asked in General Q&A

Can i change my name after completing training track and get certificate with the changed name?

4 months ago

mark.schucLevel 1

asked in General Q&A

I registered a few days ago for c4c and have not heard anything since. Just to be sure, how long does it normally take until I have been vetted? (I still have enough to do in the Academy but it would be nice to know a timeframe)Thx Mark

4 months ago

vinay.sutar

asked in General Q&A

Query regarding Celonis Rising Star - Business Assessment

Hello, Actually I have passed 3 out of 4 sections in my first attempt itself but I failed in one section which is Section 2: Process Mining Fundamentals. For this section I failed in my first 2 attempts. So now I want to give it try but I am unable to. So, the instruction say that we have 4 attempts in total. First two and then 2 days cool-off and again last 2 attempts. So now it's been more than 2 days since my last 2 failed attempts but still I haven't got my last 2 attempts, it's saying 0 attempt left.

4 months ago

samruddhi.kale

asked in General Q&A

Query regarding Celonis Rising Star - Business Assessment

4 months ago

saisukeerthi.yarla

asked in General Q&A

I did not use my attempts but it is showing 0 attempts remaining What should i do?

4 months ago

matias.pinto12

asked in General Q&A

Hi! i want to integrate a dynamic pareto front to scatter plots in my analysis. I want to integrate the pareto front point as red points into the plot. The optimals could change depending on the actual filters of the dashboard. Do you know how t

4 months ago

Page 4 / 45

Badge winners

ben.lakho11has earned the badge Certified to Build Analyses
ben.lakho11has earned the badge Certified to Get Data Into Celonis
ben.lakho11has earned the badge Certified to Build Action Flows
ben.lakho11has earned the badge Certified to Build Views
ben.lakho11has earned the badge Certified to Write PQL Queries

Show all badges

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

Login with SSO

Login to the community

Login with SSO

Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.

Enter your e-mail address

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.