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
    • Glossary
    • Change log
Powered by GitBook
On this page
  1. Configuration Screen
  2. Data Tab

Calculations Pane

PreviousMeasure PropertiesNextCombined Columns

Last updated 10 days ago

SuperTables offers the possibility to create (SuperTable only) calculated fields. The extensions API transfers summary data only, so ratios and percentages are transferred as numbers instead of calculations. There is nothing wrong with that when you are presenting your data on a row level, but when you use the custom grouping options of SuperTables you will be presented aggregated values of the percentages and ratios that will not match the correct values.

To setup a calculation follow this guide: Setting up Calculations

Aggregated calculations

This is where the SuperTables Calculated Fields come in handy. With this simple Calculation editor you can easily perform simple mathematical calculations which use operands like Add, Subtract, Divide and Multiply. So for instance, if you have Profit and Sales columns in your dataset you can create a calculated field like

SUM(Profit)/SUM(Sales)

to calculate the Profit Ratio which will also aggregate properly when using custom groups.

Date calculations

There is also support for Date calculations. Make sure to write DATE() around the date dimension for SuperTables to recognize it as a date. For example:

DATE(Order Date) + ( SUM(Days of Shipping) * DAY() ) to calculate a delivery date for example.

If Else calculations

Calculations also have access to the same If-Else Formula Editor as the Formulas tab, allowing for further customization of your SuperTables measures.