Date Calculation

Date calculations are added in SuperTables 5.4.0. They allow you to do powerful calculations based on date fields and number fields. You can calculate with either dates and/or numbers combined.

Examples:

DATE(Order Date) - DATE(Delivery Date)

Or when using a number:

DATE(Order Date) + (SUM(Nr of Shipping Days) * DAY())

Numbers are by default in seconds. Therefore we added multiple helpers:

Step 1: Open Configuration

Dashboard 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.

Opening configuration panel in Dashboard

Viz extension

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: Navigate to the Calculation Box

Navigate to the box that contains Calculation and set the Column Display type to 'Date'

Step 5: Write a calculation like this

You can also use InputTables columns to calculate with date fields. For a dynamic updating dates.