Product Q&A

as I know that Case Explorer is extracting raw data from a data table and display. If I want to change the data that is display or view originally to other data for example the order is showing username but I want to change the way it display in the Case Explorer , what are the good practices that I can try?   Any advice or suggestion would be much appreciated.

Joining between different data sources are possible in global data jobs, e.g.  select *from <%=DATASOURCE:MDT_100%>.EKPO A join <%=DATASOURCE:MDT_200%>.EKPO B ON ... But is it possible to join each other within the scoped data jobs (MDT_100, MDT_200), that means Scope MDT_100:select *from EKPO A join <%=DATASOURCE:MDT_200%>.EKPO B ON ...

Hi Everyone!, I am working on create a few automatizations for a company. Basically, I need to build action flows that will send reports when the invoices reach 31 and 91 days. I did a query of the data, but it's not taking the filters. Can anyone advise?

We are looking for a way to capture orders that are not shipping FIFO. Any ideas on the best way to tackle this use case?

I can count the connections or display an average but not display the total wait time for the entire cases. I can have a huge average but the total number of connections might be very small, or the opposite. So I'd like to see them combined (multiplied) to have an overall view. How do I do that ?

HI ,I am facing the issue with file uploading , when I have upload the csv file after that in map the data section there is no content visible for me . attaching the snap for the same. 

Hi all, I'd like to calculate ​average duration of the time on a each activity. Does anybody know how to do that? I assume this calculation logic below works but its not so smart.Assumption: we have activity A, B, C, and D. (sum of time spent A to B, A to C, A to D) divided by (Count of A to B, A to C, A to D)... My question is, Does celonis has such as functionality?Can we count the number of case ? (Bold part) Thanks   

Hello, I am trying to calculate a kpi that represents the number of average daily recallers (i.e., people who call more than once in the same day).The information is all in the same table, and I calculated the users (ID_Telefono) who for each day (ROUND_DAY(starttime)) made more than one call (UniqueID). The calculation was done with a CASE WHEN.To get the daily average, I divided the result by separate counts of the days available to me (ROUND_DAY(starttime)). (SUM (CASE WHENPU_COUNT(DOMAIN_TABLE("xcally_clean"."ID_Telefono", ROUND_DAY("xcally_clean"."starttime")), "xcally_clean"."uniqueid" )>1THEN 1END))/(COUNT(DISTINCT(ROUND_DAY("xcally_clean"."starttime")))) The problem is that the result is wrong. If I calculate denominator and numerator separately and divide them, I get 61, while if I leave the formulas on celonis, I get 142.There is no common table problem because all the information is on one tab

Building a flow counter or action flow termination´in order to prevent multiple flow executions. Hi all,I am constructing an input checker that checks if a list is empty or not before executing a Skill that sends it out in an Email.It is supposed to wait (sleep) and repeatedly load (Get Rows) the input till it is not empty and then send it out once. As a way to prevent a double execution i´m trying to create a flow counter that filters the flows if the list has been loaded with content and already sent in order to prevent multiple executions. Sadly incrementations of the counting variable only work along a single flow. Is it possible to create a variable that is globaly increased? Or a method/tool to terminate the action flow the moment a specific execution skill has been used? Alternatively I would have to build a router that filters if there is a first item in the list or it is empty and stops the moment it is filled.

what is the difference between package variables and runtime variables and what would be best use case to use them?

Is it possible to read the data of a table that we have extracted from a source system using celonis as a CSV file in the Machine Learning workbench using python.

Could you please fill in the document attached so that we have better knowledge of the type of tests and the outcome of the tests/ residual anomaly/list of requirements (…) you execute on the standard solution (prior to BioMerieux customization)? We would like to leverage the standard tests executed by Celonis and reduce redundancy on our extend.Could I rely on your feedback by the end of this week?

Both links below provide supporting information; however, there's no specifics around the String value types (i.e., any comparators featuring the "TEXT_..." command) nor is it clear how these get triggered and applied to a KPI List component, despite the chart noting its applicable. To clarify, I am trying to edit the style features to the text (e.g., textColor: using HEX code and fontSize:), specifically belonging to a KPI List component (e.g., it's title and/or heading). I have already created the 'DISPLAY_RULE' as a Custom Object within my Knowledge Model, and then selected the rule again within the KPI List Styling rule settings, but no luck. If a Celonis Employee reviews this, please refrain from sending these links as I have already reviewed these prior to raising this question. https://docs.celonis.com/en/knowledge-model---custom-objects-and-custom-attributes.htmlhttps://docs.celonis.com/en/display-rules-and-icons.html Thanks in advance.

Hi, I just would like to know this data job alerts setting is personal one and need to set by each user? or can we use user group to send those notification? https://docs.celonis.com/en/data-job-alerts

Hello celopeers. We are using a bar chart graph to display the distribution of cycle times. Cases with a specific cycle time are classified into the corresponding bucket. The feature was used a lot by our business users - however, inverse selection is no longer applicable. Do you maybe know why it is not working?

With kpiParams I should be able to give it's parameters (in this case a view variable) but I just get that errorSame sintax with a kpi list works fineSame table inside an analysis works fine too

I saw there is not a option for that, so I am trying make one. I want a chart with the most common variant but i don't know how transform the list of variants in a list with the most common variant.  I was trying to filter the variants making this KPI that permit "filter" with a second KPI .CASE WHEN COUNT(VARIANT ("BD_ACTIVITIES"."QUEUE"))> 186 THEN 1 ELSE 0 ENDThe secon KPI:Case WHEN KPI("variant_most_common") = 1 THEN KPI("PROCESS_VARIANTS__BD_ACTIVITIES__QUEUE") ELSE 'OTHER' ENDBut it gives me this 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.Right now i don't have more ideas to can continue. I dont know if someone could help me.  

Is there any workaround to assign a default value for package runtime variables?

I want to check if the delivery date is less or equal to today's date + 42 days - WHEN TO_DATE("EKES"."EINDT", FORMAT ('%d-%m-%Y))

Hi Community, I want to visualize the amount of handover moments within a case and also calculate an average for all cases. We have multiple tables but the most relevant are of course the case table (incl. Case_Key, Case_ID) and the activity table (activities, Case_Key, Case_ID, USER_ID). The USER_ID contains the relevant info I want to use for defining the handovers but I can't seem to pull it off. Any tips?

Is it suggested to make a backup workbench or a new workbench ? If our current workbench is corrupted.

In an action flow, is there a way to merge PDF's created with the "Create PDF Report" app? I need to create PDF's from different Analyses and send an email as a combined file.

For the case for parallel processes (the same data is spread across multiple connections).  For CCPM, you would write a Data Job for each source system and then merge all case, activity, and data tables. Would you simply create multiple transformation scripts for each Object (one script per source system)?  Thanks