The Formula Editor creates Dimensions & KPIs to be used in a component.
The Formula Editor is opened via the component settings screen.
The Formula Editor can edit Dimensions and KPIs. The overview screen can be used to select dimensions or KPIs according to table columns and pre-defined dimensions/KPIs. The Celonis engine automatically analyses the data in your tables and suggests relevant dimensions and KPIs for you to choose 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.
KPIs: here you can view the KPIs (or, analogously, the dimensions) you have currently assigned to this component or add new ones. Read items 6 to 10 to know more about this tab.
Switch view: switch the view between dimensions and KPIs.
Preview: this section displays the preview of the KPIs/dimensions you have created