Product Q&A

Hi All, I'd like to add a button to my sheet that allows the user to automatically filter for the last 7 days, and a separate button that allows the user to filter for the last full week. Bookmark selection doesn't seem to work, since the bookmarks are static. Thanks!

Hi all, I want to add a button where the user clicks and it filters the cases based on the following conditions. What's the best way of doing it?  FILTER PROCESS EQUALS 'IC SB Purchase Order Created';FILTER PROCESS EQUALS 'IC SB Billing Created';FILTER PROCESS EQUALS 'IC SB Invoice Receipt';FILTER DAYS_BETWEEN(    PU_LAST(      "EKPO",       Round_Day("ACTIVITIES"."DATE1"),       "ACTIVITIES"."ACTIVITY_EN" = 'IC SB Billing Created'    ),     PU_FIRST(      "EKPO",       Round_Day("ACTIVITIES"."EVENTTIME"),       "ACTIVITIES"."ACTIVITY_EN" = 'IC SB Invoice Receipt'    )  ) > 30; Thank you.Guilherme Luz

Can anyone please give me the explanation about their difference with respect to a business point of view. Like if a client asks why you are showing me case frequency and activity frequency for change price. That what should we say?

Hello,We have lack of knowladge . We would like to load a process flow like this.Lets assume we have process Flow like that A-> B-> B->C-B->B-> D->B->B->EWhen we do conformance I would like to use A->ANY To ANY -> C Any to Any ->D Any to Any->EI mean Any activity between A->C could be exits. We tried this solution but unfortunately, it didn't work as expected. All of our cases detact as violation. We implement BPMN as below. What we did worng ? Best Regards,Vahide.

Pls see the line 2 & 3 of the screenshot.

When to build an extractor from scratch and when to use uplink connections differentiate?

How to check any dimension (like Vendor etc) wise Violation Rate?

Hi, I am Manohar and I would like to change email address associated with the account as my earlier email was blocked when I resigned from the organization. Can someone guide me how to change email address and how to login with fresh email address? Thanks,Manohar

Hi, we want to showa histogram which shows days a particular case takes to get resovled(Days Spent), instead of the actual start and end timestamps. So in this sample data set assume we have sveral cases of each type between the start and end timestamps, which would show up as counts in the histogram. How to achieve this. Histogram Query938656 96.3 KB

Hi All,I have basic question on PQL. How can I explore PQL for process mining? Do we have any start up guide? Should I need to have full license version to explore PQL ? ThanksDurai

I have the six intermediate certifications that were obtained in the previous training program: Celonis App CreatorCelonis Business Value ArchitectCelonis FoundationsCelonis Implementation ProfessionalCelonis Sales ProfessionalCelonis Solution Professional But these certifications have not been migrated to the new program, is this correct and do I need to do anything?

Hi all, I have a basic question regarding activity table column configuration. We have the luxury of having start AND end datetimes for each activity. I remember this was possible at some point to specify the date columns as such with the effect that for each activity the duration was calculated and shown in the process explorer (performance view).  Is this still possible, and if so, how? Thank you!

Hi celopeers, I am trying to build out a trend chart that plots the open invoice aging over time. In terms of dimensions I have the following: x axis - ROUND_MONTH(INVOICE CREATION DATE)y axis - AVG(TODAY - CREATION DATE) for open invoices only The issue I'm running into is that since KPI is tied to creation date and today's date produces a strictly negatively sloped trend as shown below, which makes sense in practice (beacuse both axes are tied to creation date), but not exactly what I'm looking for.  What I need to show is the change in trend by month, but that will require detaching the KPI calculation from the creation date, sort of like a snapshot of the KPI at the end of each month, kind of like transformation center did it before. Has anyone successfully accomplished that before? If so - how did you do that? Thanks!Eugene

I am a beginner and want to get certified as Ceolins , can any one please guide me where to start from scratch and where would i find study material

