General Product Q&A

Hi everyone.  I'd like to know whether the "Public link" option is available to students with academic licenses. In one of the assignments for my master course I ask the students to share with me the link to the analysis(dashboard they have developed. Apparently, they are not being able to configure such public access. See below Thanks in advance!

Hello all,can you explain me why the first answer is false? I would say that it is false because when you use the MEDDPICC forumula you are just trying to confirm pain points and then you would need an executive alignment to end the phase of "qualify the opportunity" and so

Error while executing transformation Create Table: O2C_VBAP_STAGING, with id 9cad7fcb-8759-4fc6-81d0-67d45242ee78: ERROR: Relation "MAKT" does not exist

I have a quite complex query to calculate a KPI and want to limits its result to a maximum value.  This max value is stored in a variable with an absolute value of e.g. 2.If the actual result of the KPI is higher than 2 the PQL should return 2. I set this up as an CASE WHEN but this is repetitive code which is badfor readability and maintainabilty.  Are there more consise approached possible with PQL? e.g. using a Max(KPIcode, Limit) Excels Max function works something like this. But PQL Max works only on a column. just for reference my PQL looks something like this:CASE WHEN (... 5 lines of code to calculate KPI) > <%= Limit %> THEN <%= Limit %> ELSE (... 5 lines of code to calculate KPI) END    

Hi.Is there a way to calculate the average time taken to complete an activity or event. The time would be based on the timestamp of the event in question and the event that follows. This needs to be as a KPI so that is can be applied to large event data sets EgEvent A ----Event B ----Event C |_______Event DSo the average time for Event B would be the average of Event c and Event D subtracted from event B.The ask is to display it in an OLAP table as follows: Column1 Column 2Event Name Average time taken in mins

The column chart when spit by x axis resulting in displaying booth the KPIs but the space between both bars are inconsistent throughout and also in the 4th column is the second bar stays hidden.Can somebody help out with the solution for this?

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

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?

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 

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