Skip to main content

Ask the Community

Get answers to general questions and Academy-related topics from fellow users and experts.

1248 Topics
lukasz.luty
Level 3
lukasz.lutyLevel 3
asked in General Q&A
Do you have any experience with exporting Celonis app into another tools? I was hoping we could not only expose raw data but allow data discovery (inc. process explorer).

Do you have any experience with exporting Celonis app into another tools? I was hoping we could not only expose raw data but allow data discovery (inc. process explorer).

00
G
Level 8
sanati.dines
Level 3
sanati.dinesLevel 3
asked in General Q&A
In View section how to add colors to table , charts And graphs.?

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.

230
P
Level 4
P
Level 4
parvathi.choudLevel 4
asked in General Q&A
How to use variable in views and KM.

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.

540
kailash.potha12
Level 5
U
Level 3
uma.penmeLevel 3
asked in General Q&A
how to remove the graph control (#) in process explorer ?

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

10
U
Level 3
academic.allia11
Level 1
academic.allia11Level 1
posted in General Q&A
Business Analyst - Schwerpunkt Customer Value Analytics (m/w/d) (Vollzeit, Teilzeit)

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

10
academic.allia11
Level 1
andres.naran12
Level 4
andres.naran12Level 4
asked in General Q&A
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

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

10
G
Level 8
C
Level 3
chakradhar.pokalLevel 3
asked in General Q&A
Hire to retire work day tables and its columns

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.......

60
D
Level 3
P
Level 4
preethi.p12Level 4
asked in General Q&A
Input checkbox component in views

I’m trying to configure an input checkbox component with a chart/kpi I’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 helpful thank you

30
P
Level 4
P
Level 4
preethi.p12Level 4
asked in General Q&A
Add display rules to textbox component in views

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 components Any suggestion to get this requirement done?

110
B
Level 1
kailash.potha12
Level 5
kailash.potha12Level 5
asked in General Q&A
Any best way to debug the out of the box Knowledge Model KPIs

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

00
kailash.potha12
Level 5
E
Level 3
emanuele.cardeLevel 3
asked in General Q&A
Possibility to connect Celonis to Marketing Cloud Salesforce

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

30
L
Level 1
R
Level 1
radek.jLevel 1
asked in General Q&A
Training Environment vs training recordings UI differences

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.

00
L
Level 1
D
Level 4
douglas.henriLevel 4
asked in General Q&A
Date filter, bringing 1 extra day

Hello everyone, has anyone experienced this in Celonis? I'm doing a date filter, but in the frontend it's bringing me an extra day, but in the database it brings the period that I filtered. Below images showing. Thanks.

10
L
Level 1
V
Level 3
varun.kumar16Level 3
asked in General Q&A
How to add concatenated column in benchmarking dropdown and filter that column with KPI's and process explorer

How to add concatenated column in benchmarking dropdown and filter that column with KPI's and process explorer

110
V
Level 3
A
Level 1
artur.heinlLevel 1
asked in General Q&A
Can i change the font colour from a component in a analysis via pycelonis?

Can i change the font colour from a component in a analysis via pycelonis?

20
L
Level 2
mona.nagha
Level 2
mona.naghaLevel 2
asked in General Q&A
I am trying to create a custom KPI using Visual editor but somehow the visual editor is empty (can't access/see the visual editor option)?Any idea why this is happening?

I am trying to create a custom KPI using Visual editor but somehow the visual editor is empty (can't access/see the visual editor option)?Any idea why this is happening?

30
mona.nagha
Level 2
A
Level 1
abinaya.k30Level 1
asked in General Q&A
what is celonis?

what is celonis?

00
kailash.potha12
Level 5
S
Level 1
suchitra.bathu13Level 1
asked in General Q&A
uploaded parquet file the timestamp is different how to convert into readable way in transformation using sql

uploaded parquet file the timestamp is different how to convert into readable way in transformation using sql

20
kailash.potha12
Level 5
C
Level 3
claudio.tatiy12Level 3
asked in General Q&A
Problem using Conformance Overview and Allowlist

60
C
Level 3
G
Level 8
guillermo.gost12Level 8
asked in General Q&A
How to calculate the weekly average of the daily unique values?

I want to calculate the week average daily number of employees doing one action. For that I need to calculate the number of different usersID's (thus a count_distinct) each day And then calculate the average of of those values in the same week. That will tell me, during that week, what's the average daily employee attendance to that action. How to do it? It should be fairly standard by I can't get it! I have a case table with timestamp of the action, and the user that did the action. And I want a OLAP with Week number - average of daily users I have used this struct: AVG( PU_COUNT_DISTINCT(DOMAIN_TABLE(ROUND_DAY(CASE.TIMESTAMP)),CASE.USER) ) but the results are incorrect Can anybody tell me what I am doing wrong? TIA

30
G
Level 8
K
Level 2
karol.trzci11Level 2
asked in General Q&A
Changing SAP USNAM column from pseudonymized to non pseudonymized. Have anyone tried the approach mentioned below?

Hi, During initial implementation there was a decision to pseudonymize column USNAM in multiple tables. Currently it was agreed that we need to have actual (not pseudonymized) users data in Celonis just like it is in SAP. Usually unticking the Pseudonymize box in extraction setup would do the trick and I will do it for some smaller tables for which we have full loads. However we have couple tables for which we are doing only delta loads, as they are way to big for full loads (over 40 GB). Doing full load for them would take ages and I'm not entirely sure how Celonis would manage with such a huge load done at once. The idea is to create one time mapping by downloading second iteration of that big table (BKPF is original one, the second one lets call it BKPF_RAW), that would only contain the 4 key columns and USNAM that is not pseudonymized. Next step would be to add new column (lets call it USNAM_RAW) to original BKPF, then update it with data from BKPF_RAW.USNAM by matching the two tab

60
G
Level 8
S
Level 3
sachin.topul13Level 3
posted in General Q&A
What can be reasons for Open Invoices.

What can be reasons for Open Invoices. Any Available views for Open Invoices in Accountz Payable.

00
S
Level 3
K
Level 3
kinsley.leLevel 3
asked in General Q&A
CALC_THROUGHPUT for two activity columns in the same table

Hi, I would like to to apply this function to mesure the cycle time of Change Activities. The activities table looks like this: Case ID 2 columns "Change From" and "Change To" along with timestamp column Time starts counting for each case when Change To = A for the first time and ends when Change from = A for the last time. The logic Im trying to work around is (just disregard the function syntax- Im just trying to explain the logic. CALC_THROUGHPUT( First_Occurance ('Change to' = 'A') to Last_Occurance ('Change from' =' A '), Remap_Timestamps("Table"."event time", days) What is the right way to implement this logic? Should I filter the table to be "Change to" = 'A' or "Change from" = A and then merge this two columns to form a single column to use calc_throughput? But then how to merge different columns in the same table? Thank you for any suggestion!

100
K
Level 3
A
Level 3
aldona.potocLevel 3
asked in General Q&A
Select cases with activity event time within a time range chosen from date picker

I have am OLAP table containing cases with event time of activity X and Y and a date picker based on the activity X. When I select a time range from my date picker (i.e. 01-01-2023 to 10-01-2023 or 01-02-2023 to 28-02-2023) I would like to see only these cases for which event time of Y is within the chosen selection with result 'in scope' and 'out of scope'. I don't want to have a second date picker and have to choose the same date range manually.

90
R
Celonaut
academic.allia11
Level 1
academic.allia11Level 1
posted in General Q&A
Business Analyst - Customer Value Analytics (m/w/d)

Business Analyst - Customer Value Analytics (m/w/d) E.ON Energie Deutschland GmbH Loction : Essen (NRW), München (BY) 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 Du erstellst Analysen und Reportings in PowerBI und Process Mining (Celonis) und entwickelst diese weiter Optional erstellst du auch Analysen und analytische Modelle u.a. mit Python Du visualisierst Daten aussagekräftig und kannst Wirkzusammenhänge erkennen und erklären Du erstellst managementtaugliche Präsentationsunterlagen im notwendigen Abstraktionsgrad, um die komplexen Zusammenhänge im Bestandskundenportfolio zu transportieren Du unterstützt im Rahmen der Projekt-/Squad-Arbeit Zur Bewerbung: https://jobs.eon.com/de/job/Business-Analyst-Schwerpunkt-Customer-Value-A

30
academic.allia11
Level 1

Most helpful members this week

Badge winners

  • Qualified to Build Views
    rhoda.mohlohas earned the badge Qualified to Build Views
  • Qualified to Deliver Business Value with Celonis
    emma.davenhas earned the badge Qualified to Deliver Business Value with Celonis
  • Qualified to Build Analyses
    siva.bahadhas earned the badge Qualified to Build Analyses
  • Qualified to Get Data Into Celonis
    Tobias Fehrerhas earned the badge Qualified to Get Data Into Celonis
  • Qualified to Build Views
    siva.bahadhas earned the badge Qualified to Build Views
Show all badges

Popular tags

Terms & Conditions

ANY QUESTION?

Talk to an expert
FAQs
Contact us

MORE CELONIS

Academy arrow_outward
Documentation arrow_outward
Support Center arrow_outward
Partner Portal arrow_outward
Marketplace arrow_outward

CHECK US IN

LinkedIn
YouTube
Instagram
Facebook
Imprint
Disclaimer
Privacy Notice
Cookie Notice
Terms and Conditions
Celonis © 2025