If-Else Calculation

Step 1: Open Configuration

Dashboard extension

Viz extension

Click on the container that has SuperTables running. This will display an arrow that you can click to open a menu. Upon opening the menu, click the 'Configure...' option to open the configuration panel for SuperTables.

To open the configuration panel, simply click 'Format extension' in the Marks pane.

Step 2: Navigate to the Data tab

Step 3: Make a Calculation Column

On the left side of the data tab. There is pane that says calculations, expand that menu and click 'Make a calculation' to create one.

Step 4: Open If-Else Formulas Editor

To access the if Else Formula Editor, Click on the 'If-Else Formula Editor' button which can be found under 'Calculation'.

Step 5: Create your Calculation

In this case we will create a calculation that will display 0 if profit is lower than or equal to 0 but otherwise it will display the profit value.

Click save and Apply & Close.