Product Q&A

Hi all, I'm trying to calculate throughput time between and "activity" and "today" timestamps by excluding Sunday. First, I tried it with using DATEDIFF function like that: DATEDIFF (HH, PU_LAST ("cases", "activities"."event_time" ), MINUTE_NOW()) But in this version, I cannot exclude Sunday as you can see.   Once I tried to do it with CALC_THROUGHPUT function as below: CALC_THROUGHPUT ( FIRST_OCCURRENCE [ 'Order placed' ] TO CASE_END , REMAP_TIMESTAMPS ( "activities"."event_time" , HOURS, WEEKDAY_CALENDAR ( MONDAY TUESDAY WEDNESDAY THURSDAY FRIDAY SATURDAY ) ) ) Now, I can only calculate the time until last event timestamps, not until now since I cannot use any DateTime_constant (TODAY, MINUTE_NOW, etc.) in this formula . Do you have any suggestions/solutions for such cases? Many thanks in advance for the answers :)

Hi! i want to integrate a dynamic pareto front to scatter plots in my analysis. I want to integrate the pareto front point as red points into the plot. The optimals could change depending on the actual filters of the dashboard. Do you know how to do this?

Your business user needs to investigate how the cases are flowing into undesired activities, in other words, see the predecessor activities. Which of these options would you choose to meet their needs?

Task mining data configuration failures I've recently started learning on the Celonis Academy courses and I'm stuck on the Task Mining sandbox.There is an error in the data configuration, it keeps failing:Uploading paquets from my machine seems to go fine:Yet it is impossible to analyse the recorded and uploaded task mining data, I'm guessing because the data configuration failed?It has been over two hours since my test tasks were recorded and uploaded. Does anyone know what is failing here and how to fix this?

I have read the documentation on the Run ML Notebook Component but I don't know how to publish the results of the notebook back to the Analysis UI. Is there any link to documentation that shows how to publish the results back on the Analysis? Do I need to use pycelonis or other python library?

Good evening,I have consulted the documentation on OnPremise Celonis Extractor Server (https://docs.celonis.com/en/on-premise-extractors.html), but as far as I can see there is guidance only for SAP and servers with JDBC.I would like to implement Celonis Extractor Server directly on a SQL Server without JDBC endpoints, is this possible?Where can I find a guide or documentation?Thanks

Now i want to have this number for Change Price as a single KPI number, my idea was to use the count table for the kpi and a Component filter with 'FILTER PROCESS EQUALS 'Change Price''. But it shows me a much larger number. Can pls anyone help me. Thanks in advance, king regards Louis

This means I want to calculate the throughput from A OR B OR C OR D to X. Is there any way of doing this?

Hello everyone, I have set up an Action Flow that informs our suppliers regularly and also requires an information import back to us from our supplier. The information flow to the supplier is possible via an Action Flow (Sending of a CSV attachment via Mail). My question is there a possibility for the supplier to send the answer back to Celonis (via a Webook, Web GUI) etc.? I know this is a predestined case for Emporix, however, as this is a very urgent topic, I'm wondering if there are any possibilities with the "normal" Action Flows? Thank you so much! Kind regardsJulia Bauer

we are facing some issue the error like below:Extraction failed. java.util.concurrent.ExecutionException: java.lang.NullPointerException.Please let what does the error mean and how to resolve it  

Saw a similar post from a few years ago but believe my question is slightly different. I want to write PQL that calculates the difference in days between the time stamps of when a "Next Status" was entered. The image is an example of what my raw data looks like and the column in yellow is what the PQL would help calculate. 

Hello Everyone,Can we apply a filter only for certain KPIs in a table component. Different filters for different KPIs.

 Hey guys,We are trying to export tables from SAP Ariba via API Supplier but we are receiving the return below message in Celonis extract Has anyone experienced this problem in this extraction?. Has anyone had this problem and could help me? Reached Supplier Data API limit waiting for 1 seconds. Current rate limits are;---X-RateLimit-Limit-day: "25000"X-RateLimit-Remaining-day: "24935"X-RateLimit-Limit-hour: "4500"X-RateLimit-Remaining-hour: "4435"X-RateLimit-Limit-minute: "150"X-RateLimit-Remaining-minute: "86"X-RateLimit-Limit-second: "3"X-RateLimit-Remaining-second: "0" 

Hello, the blue part is supposed to interact with filters that are applied to the entire view and change according to those filters. The green part is NOT supposed to interact with the filters and still stay with the same values.  Is it even possible to make the green part still with the same values and not interact with filters across the view? Note: The blue part is status 1. The green part is status 2. E.g. when I change the filter on April blue part changes values but the green part disappears because the values of the green part are only on the actual month. I'd like to blue part to show other months and the green part only the actual one even when I filter across the view.  

Hi, I need to determine the Cycle time of each activity that is not fully automated to determine the impact of not being fully automated. The Cycle time must be from the activity before the specific activity to the activity after the specific activity. How can I do that without specifically referencing the activity - hence 1 PQL that can apply to all non-fully automated activities.  

We would like to move to KM usage, but we have a lot of legacy analysis to be linked to KM. Ideally we would like to develop a code that could update reference from local KPI to KM kpi? E.g. from KPI("CT AVG") to KPI("CT_AVG").  I can identify approximate cases where update needs to happen, but I cannot really find if it is possible (and how) to do the update of KPI name in the component itself.

@Sophia Stephenson​ @Brian Dees​ 

Constantly users try to request access to our app portfolio via the Marketplace. (Maybe they didn't notice the "Apps" section and think specific access needs to be requested in "Marketplace" ...)    This will help new business users to focus on the important content and reduce the email notification (spam for admins) about new app requests from users.

Hi, can you tell my why my training version of Celonis have "Object and Events" and "Task Mining", but my production version does not have them?

want to read the file through machine learning, could you please help me

Can anyone please help me with PQL code to get Plant(WERKS) in MARC for the invoices (BELNR) in the table RBKP , but there is no common field between them so directly cant find so need to use RSEG which has common fields for both the table ,

Can anyone help me with the PQL query to find the Plant (WERKS) for each Invoice using BIND function as Plant is present in EKPO which doesnt have 1:n relationship with RBKP and RSEG is the only common table between EKPO and RBKP ?

Hello Community,I want to view the value of a KPI on monthly basis (Not in form of a chart). How can I partition the KPI value for different months in a year.

Hi all, I would like to show a celonis demo to Japanese member so I'm looking for it but it dissapperared. (I think there is some japanese demo in try celonis but not right now.) Does anybody know about this and let me know if you can find it.Regards, Tatsuya, Suzuki