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 recomment to consult the PQL-Tutorial.

 

Overview

  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 are now able to 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. 

    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 display with its PQL statements.

  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.