Skip to main content

Celonis Product Documentation

Code Editor

  • The Code Editor lets you design and edit your dimensions/KPIs based on a graphical column selection and a PQL editor.

  • To work with the Code Editor, we recommend consulting the PQL documentation.

Code Editor
18579884.png
  1. Tables: In this section on the left, you can choose a table from your data source.

  2. Columns: After you have clicked on one entry of this table list, you can now see the suggested KPIs/dimensions that the Celonis engine identified from it. Below the suggestions, the columns of the tables are also available for selection to calculate KPIs/dimensions from them.

    Also useful

    If you select a column, a third area 'Choose Function' might appear (depending on the data type of your selected column). For example, if you would like to select Year of Credit Applications as a Dimension, you might choose the EventTime column from the Cases table. If you are choosing a KPI, a third column will appear after choosing a column. This is where we actually set our KPI.

  3. Editor: Here the formula for your KPI/dimension is displayed with its PQL statements. All possible PQL functions can be found in the PQL Function Library.

  4. PQL reference: Activate the toggle to add a dropdown that helps you add PQL statements.

  5. Preview: This section displays the preview of the KPIs/dimensions you have created

  6. Activity name: Click to edit the activity name.

  7. Formatting: Change the dimension formatting options.