General Product Q&A

 I would like to sum this resulting column up and get an INT for example.  CASE WHEN(  CALC_THROUGHPUT(FIRST_OCCURRENCE['Sendung elektronisch angekündigt']   TO LAST_OCCURRENCE['In der Region des Empfängers angekommen'],   REMAP_TIMESTAMPS("Amzn_activity_table_xlsx_Tabelle1"."TIMESTAMP", MINUTES))  >   GLOBAL(    AVG(    CALC_THROUGHPUT(FIRST_OCCURRENCE['Sendung elektronisch angekündigt']     TO LAST_OCCURRENCE['In der Region des Empfängers angekommen'],    REMAP_TIMESTAMPS("Amzn_activity_table_xlsx_Tabelle1"."TIMESTAMP", MINUTES))    )    *1.2)) THEN 1 ELSE 0 END 

It appears I cannot create a data job that extracts from a DB View. Is that correct? Is there a way to make that happen? It is easier to create the data within the SQL Tables vs bringing it into Celonis and then doing all the conversion. Mostly because I need to convert Key fields to get them to allow relationships. Is there a way around this or do we really have to ETL the data in Celonis? Worse case we create the views and dump the tables into XLS and import. I was hoping for something easier. Thank you.

Hello together, is it possible to set a datepicker for one specific component? I would like to compare two OLAP tables (first 6 months vs. last 6 months) in one sheet with individual datepicker each.

I'm looking for a drag & drop or move function. I could download and upload the .bpmn files, but they I'd lose the versions.

I was thinking on using something like Name Mappings, but you can't. ​The idea was to have something in your _CEL_ACTIVITIES likeACTIVITY = '1.1'ACTIVITY_EN = "Receive Order"ACTIVITY_ES = "Recepción de Pedido" and then use only ACTIVITY for all the PQL codes I could need But the user will see the activities names in their selected language

Hi,How can I pull data from an Olap table in Package A in my Space, and push it to Package B in the same Space, using Machine Learning? I have a script that pulls data from Package A, but I am missing the second part, to push this data into the Package B

Where is the Problem in my expression and where can i find documentation that isn't blocked by Celonis firewall? When i try to open the celonis. help website i get blocked by the firewall no matter from what and where i try to access the website. Every help is much appreciated, thank you!

Data not visible even though I get a status 200

Is it possibly to use the ADD_WORKDAYS with a workday calendar in a Tranformation for the activity table in order to create the EVENTTIME field?

Hello, I have a line graph linked with time filter (year, month, week and days) but the dimension axis (x) is alway "month - year" despite the filter i select. When i select the filter week i would like to have the week in dimension, .... Any ideas ?

How to filter on count formula results? I'm trying to create a 'COUNTIF' PQL, something like this FILTER(COUNT("LFA1"."NAME1") >2 ). Is this possible in Celonis? Thanks!

hi there, I get the data into Celonis via DB Connection and in the table configuration I would to extract of last 3 years, is it possible to set a filter e.g. CreateTime >= systemdate -3 Years?

We are migrating all our workspaces from Process Analytics to Studio, and i was wondering how personal bookmarks can also be migrated to Studio.

My issue is that I want to track changes for Activities like: Activity 1 - manual - 0 (changes)Activity 2 - automatic - 0 (changes) Activity 3 - manual - 0 (changes)Activity 1 - automatic - 1 (change)Activity 2 - automatic - 0 (changes)Activity 1 - manual - 2 (changes) Each time the activity execution handling changes it should count +1.Goal: To get an overview over the sum of execution changes per Activity over all cases.  

May i know how to divide the one big analysis file into two and establish the link between these two files to make it as interactive for better performance?

Hi, I would like to know how to copy saved_formulas from one analysis to another using PyCelonis. I've tried to make a copy of an Analysis (using _backup_draft_content) but the saved_formulas are not been copy to the new Analysis. Thx

Can anyone help with the SAP tables required for Master Data Management process mining ?

Hi Guys, I'm creating my first analysis but can find any option to change the 'chart default colors'. Is there a way or do I need to add the HEX for every component manually?Also, is there a way I can adjust the background of a sheet? Still learning. Thanks! Emiel

Hi All For EMES is there a way getting reports / extract on users, groups, roles, routing rules, permissions & authorizations This is for regular user permissions / SoD checks Thanks in advance Michael Gordon

How to send pdf of analysis sheet to a list of people over email?

Hello,I am trying to simulate an O2C process but it is not lasting after this step. Any ideas ?  

After TM installation and data capture (including screenshots) I tried to visualize the Screenshots and follow all the steps for the configuration but screenshots arent apearing.,

How can i do the integration between ServiceNow Cases table with celonis? I just cannot see the option to integrate with ServiceNow in my personal instance. Thanks

Is it possible to create a multi line chart in Celonis Studio? Thanks