Product Q&A

Hello!  I am looking at the documentation for Column Charts in Views and cannot find any YAML code that shows me how to plot different KPIs side by side to each other (each in a different column) and not stacked onto each other. Does anybody know how the YAML code for it would look like? Just 2 different KPIs under the same dimension X value.  Thank you very much!  Javier

Hi, I need to calculate the time between two activities that are not directly followed by each other taking an event attribute into account. Example: Calculate time between A and B where: Both activities A and B happen more than once in the processTo get the correct throughput time, we need to consider an activity attribute (e.g., campaign_id). In our case, if activity A happens three times, it will have three distinct campaign ids, so we need to match those ids with the ones in activity B. How can I implement that in Celonis? I tried using SOURCE() and TARGET() from the example in this post , but it seems it only works for directly followed by activities, so there was no data for my chart, as A is never directly followed by B in this case. Thanks a lot in advance!

My customer installed the following Apps from Marketplace and check the KPI.・SAP S/4HANA - Accounts Receivable - Working CapitalShe would like to confirm the following PQL syntax for the KPI "Actual DSO" in the KPI.Here are the three points she would like to confirm.(1) What is the formula for KPI_AR_DSO calculated for?(2) What do {p1} and {p2} represent in the formula?(3) If I understand (1) and (2), I may know what Actual DSO is calculating.It would be helpful if you could also tell me what the Actual DSO is KPI to produce.―――――◆AppsSAP S/4HANA - Accounts Receivable - Working Capital◆KPI nameActual DSO◆KPI PQLKPI("KPI_AR_DSO", <%= VAR_US_CURR_TIMEFRAME_START %>, <%= VAR_US_CURR_TIMEFRAME_END %>)KPI_AR_DSO:SUM(  CASE    -- When the date is right    WHEN PU_FIRST("<%=VAR_GS_CASE_ITEM_TABLE%>", "_CEL_AR_ACTIVITIES"."EVENTTIME", "_CEL_AR_ACTIVITIES"."ACTIVITY_EN" = '<%=VAR_ACTNAME_ENTER_IN_SAP%

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?

To achieve real time data there are two possible ways. 1. Use the replication cockpit with a real-time extractor.2. Use scheduled delta extractions as data jobs. Option 1 obviously will be the recommended one. But what are downsides of option 2?From my understanding the bottleneck of this whole process is loading the data model.If that takes e.g., 10 minutes (which is a rather fast example), scheduled delta extractions, if scheduled more frequent or equal, should achieve the same thing like the replication cockpit.So why would I use a real time extractor instead of that when I can achieve the same result with option 2?

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

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 

I have registered and trying to upload a CSV, i am not able to see the data . The window is so small with no scroller, I am not sure if this is a browser compatibility issue or I have access issue on the free platform. How to resolve it ?

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?

Good morning, I'm working with Celonis EMS Studio (with packages, no with views), and I have two dropdowns like a filter. I would like when select one value of the first one, the another dropdown put only the posibles values to select in this columns (not appear in gray, behaviour similar to 'FILTER FORCED'). For example, I have countries and cities like dropdowns, when select Spain, would like have only the cities of Spain (and not cities of another country in gray like now). Thank you very much. Kind regards.

Hello, I am a temporary user but when I try to ingest the activity dataset into the data model, I get this issue: The export failed: Table contains more rows than the allowed maximum per table of 10000000 Please reduce the number of rows.

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

Hi  I want to execute ML notebook using run_ml_notebook component in analyses but ML notebooks are not visible Is there any additional configurations required to be done ? Thanks 

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.