AWS connection from s3 to celonis. Where exactly is the window to enter the key and secret to achieve the connection (the documentation is a bit lacking)

from pycelonis import get_celonisfrom pycelonis.root_cause_analysis import root_cause_analysis celonis = get_celonis() dm = celonis.datamodels.find('c4cb1efc-fa6a-4704-bc51-b3b365c5e796') kpis = {'late_payment': """      CASE WHEN PU_COUNT(P2P_case, "Activity"."ACTIVITY_EN", "Activity"."ACTIVITY_EN" = 'Clear Invoice')=0        AND         DATEDIFF(dd, PU_MAX("P2P_case", ROUND_DAY("Activity"."EVENTTIME"), "Activity"."ACTIVITY_EN" =       'Create Purchase Order Item'), TODAY()) > 0       AND        DATEDIFF(dd, PU_MAX("P2P_case", ROUND_DAY("Activity"."EVENTTIME"), "Activity"."ACTIVITY_EN" =       'Create Purchase Order Item'), TODAY()) <= 60       THEN NULL       WHEN PU_COUNT(P2P_case, "Activity"."ACTIVITY_EN", "Activity"."ACTIVITY_EN" = 'Clear I

So far, for my company ONTRAAK, I am not able to see who is doing what and with which rights on the Celonis environnements.Thanks in advance ! Olivier Laviale

Error while transforming Data - Quickstart P2P Hello, is there any way to gain further insights while using the quickstart P2P mode? Im having an error while transforming the data and would like to see the reasons for this. Thanks!

I would like to update a runtime variable with the value selected (either AVG or Median)

I am unable to access the trainings required by my organization. I need urgent help

Team, We have to write a code for threshold which can be read as - --Any transaction with an amount (the total of debit line items in a transaction) if less than 1000 then threshold would be <1000, if the amount is less than 5000 then it would be <5000 else >5000. -- We code it with PU_SUM but the concern is that the threshold is getting applied on the total absolute amount (i:e total of debit and credit of a transaction) and then the threshold is getting applied which is not correct.  INSTEAD IT SHOULD SAY IF THE FIELD IN BSEG.SHKZG IS "H" THEN TOTAL OF AMOUNT FIELD CORRESPONDING TO "H" FIELD IN BSEG.SHKZG AND THEN THE THRESHOLD CODE SHOULD BE APPLIED IN CONJUNCTION WITH "H" FIELD .  ANY HELP WOULD BE REALLY GREAT. THANKS.ANKUR 

Is there a way to calculate the throughput time also for negative values (activites in different order) than start -> end in "throughput time search" visualization?Like also having end -> start included in the same visualization, if there are variants that follow different order of activities.The default of "throughput time search" is to only show variants that follow the defined order.My work-around was to create custom datetime columns for the two activities in the case table, and then just use datediff calculation between two columns. But it seems rather clumsy way, and also binning is required to make it look nice..Thank you for comments

---------------------------------------------------------------------------KeyError Traceback (most recent call last)Input In [1], in <cell line: 13>() 29 for sheet in analysis.published.sheets: 30 # if sheet.pql_filter is not None and re.search(find_pattern, str(sheet.pql_filter), re.IGNORECASE): 31 # print ("Sheet filter of analysis: " + analysis.data["name"] + "; Sheet: " + sheet.data["name"]) 33 for component in sheet.components: 34 # if component.pql_filter is not None and re.search(find_pattern, str(component.pql_filter), re.IGNORECASE): 35 # print ("Component filter of analysis: " + analysis.data["name"] + "; Sheet: " + sheet.data["name"] + "; Component: " + component.name)---> 37 if len(component.pql_columns) > 0: 38 pql_columns =

can you please make a video how to integrate the Uplink Integrations also how to create a data connection 

Does anyone know the maximum number of runs an action flow can go through before it error's out? I need one to pull data from slack on a consistent basis without having to manually run it.