Product Q&A

For Ex Time spent on Deliver block activity. I am using below formulaDATEDIFF ( HH, PU_FIRST(VBAP, _CEL_O2C_ACTIVITIES.EVENTTIME, _CEL_O2C_ACTIVITIES.ACTIVITY_EN IN (Set Delivery Block, Set Default Delivery Block)),PU_FIRST(VBAP, _CEL_O2C_ACTIVITIES.EVENTTIME, _CEL_O2C_ACTIVITIES.ACTIVITY_EN IN (Remove Delivery Block)) )But this formula will consider weekend and holiday hours as well.Please let me know how to get the working hours only .I have tried below formula as well after looking at Using workdays_between without a dedicated calendar table Codes & Statements Hi guys, my problem ist actually quite simple. I want to calculate the number of workdays (monday till friday) between two given timestamps. The relevant function requires me to reference a specific calendar table from the data model. Within the data model options, however, the possiblity exists to define a custom calendar without implementing a dedicated table (simply by selecting relevant days and time windows). My

How different is Value Discovery apps that come as part of Starter kit from the Celonis Execution apps ? As value discovery comes in ems marketplace with no additional cost , Do we have separate licensing model for using Celonis Execution apps features ?

Hi all, I'm currently using the overlay functionality on the process explorer. We use this feature to open a profile view which shows the process explorer in a focus mode. As you can see in the screenshot if I filter the view and open the profile view via the process explorer the profile view is not filtered.   Is it possible to keep the filters from the view to the profile view via the process explorer? Thanks and kind regards,Sarina

Hi all, Using the updated PyCelonis version 2.0.0, I'm unable to push Pandas dataframes en parquet files towards the data pool. In the feedback, it states that it cannot be parsed towards a parquet file, but when I do this via Pandas (pandas.to_parquet()), this works without any problem. Are people facing similar problems?  Best regards,Jan-peter 

HI, I want to calculate average cost for manual tasks using zwo variables, one for average time needed for a manual task (AVG_TIME_PER_MAN_TASK) and one for average cost for manual task per Minute (AVG_COST_PER_MAN_MIN). In the activities table we added a flag "automated" 1/0, if the task ist automated (1) oder manual (0). Now I want to count all the manual task (= e.g. 500'000) and calculate them with the variables ( * AVG_COST_PER_MAN_MIN * AVG_TIME_PER_MAN_TASK.I've made a filter with all manual tasksThen I tried to calculate the whole effort in Minutes with this PQL but it didn't work.The Variable was defined as Textfield with Value and the component is a number field COUNT("_cel_eclaim_activities"."_activity_long") * TO_FLOAT(<%= LABR_DURATION_PER_MANUAL_TASK %>)

Percent stacked bar Hello, do you know if it is possible, with Studio, to have percent stacked bar graphs? Thanks

Hy,There is a requirement of sending dynamic graph of data through mailSo is there any way of sending graphs through action flow or skill or any other possible way ?

Hi all, is it possible to block another user from deleting my comment in the commenting component for views? And can I block the comment function as long as no specific order number has been selected? Thanks :)

Hello everyone, wanted to know if there's any way to merge a data model from one data pool with another data model that is located in a different data pool?

Hello Experts,Is this possible to implement section access control for EMS data models?e.g. we have a process data model and other assets linked to this dm.We want to restrict business users using case field let's say company code.So users belonging to specific company codes can access only respective codes data.This feature is available on on-prem but couldn't find similar on EMS.

Hi, I am trying to find out how to receive an email when my connector is down, I don't see it under Admin & Settings and Notifications. Can someone guide me on where it is? Thank you

Hi, I would like to know how to make the case explorer data exportable.

Hello,  I followed the course of process simulation step by step. created a package, then created knowledge model and selected a Data Model Variable, but I cannot see the "simulate" in the menu of this package. ​What happens? How to fix it?

I've currently got a view I'm building out for some data management and want to highlight/change the background color of cells which fit the criteria for "bad values", based on dates. This is currently where my YAML lies. I've tried searching through the Celonis Documentation and haven't found anything in regards to comparing dates. I've also tried searching for YAML documentation, but I haven't found anything which satisfies what I"m looking for.

Hi, Can Celonis extract source/data from JIRA project and Sharepoint list? Can the user upload the data and then store it in daily files in the folder? Can Celonis send out an email with snapshot of graph or status?

How can I combine a line chart with a column chart like in the Purchase-to-pay Demo?

Hi, I'm implementing an AF with some volumes. I query two columns:In the first column there is a date rounded by day, and the second column is the count. I noticed that the ROUND_DAY function applied to the first column is not working fine, since it keeps the timestamp, putting everything to 0 (2022-03-27T00:00:000Z). The problem is that at the 27 of march I have two dates that are the same, one with all 0 in timestamp, the other with 23 at the beginning. This is because at the 27 of march the time is changed by one hour, and it just mess everyting up the in AF. In the dashboard everything is working fine, since the ROUND_DAY function allow me to display only the date without timestamp (2022-03-27). How can I fix this in the AF?already tried:YEAR(date) || '-' || MONTH(date) || '-' || DAY(date), same as beforeformatDate function in AF: it says that the date is not a valid date. Thanks

Do you guys know if is there a problem in extracting the same table with replication cockpit in 2 diffrent data pools at the same time?

Hi there,I'm trying to build an histogram that shows the cycle times.Everything seems to work just fine, but when I compare the N. of occurences it doesn't match the number that I need. I read in the documentation that it uses the cases as occurences, insted I need a certain type of activity. If instead I build a column chart with the Cycle Times as dimension and occurences as KPI, numbers are correct, but I can't find a way to display the cycle times in a fancy way like the histogram, since in the column chart are displayed the single values for every instance, that I can round, but they are not the 10 ranges that I have with the histogram. I need or to customize the number of occurences in the histogram, so it can match, or customize the dimension axis of the column chart, in a way that is similar to the histogram. Thank you very much!

Hello, I wanted to understand the C4C APC storage consumption to view The understanding is that views generally don't consume any data in Celonis or consumption is dependent on the parent. I wanted to understand if the same holds for C4C environments as we are currently noticing that all views created in C4C consume data and some consume more storage than the parent as well. 

I am setting the specified YEAR into a runtime variable in a View. Knwow I also want to set this variable from an analysis.  The KPI in the analysis comes from the Knowledge Model and references the YEAR set in runtime variable.

Is there something like the case explorer in views?

Hey there! Does anyone know of a way to display a custom KPI by default in the Variant or Process Explorers? Thanks, Karm

Hello Team, I am not able to connect SQL Server in Action Flows.I am getting this error getaddrinfo ENOTFOUND I would appreciate if you can help me out.