General Product Q&A

Hi there!I'm just begin with Celonis and i need to show the #tasks with the last timestamp. My data model have several Case_ID with "n" tasks associated with each case_id and each task have "n" events associated to each task. Each event have a timestamp and user.I want to show the number of tasks closed by each user, setting the criteria of closed task like the last date in timestamp of all events associated to that task. I'm not suer if i've explain clear....... Thanks a lot in advance!!!!

I would like to create a dynamic date filter in Data Extraction jobs so that every time my extractions will contain the last 24 months of data. For example, on March 15, 2024, I would like to have my start date set up as March 1, 2022, for the BUDAT field

Hey Guys, Do you know how to join two pql dataframes in Celonis MLWB? The objects are of class: 'pycelonis.pql.data_frame.DataFrame'. I tried to convert them to pandas dataframes using to_pandas() but my kernel dies and restarts.

Do we have any limitation in task mining in adding number of users and does the data impact APC limits?

Hi, I know the doc says that you can suggest the width but i can't change anything. I can't undertant why sometimes i get something like this And others something like this 

Celonisログインしたところ、画像の赤丸で囲まれたチームは表示されませんでした。何度かログインとログアウトを繰り返すうちに赤枠が表示されました。原因は何ですか?バグですか?

We are planning to work with one of our customers to show case Celonis dashboards that we have created.  We need to get a NDA signed between our customer and Celonis, after which we can use their data for Celonis Dashboards. Upon reaching out to our Partner Manager, he provided us with the process that firstly involved registering the opportunity in partner portal (https://www.celopeers.com/s/partner-register-opportunity) and provide the customer name and contact person. When we tried registering we are getting the attached error, can you guide us on how to register the customer in the portal ?

Hello everyone,I should create two KPIs: average times between two activities.1) the first one between activity A and activity B, in cases where activity C is not between these two activities2) the second between activity A and activity C, in cases where activity B is not between these two activities. So in a nutshell: the time between activity A and activity B, when the latter comes before C, and the time between activity A and activity C, when the latter comes before B.I leave a diagram to explain better.When there are only A and C without B, or only A and B without C it is very easy, but I cannot create when there are all 3. Can you help me? Thanks 

Hi, I need Celonis to record datas in an external database (and we already able loaded these tables into another database using Action Flow) but there is a component in Celonis called "Comments" which is similar to a chat . In attempts, we have not yet been able to copy the datas from this component into an external database... the datas from this component is not saved in any Celonis table? Not even a temporary one?

Hey, I am looking for a way to load the tables inside a DataJob in a specific order. Do you know any solutions?

Hello everyone, can anyone share experiences with the SAP Action Flow module? As of right now, this seems quite risky as while testing the AF direct changes in SAP are made (when only having a productive environment EMS). In our case, I want to change material master data if several conditions are met. Thanks so much! BRJulia Bauer

Hello together, is it possible to implement such a logic within action flows? I want to aggregate two query data modules but when explaining the AF-flow the wrong direction/flow is shown.Any ideas/experience on this? Thank you! BRJulia Bauer

Hey Celonauts, Can someone support me in how to set up the profile's for the content-cli. I can't really get the documentation to work. I'm using the Jupyter notebooks within the Machine Learning Workbench Environment. Documentation states "!content-cli profile create", and provides some input such as a name, url and API key. However I'm not sure how to input these values in a profile. My first assumption would be that it works similarly to other content CLI commands. Something like:!content-cli profile create --profile <profileName> --url <url_team> --api <api_key>.However this doesn't work. Kind Regards,Maurits 

... I mean, how can they compute this? First I was thinking 62% of those cases relatetd to that activity are on-time. But that would make sense with the rest of the analysis. I want to give a demo to a customer, but I'm concerned he asks that question and I have to admit Ito him that I dont know.

I have three tables named daily_data,monthly_data,yearly_data. I created three different dropdown for each one of them. If user select daily from Frequency dropdown which is in skill , I want user only able to see daily dropdown not other two dropdown.

sir can anyone please help i didn't get my reattempts so please help me

How to collect badge

I am unable to get a reattempt. Kindly help me getting reattempts to complete my certification.

Does anyone have experience in connecting to Ivalua? Wondering what accelerators and prebuilt connectors exist.

Hi everyone,  I'm trying to recreate code for uploading celonis user list by using Pycelonis 2.0+ version, and I've got few questions: A) Do you know how to properly update packages in Jupyter Notebook/ML workbench environment? I've always used just "!pip install --upgrade pycelonis", command "!pip show pycelonis | grep Version" show me newest version isntalled (2.6.0 as for today), however when using PyCelonis I still see message about old PyCelonis version:  Using command mentioned in the logs itself also don't change nothing (also with '!" added in front).  For Celonis guys: it would be good to add it to PyCelonis documentation and maybe changing message text for a working one :) B) When I'm trying to upload file in simplest scenario (no config) I see that data push job is created but cannot be executed successfully, unfortunetly googling error itself doesn't help much (seems to be some old JAVA error)  Data push logs: Error itsel

What are the prerequisites, benefits, pros and cons of using multi event log to integrate two processes

How can an order be matched with an invoice in SAP? In other instances, the amount on the order is not the same as the amount in the invoice.

HI Community, I have created some views on Celonis Studio and published. But these views are not visible on Apps. Do you know what could be the possible reasons for it?

For the following AP KPIs, is there anyone who knows the definition (formula) for each KPI. And in which Apps where can I find the KPIs.・Collection Effectiveness Index・Accounts Receivable Turnover Ratio・Average Days Delinquent・Days Sales Outstanding (DSO)