Product Q&A

Hi all, I've been creating artificial datasets using AI that have been curated to get hands-on on real use cases. You can download them from here: https://mailchi.mp/c4920ff434e3/6ldtubr8yl

For the claims. there is history type='viewing', how can we get count of other history types that has occurred other than viewing before 5 min and after 5 minutes of viewing. There are different history typesThere is timestamp that captures what history type has occurred at what time, based on this I want to get the count of other history types that has occurred within 5 minutes of before and after the history type='viewing' has occurred. Kindly help with idea for the PQL query

Dear Experts , I have created a very simple workflow using skill (attached snapshot) , this just queries celonis data model and sends email to slack. As per message its getting stuck at Slack. I request your opinion here please ?  Sincerely - Shaif

Hello everyone, I needed to make an action record within the EMS.I'll put it in context... My business user will click on a "button" to send an email to managers to account for certain data. The problem is that we don't have a system record of that submission.Is it possible to record this action within celonis?I don't want to use excel to record this action.

Can Celonis mine information from social media platforms?

Dropdown list limited to 50 values? Hi, I have a dropdown list. If I paste a colum with 100 values it selects 50 and says it cant find the other 50.But if I paste the values seperatly if finds them all, is this intended?How can I set up a way in which a user can past a list of values and the view is filtered by that list? Best,João Paulo

Dear Experts, I have created a profile view where user sees records and we expect to click and update it. When we try to click it , multiple records are getting selected just like shown in snapshot. Can you please advise ?

Dear Experts ,  User requirement is to take input from user on profile view and store it some where . User input will be like "Yes" or "No". Is this possible ?

Hi,I would like to know if there is any possibility to give the PQL formula for KPI inside view. Please let me know for any hints. Thank you in advance :) Best Regards,Shravya B

Hi all,I would like to know wheather celonis data job task have following features or not. 1. Code history feature to compare old to new code.2. Export all SQL on data job task, if #1 doesn't exist I'd like to store my SQL on my local.​Thanks and regards :) 

Dear Experts, I would like to create an unsorted index on an OLAP table in the Analytics new sheet.​I'm use pql ​dimension INDEX_ORDER (COUNT (DISTINCT "table"."column"))"table"."caseid"​kpicount("table"."caseid")​now If I sort case count, ​Indexes and case IDs are turned into a set.​I want the index value to not change even if I sort by case count.​ex)​index | caseid | case count​1 | A | 32 | B | 23 | C | 1 ​sorting -> ​nowindex | caseid | case count (sort)​3 | C | 12 | B | 21 | A | 3 Goal index | caseid | case count (sort)​1 | C | 12 | B | 23 | A | 3-> This is my goal

How can I assign a variable on the dropdown component? I want the result of the dropdown component act like a variable input Thank you

For example to calculate the share of items for each region. If I have an OLAP with all regions, I need to have the total number of items divided by the items for the region, but I want to have the total number dynamic to not update the total number manually.So the same output over all rows. Does someone knows how to do it?

Dear All is it possible for action flow to trigger skill ? this is just a conceptual question i dont have use case in mind .

Drag and drop also does not work.

New update to Data Pool UI - finally you can filter / search by name, tag (label), data connection and created by!  

Hi, can we create actions flows out of a Bookmark created in the system. That is sents out to users an email with the content or link to our dashboards?

 Imagine an activity table like this: Case 1 - Activity A - 1PMCase 1 - Activity B - 2PMCase 1 - Activity C - 3PMCase 1 - Activity D - 4 PM I want to aggregate on another column. I am using OLAP Table and my KPI is: Name: count of cases when Activity C happens < 2 hours from Activity B Formula:SUM(CASE WHENHOURS_BETWEEN(PU_FIRST(Cases,Eventtime,Activity=Activity B),PU_FIRST(Cases,Eventtime,Activity=Activity C)) < 2THEN 1ELSE 0END) When I run this against a list of all cases, I get the right answer 1, but when I aggregate it, I'm getting 4. I thought this would only evaluate once per case... is that incorrect?  Thanks,Matt

(Senior) IT Consultant Celonis Data Engineer (m/w/x) (Senior) IT Consultant Celonis Projects (m/w/x) ALDI SÜD/ALDI SOUTHLocation: Mülheim a.d.R. (Germany) Description: As one of world's leading (discount) retailers, process excellence is inherently key to our DNA - which is why ALDI SOUTH is using Celonis to accelerate our process excellence journey and continuously realise value by using process mining and task mining and by providing our business with real-time execution apps and ActionFlow based automations. Become part of our growing Celonis team and join our Celonis Projects or Celonis DevOps team. Not sure which position to apply to? No problem, let's jointly figure it out! (Check out the full description following the links) Apply here (Data Engineer), orApply here (Projects)

Recently we have got some questions from our clients about the baseline graph in the process explorer in process analytics. The question is, in the variant explorer, the most common variant has 5 different activities, but in the process explorer, only 4 of these 5 activities show up in the baseline graph. If we click to add activities, two new activities are added but none of them is the one from the "happy path" (the most common variant).  We have checked the help documentation about the process explorer, such as "The Happy Paths show you the most frequent starting activity and the most frequent ending activity as well as all edges and other activities that are included in the variant connecting those two". But this doesn't really solve the question in our case.  Could anyone please explain what the principle is to create the baseline graph in process explorer?

Id like to solve the following scenario via Action Engine and Process Automation: A business user receives an action signal and likes to send a pre-configured Mail to another colleague. Now he likes to attach an invoice (pdf file) to this mail, means the attachment needs to be handed over to the automation skill and to be attached to the mail which is sent out automatically.

I would like to export an end to end representation of the Direct Follower Graph from the Process Explorer, e.g. as an image. My process consists of 60 activities, so I need to zoom in to have the full view. Therefore a screenshot doesn't work.

I want to know how to place my order about certification exam.​After fillied out the address information, credit card information, checked LMS provider Terms & Conditions, and clicked "place Your Order "​I got the ”Your card was delclined” message.I've tried defferent card blands these are all available in other servicies. I'm tring that from Japan. Is there any similar issues and solution?​

Sum(CASE WHEN "ActivityTable"."Activity" = 'something' THEN 1.0 ELSE NULL END) gives me the count when there is an entry "something" in the table.My challange is following: I need to count Distinct Case_ID, whenever "something" happens. It can happen more than 1 time for an Case_ID, so i need a PQL statement like:CASE WHEN "ActivityTable"."Activity" = 'something' THEN count (Distinct(Case_ID) ELSE NULL END, which is ofcourse not working like this. Ideas and solutions are welcome. Thanks a lot