For the complete documentation index, see llms.txt. This page is also available as Markdown.

If-Else Calculation

Step 1: Open Configuration

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.

Opening configuration panel in Dashboard

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

Opening the configuration panel in Viz extensions

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.

Last updated

Was this helpful?