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.
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.
Editor: here the formula for your KPI/dimension is display with its PQL statements.
PQL reference: activate the toggle to add a dropdown that helps you add PQL statements.
Preview: this section displays the preview of the KPIs/dimensions you have created