Product Q&A

Hello there, is it intended behavior/am I doing something wrong, that even with the type attribute for an input-box set to number, the variable will still be considered a string on javascript side once set to a value via the input box?This of course results in the + operator behaving differently when performing calculations with javascript (see the example in the picture). While obvious in this case, as other operators will dynamically cast to int or float just fine and the default values work as intended before being changed by the variable input, it took more time than I'm willing to admit for me to understand, that this was the reason my annotation lines would sometimes not show up for my histogram. Here the Yaml-code for the example:metadata:  key: variable-input-test  template: false  name: Variable Input test  allowAdvancedFilters: truevariables:  - id: Value1    name: Value1

Hi I was trying to implement new functionality of connecting views directly with action flow Although, I cannot see the option of adding inputs in "Actions" menu of KM Is there any specific module to be added in action flow to enable this ? Please refer to the attached training video screenshot where we can see the option, but is not visible in training env  

Hi all. I created BPMN diagram in one project and exported it in my local PC but it doesn't contain activity information. Is it able to export BPMN with activity information which BPMN box is tied with a activity?

In our use case we are sending emails alerts to requisitioner in that we are sending them the emails and we are attaching the excel/csv file into that we want to store the date of email alerts somwhere in celonis and use that date to send escalation alert 

Hi all, I want to pulling data from a knowledge model through the following code ... space = celonis.apps.get_spaces().find('Default')package = space.get_packages().find('Knowledge Model Test')knowledge_model = package.get_knowledge_model('999-automation-rate-bw-download')content = knowledge_model.get_content() But I get the error "PyCelonisPermissionError: You don't have permission to perform 'GET' ", even I have set all possible permissions (for "Space" / "Package / "Analysis").Any ideas which permissions are missing. Unfortunately the article below does not help me here. Thanks in advance,Best,Jonas 

Are there any use cases whereby Celonis was used before an orginisation implemented an ERP like SAP? In other words, how can an organisation use Celonis to prepare for SAP implementation?

Working Student (f/m/d) for Process MiningSiemens Healthineers We are #hiring 2 students interested in Process Mining and supporting in the development of the huge backlog of Process Mining use cases for Siemens Healthineers: Please apply here: Working Student (f/m/d) for Process Mining | Erlangen, Bayern,

Hi, we have an on-prem extraction server with a working uplink connection and working SAP/JDBC connections running.When we try adding a new DB connection, we receive this error message:"Connection test failed, please check the Data Connection's configuration and ensure that the system is running: Extractor responded with an internal error" This is hard to troubleshoot, since the service is definitely running and working. Any idea on what might have gone wrong here? I can rule out a port error, as I can force this one by changing the port of an existing DB-connection. Thanks for your help in advance!

Hi Team, How to attach pdf and csv to a single mail using action flow?

Hi all, With Automation Skills, it is possible to update an Augmented Attribute with a dropdown list using Actions. The action button triggers an Automation Skill which updates the Augmented Attribute. I would like to migrate this action from Automation Skills to Action Flows, but I'm unsure about how to include dropdown values in an Action Flow. Anyone that knows how to do this? Thanks,Teun

Hello friends! :) I have a bar graph with ROUND_MONTH("ACTIVITIES"."EVENTTIME") set as a dimension and a requirement for it to display the following: -For each month, we want to get a difference of new cases between said month and the previous one-It would be ideal to also get a percentage change compared to the previous month. Have you guys ever dealt with something like this? It seems simple enough, but I've been scratching my head with this one. Thank you for your help in advance!

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

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