Product Q&A

Help needed with a % connection path KPI I am trying to figure out how i can make a connection KPI which shows the path percentage of cases that passed through. now i want to see the path percentage flow from each individual Activity. exmaple: Start -->Activity A (branches pathways) ---55% for a path---> Activity B (branches Pathways) --23% for a path--> activity Z. so from each Acitivy i want to calculate how much of the (total) cases that landed there go a certain path % wise. Now i figured out by doing: COUNT (DISTINCT SOURCE ("Table"."colum")) / GLOBAL(COUNT (DISTINCT SOURCE ("Table"."colum"))) I can filter the path connections to % based on the Total amount of cases present in the dataset. This only shows me how cases % wise flow through the whole process. but not from an indivual activity.  In my mind somehow every Activity point needs to be seen as the "new" total 100% so a calculation can be made for the paths. but i

Hello guys, i would like to put a drop down in my reports with the opportunity for the users to switch between light and dark mode. How do I do that? Has someone practice in this topic? Maybe a pql code or something...

What functions can Celonis achieve

Hi, I would like to customise the colour and add icons to action buttons created with an action flow. For actions related to skills, this is possible, see screenshot attached.  There is a preview mode like with skills, but it doesn't allow you to customise. Using the syntax for skills action in YAML also doesn't work. Who knows how to do this? Thanks,Teun

i want change the dimension of olap table using dropdown in views, How to display name like display name in dropdown in views

hi all, now iI'm looking for text mining module if celonis has. Ｉknow pycelonis but it might take time to dev so please let me know if we have reusable one. just I'd like to do word occurence analysis. i don't need so complicated one.

Hi! can anyone please help me figure out the following PQL? I have cases that have a lot of the same activity.  Imagine the activity is "Walk The Dog" and there are activities with the following dates: 1/1/20231/8/20231/15/20231/25/2023 I would like a query that returns the largest number of days between consecutive events  So in this example: 1/1/2023->1/8/2023 = 7 days1/8/2023->1/15/2023 = 7 days1/15/2023-1/25/2023 = 10 days I would like the query to return '10'  I am having trouble with trying to connect the dots with the documentation on calc throughput. Not sure how to approach it. 

How can i apply component filter on table dimension in view, when dimension is changes using dropdown, and dimension data come from multiple table. like few dimension are coming from casetable, some from activitytable and some of them from other table

I have one Main button dropdown to select dimensions(dimension 1 and dimension 2). There are two other different button dropdowns (First and Secondary Category) to retrieve values from the main Dimension for benchmarking purpose. When I select dimension 1 as main dimension and even before selecting the First Category, the process explorer and the other Single KPIs displays empty. Is there any way to populate default values even before selecting the dimensions. Please see attached for more information.

Hi, in an action flow I try to make a connection with our UiPath RPA Orchestrator to start a job there. Because we use the on-premise version on UiPath I have to setup the connection like below. I filled in all details and I requested our IT team to whitelist all Celonis IP addresses on this webserver, but still it is not working.   Does anybody has experience with this connection or maybe has an idea what is going wrong?  Many thanks in advance!Albert-Jan

Detail:in our data model, the event time must with format YYYY-MM-DD HH:MI:SS. But my data source is DD-MM-YYYY HH:MI:SS. so this data is not available as event time. I tried to follow : https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/SQLReferenceManual/Functions/Formatting/TemplatePatternsForDateTimeFormatting.htm use query : TO_TIMESTAMP(Date_column, 'YYYY-MM-DD HH:MI:SS'); (attachment 5) but the date format is not correct as below: 0028-01-20 00:00:00 (Attachment 3) The original date is 28-01-2022 13:51:24 (as attachment 4) 

Hello all,  I keep getting a 403 error when trying to access my knowledge models via the Intelligence API. The App Key is marked as used within Celonis & authorization works.  I have set the required permissions for the App Key. I am trying to access an app that is currently hosted in our sandbox - is that the issue?  Any help would be highly appreaciated.  Best Johannes

Good day, can someone help me with a component filter if I want to filter on a case count for a certain time for yesterday, for example what is the total cases yesterday at 15:30. Thank you

We are trying to build profile views for KPI's. Can we use a KPI as a record so that we can create an attribute and create a profile view?Is it possible to use multiple KPI's in a single component in a profile view?

Is it feasible to create variables in Skills to archive the selections' hierarchy? or Does using augmented attributes make it possible to accomplish the same thing? Please help me with this. Appreciated and thank you

how can we write a Pql Statement to count the total cases which passing through the Activity

Good afternoon, among the best practices suggested by Celonis, there are: Scheduling Full Loads if delta loads are not possible or if source tables' metadata are changed frequently (i.e., a column is added or deleted).Extracting only the relevant columns of the source tables (i..e, those actually used in the transformations). If the relevant columns can't be deleted or changed in the source systems (because, for instance, they are crucial for the business and it would be a disaster to change them for the data recovery!), why should I schedule full extractions to consider metadata changes? Shouldn't I launch them only manually when columns need to be added to the extracted tables? Moreover, if the answer is in the documentation, could you share the link? Thanks and regards,Simone

Hi all,  I would like to execute a skill with two variables. Is it possible to set the value of one variable with a kpi from the knowledge model? Thanks and kind regards,Sarina

We would like to connect to SAP Succes Factor but we don't realy know anything about this system. Is there anyone who has some previous experience about this system? Is this an oracle or some kind of other Database? How to connect to it with Celonis?

I know that you can convert dashboards to PDF using Action Flow.Is there any other way to link the PDFs, such as storing them in a designated folder, without having to link them via email?Our company uses MS365, and since it cannot be linked with external applications, we are considering alternatives.Please give me some advice.Thank you.

A client is interested in process mining for PeopleSoft and Accounts Receivable. Is this feasible in Celonis? Any major barriers that I need to be aware of? Thanks for any guidance.

Hi, maybe someone can help me with my issue. I would like to calculate the standard working time for operation steps based on routing information.This is working so far. PQL is fine: SUM(("AFRU"."GMNGA")*"AFVV"."VGW03"/"PLPO"."BMSCH") Problem now is, that not all plants are using the same standard unit of measurement. ( Days, Hours or Minutes) By checking this unit and changing it to a standard unit (min.) I get following error message. SUM(("AFRU"."GMNGA")*"AFVV"."VGW03"/"PLPO"."BMSCH")/case when "AFVV"."VGE01" = 'MIN'Then 1ELSECase when "AFVV"."VGE01" = 'S'THEN 60ELSECASE WHEN "AFVV"."VGE01" = 'Day'THEN 1*60*60ELSE 0ENDENDEND  How can I solve this issue?

I am currently pursuing a master's degree in software engineering, following my MBA graduation, and I am in the process of selecting a topic for my master's thesis. I am very passionate about the field of software engineering and process management, and I would greatly appreciate your insights and recommendations for a compelling thesis subject in this area.My academic background in business administration and my current focus on software engineering make me particularly interested in topics that bridge these two domains. I am eager to explore subjects that could potentially improve software development processes, enhance project management, or optimize the overall efficiency of software development teams.If you have any suggestions or if you are aware of emerging trends or critical challenges in software engineering and process management, please feel free to share your thoughts. Your guidance and expertise would be invaluable in helping me narrow down my focus and embark on a

Hi Community, Can any one tell me about value realisation? does celonis offers any course on value realisation? If yes, what are the courses I need to undergo to understand value realisation ?