Product Q&A

I have done to create tables and charts in view but how to add table border margin colors and in charts & graphs section how to add in different colors.

Hi, I am running through the Celonis Guided Learning tools and through the build Analysis, the "Configure a Date Picker" it always takes me back to the start and I can't go through the tutorial. I have already done the previous tutorials

Hi All,I have created and used variables in analysis before. But I don't know how to use variables in view and KM. I'm able to create variable but can't use it in formulas.Can anyone help me with this. Thank you in advance.

how to remove the graph control (#) in process explorer ?

Business Analyst - Schwerpunkt Customer Value Analytics (m/w/d) (Vollzeit, Teilzeit)E.ON Energie Deutschland GmbH Location: Essen (NRW), München (BY) (Hybrid)Description: Du unterstützt uns bei der Bewertung des Bestandskundenportfolios anhand verschiedener analytischer Use Cases mit den Schwerpunkten Lifecycle Analysen, Preisanpassung, Portfolio - Analytics und Kohortenanalyse. Dazu screenst du Daten und baust Datenmodelle zur Abbildung der Business Logik auf.(Check out the full description following the link) Apply here

Hi folks! I'm trying to create a load balance between my connections since some of them are failing frequently, is there any way where I can see the extractor related to a connection? I think I have some extractors with too many connections

Is there a way to share Business Miner insights with users who do not have access to Celonis (such as a download)?

Hi there, I am working with the Views App in Celonis Studio, and one of my graphs is a stacked barchart, with two KPIs. I am looking for a way to set the color for each KPI separately.  I already found a way to include diverging colors for both KPIs treated as one group, but that is not optimal because I cannot choose the color that I want since there are not so many options for that setting. So I would like to set the color for each KPI independently. The YAML Code looks like this id: chart-xxxxxxtype: chartsettings:  name: NAME  showLegend: true# colors: DIVERGING_RED_TO_GREEN (THIS IS THE LINE I WANT TO REPLACE)  encodings:    x:      field: RECORD.ATTRIBUTE      type: ordinal  visuals:    - mark:        type: bar        bandwidth: 0      encodings:        y:          stack:            - KPI1            - KPI2      legend: true      id: b9ddxxxx      order: 100  sortBy: []  limit: 1000  Thank you very much!Best regards,Javier

I am on a Udemy course that uses the Celonis EMS Free. I have subscribed, but when I login I am prompted for an MFA token. I get a Verification Token via Email that does not work. How do I get past this?

Hello Team, I need information on hire to retire work day connectors and what tables need to consider for extraction or uploading files. A brief on establishing connector tooo. If any one can share required tables and some links on connectors please let me know. Thanks in advance.......

I want to display only the sum of all (claim cap) for Parcel status that were said to be lost. I will like to use a 'Number KPI'. Please can someone explain to me how I can go about it?  

Hello everyone, I have a question about 2 PQL formulas.😅  In this case, I need a conditional that checks if it is the last record of the ID, if so, make a formula that takes the timestamp of this record and does the DAYS_BETWEEN between this date and today's date. If the timestamp of that record is not the last one, use the formula below:  AVG( DAYS_BETWEEN ("table_activities"."TIMESTAMPLE", LAG ("table_activities"."TIMESTAMPLE", ORDER BY ("table_activities".."TIMESTAMPLE" DESC) , PARTITION BY ("table_activities",."PROCESS_CELONIS", "table_activities"."ID") )))  I think it would be something like this: CASE WHEN PU_LAST ("tabela_atividades"."TIMESTAMPLE") = "tabela_atividades"."TIMESTAMPLE" --this for each id THEN  DAYS_BETWEEN (AVG( DAYS_BETWEEN ("table_activities"."TIMESTAMPLE", TODAY)  ELSE  AVG( DAYS_BETWEEN

I’m trying to configure an input checkbox component with a chart/kpiI’m not getting to configure it correctly. I’m unable to use sharefilters attribute in kpi list any help on configuring this component will be helpfulthank you

Hide Years and Months in Date Picker Dear All, I have a table which has date and records only for the Year 2022. I have used a date picker in the analysis. But while using the date picker , I do not want to see all the previous years/months prior to 2022. I understand that if I will not be able to select any date from any previous year/month other than 2022, but is there a way to not show the years and months prior to Jan-2022, while using the date picker. Thanks in Advance,JB

I’m trying to add display rules like e.g.,background colour blue and kpi value to be in white but I’m not finding a way to add this to a textbox component. It works with KPI list component and some other componentsAny suggestion to get this requirement done?

Is there a way to replace text in Action Flows?We need to remove newline characters from a string input. Currently this is being done in Studio Skills, but it would be better for our workflow if this was possible within an Action Flow. Wondering if anyone has done this. Regards,Ravi

Hi, Is there a limitation on the number of recipients possible under the "Routing rule" of Action Engine?

I am getting attached error while configuring profile view for the Inventory Management starter kit. Does any one have an idea how to pass Profile view key manually to the execution gap list component. (Profile view is available with same name in KM)   

Any best way to debug the out of the box Knowledge Model KPIs

Hi everyone,  as the title of the topic suggests, I'm searching for the possibility to connect Celonis and Marketing Cloud Salesforce. The official documentation doesn't say anything about, and there isn't a specific connector to make possible this operation. Does anyone have news of this implementation? It would be ok for me also building a custom API to retrieve data from the Marketing Cloud. Thanks in advance for the help,Regards,Emanuele

Is there a connector for IBM Maximo?

Hi All, Together with my colleagues we have started trainings in Celonis, however we are facing the issue, that the UI that we are seeing on training videos is different that the one that we see on training environment that we have established.Is there any option to change this view in training environment? Currently we are unable to follow training materials. 1) My training environment 2) Video environment: Thanks in advance for your support.

Hi, i am looking to build a histogram in a view with a KPI which gives a throughput time between 2 activities. I need the frequency of cases on Y axis, and a (automatic) grouping/bucketing of the KPI values on the x axis. I have tried to use the Histogram option in the View, but it seems not to accept KPI's (only data value columns). So i created a Record (attribute) in the activity table with the same formula as the KPI and use that as attribute in Histogram instead. But i get an Error: "Aggregate expressions cannot be nested inside aggregate expressions." Is there any other way of producing the desired result? I can use a normal chart but it will not do the buckting automatically and i don't know how or where to create an extra buckting table. Thanks in advanceHimanshu 

What is the difference between Signal and Object Links? Hi, i am investigating how to best create network graphs for a BOM and I came across the Signal Link and Object Link. I already have a basic BOM using Signal Link but as i want to use the LINK_PATH operator i now need to switch the BOM to Object Links. I'm having trouble in understanding the difference between the two and what are the pros/cons of one or the other.  Does anyone have experience using the Signals, and can expand on the differences? Thanks in advance for your insights.

I would like to identify the incidents for which the assignment group is changed more than two times. I am able to write this in SQL but need some help in converting this to PQLSELECT INCIDENT_NUMBER,COUNT(*)FROM "_CEL_INC_ACTIVITIES"WHERE ACTIVITY_EN = 'Change Assignment Group'GROUP BY   INCIDENT_NUMBER ORDER BY 2 DESCThanks in Advance