General Product Q&A

Hello, I am using the Query Data module in an Action Flow. The output of the various date fields appears as below - instead of a regular date format like YYYY-MM-DD. How can I change the output of the column in Query Data?

Hi, i am just starting to familiarise myself with Celonis and have started with the Celonis Academy. Now I have a simple question.  Currently I have this formula: COUNT(DISTINCT "OCH_Cases". "Party_Request_KEY")I want only values greater than 2 to be displayed. What should the formula look like then? Best regardsRene

What does dotted line means in the Process explorer?

I wanted to build an automated report tracking the number of logins / usage in celonis. How to do that? I know log gets created for all the activites in celonis. But I wanted to build the report out of that. Is it possible to do that in celonis.

What does it mean if my happy path throughput time is more than average throughput time of the Process? Suppose my process takes 50 days in average, but my happy path takes 60 days. Is it bad?

Hi all, My interest is to calculate the THROUGH PUT time for all the desired set of process flows. I would like to view the distribution over a BOX PLOT. I am using the below approach.CASE WHEN PROCESS EQUALS 'event A' TO ANY TO 'eventB' then 'Process1'WHEN PROCESS EQUALS 'event B' TO ANY TO 'eventC' then 'Process2'ENDThe above formula will act as dimension axis for my box plot. I am calculating the tp time accordingly. However, since most of my cases(for e.x. 97%) satisfy the first condition, i cannot seem to calculate the tp time independently for other event or process correctly. The tp is calculated only for the remaining cases.Kindly suggest any other approach for the same. Thank you in advance :)

any function used in pql to calculate days between the two date column such as in excel networkdays does (consider start date and end date , exclude weekends, ignore timestamps)

Is there any function in PQL which calculate days such as networkdays (used in excel and it will ignore timestamps, exclude weekends ,conside start and end date )does?

Dear Experts , We wanted to understand the possibility of integrating Celonis EMS platform with third party BPM application like ARIS Connect to transfer discovered BPMN model from Celonis EMS to ARIS BPM application. Thanks in Advance. Regards,Navalan Veerapandian

What is the difference between an eventlog and digital footprint?

Imagine you speak with a client at a first meeting of Process mining. They ask you What is the benefit of Process mining ? How it works? What is Process mining? How would you convince them it is useful? Which arguments would you use?

Hi,I am trying to leverage the existing P2P cockpits for KPIs and Dashboards. There is an KPI which has definition as below - WHEN ISNULL(<%= VAR_KPI_DELIVERY_TYPE %>) = 1 //         -- Date Selection           AND PU_FIRST("EKPO", "<%= VAR_GS_ACTIVITY_TABLE %>"."EVENTTIME", "<%= VAR_GS_ACTIVITY_TABLE %>"."ACTIVITY_EN" = '<%= VAR_ACTNAME_CREATE_POI %>') >  {p1}        AND PU_FIRST("EKPO", "<%= VAR_GS_ACTIVITY_TABLE %>"."EVENTTIME", "<%= VAR_GS_ACTIVITY_TABLE %>"."ACTIVITY_EN" = '<%= VAR_ACTNAME_CREATE_POI %>') <= {p2}        THEN NULL         //Here there are 2 parameters p1 and p2. The values are blank for those parameters. I am not sure what values to be given for those. Can you please help me here?

Dear All, In my system report , CASE ID - Truck No , Activities , Time stamp are in column because of this , Error found in CSV/XLSX Upload screen. How to convert my report to upload in EMS format. Regards Rajkumar Pitchiah CMILT , CLTD , LSSBB Chief Digital Transformation officer – CDO  http://www.inspiretechnopark.com

What is the difference btw. an event log and a digital footprint?

Looking to add a variant explorer in the Views based on my knowledge model.  Similarly - is it possible to have a case explorer?  I believe I can create an analysis linked to the Knowledge model, but then I don't seem to have the ability to select the case table I want to use in the explorers...

In Detail I want to know how I could get the times of my (20) activities (P2P-Process from Celonis). Specially the time between the activities without working in an activity and the time which is needed only for the progress itself.

Hello everyone,  i would like to build Line Chart from this following data structure:   I would like to set up the line chart with different lines with dates on the x axis and each line presents an group of column A, where Column B are the y-values for the corresponding x value.  I tried "CASE WHEN column A = 'AA' THEN Columb B END" as KPI and date as dimension but it doesnt work since the NULL values for BB and CC in Column A are still presented in the line chart. Also a component filter did not work with it.  Thank you for every help. Best regards, Jurgen

hello to everyone, is there an example how action flows interact with rpa ?

Hi, can someone help me with a filter script. I need to show a KPI with a date filter for today at 5:00 am. The client wants to see a snapshot every day of the cases open at 5:00 in the morning. Thank you, Denise

CASE WHEN "AE_SIGNALS"."AE_SKILL_NAME" LIKE ('%Veredelung%') THEN COUNT ( "AE_SIGNALS"."SIGNAL_ID" ) * 30 / 60 ELSE NULL ENDI get the following error:The aggregation function COUNT cannot be used together with a dimension function input. Please check that there are no aggregations and dimensions used together as function inputs.

I wanted to create a KPI with reference to Variable <%= Discount %> (Users could define their Discount value). For example KPI as Actual Sales: (KPI (Sales)- KPI(Sales)* <%= Discount %>)).I'm able to create it in Analysis by defining Variable and adding the VARIABLE INPUT (Users may add their discounted values) Component however not in Views.

Slider Bar component like below:

Is it possible to create a Gantt chart like the image?If so please tell me how. Thanks!