SuperTables
WebsiteAll products
V5.0
V5.0
  • SuperTables
  • InputTables
  • Getting Started
    • Installation
    • Quick Start Guide
      • Setting Up SuperTables In a Dashboard
      • Setting up SuperTables as a Viz extension
    • UI Explained
      • UI Overview
      • Pivot
      • Formulas
      • Row Groupings
      • Status Bar
  • Features
    • Custom Views
    • Inline Filter
    • Advanced Filter
    • Grouping
    • Column Order
    • Hiding a column
    • Sorting Columns
    • Charting
    • Column Pane
    • Filter Pane
    • Row Groups
    • Autosize Columns
    • Context Menu
      • Cell Features
      • Copy With Headers
      • Clear All Filters
      • Export to PDF
      • Export to Excel & CSV
    • Pivot Your Table
    • Dynamic Aggregation
    • Formulas
  • Configuration Screen
    • General Tab
    • Data Tab
      • Create Alias
      • Data Fetch Method
      • Dimension Data Pane
        • Dimension Format
        • Column Background Color
        • Dimension Properties
      • Measure Data Pane
        • Measure Format
        • Measure Properties
      • Calculations Pane
      • Combined Columns
      • Column Groups Pane
    • Actions Tab
    • Appearance Tab
      • Multiple Layouts
      • Charting
      • Layout Options
      • Grouping Options
      • Pivoting options
      • Accessibility
    • Theme Tab
    • Restrictions Tab
    • Tooltip Tab
    • InputTables
    • Export Tab
    • About Tab
  • Enterprise Only Functionality
    • Custom Themes (Enterprise Only)
    • Custom Events (Enterprise Only)
    • Localization (Enterprise Only)
    • Export Pictures In Excel (Enterprise Only)
  • Guides
    • Setting up Calculations
      • Setting up a Simple Calculation
      • If-Else Calculation
      • Date Calculation
      • Absolute Function
    • Conditionally coloring column(s)
    • How to make tool tips
    • Selective Aggregation
  • Accessibility FAQ
  • Support
  • Appendices
    • Change log
Powered by GitBook
On this page
  1. Guides
  2. Setting up Calculations

Date Calculation

PreviousIf-Else CalculationNextAbsolute Function

Last updated 19 days ago

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

This can be done by clicking your the container that has super tables on your dashboard.

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 calculation. Click make a calculation on there.

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.