SuperTables
WebsiteAll products
V4.0
V4.0
  • SuperTables
  • 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
    • Inline Filter
    • Advanced Filter
    • Grouping
    • Column Order
    • Hiding a column
    • Sorting Columns
    • 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
      • Column Groups Pane
    • Actions Tab
    • Appearance Tab
      • Multiple Layouts
      • Custom Views
      • Charting
      • Layout Options
      • Grouping Options
      • Pivoting options
      • Accessibility
    • Theme Tab
    • Restrictions Tab
    • Tooltip Tab
    • 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
      • Absolute Function
    • Conditionally coloring column(s)
    • How to make tool tips
    • Setting up Selective Aggregation
  • Accessibility FAQ
  • Support
  • Appendices
    • Glossary
    • Change log
Powered by GitBook
On this page
  1. Configuration Screen
  2. Data Tab

Calculations Pane

PreviousMeasure PropertiesNextColumn Groups Pane

Last updated 9 months 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.

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.

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

To setup a calculation follow this guide: Setting up Calculations