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
  • Colors
  • Suppress column in sidebar
  • Suppress header name
  • Suppress Filter
  • Suppress Total
  • Show aggregated value when grouping
  • User can change aggregation method while grouping
  • Alignment
  • Header Tooltip
  • Filter Style
  • URL Action
  • Conditional Formating
  • Background Color
  1. Configuration Screen
  2. Data Tab
  3. Dimension Data Pane

Dimension Properties

PreviousColumn Background ColorNextMeasure Data Pane

Last updated 9 months ago

Colors

Set the colors for the background and header of a column, as well as the font color of the header.

Suppress column in sidebar

Sometimes you want to use columns in a calculation but not show them in the SuperTable. Choose this option if you wish to hide the column from the sidebar so users cannot enable this column.

Suppress header name

Ticking this will remove the column header from the SuperTable view.

Suppress Filter

Suppress the filter from a specific dimension. You see in our example it’s not possible to filter on Category but possible on Sub-Category.

Suppress Total

Suppress the column from showing total value. For instance you want to show the Sales total but not the quantity total in the total row of a grouped SuperTable, suppress the total from your quantity column.

Show aggregated value when grouping

When grouping a dimension show the aggregated value of the members in the group. Decide what the default aggregation should be which includes Count and now CountD!

User can change aggregation method while grouping

Alignment

Choose the alignment of the text within your SuperTables view, as well as the header of the specific column.

Header Tooltip

Change the tooltip of your selected dimension. By default, it will show the dimension name. This tooltip is for the column header only

Filter Style

Multiple Values (list) – A dropdown to be able to show or hide values. The dropdown will contain all the values of the dimension.

Wildcard Match – The column will show a search bar for this column to be used as an inline filter.

URL Action

Entering a URL will allow users to click any cell in this column to open a new tab in their web browser. You can refer to any other value from the same row of data by wrapping the field name with angle brackets. You can of course also use a dynamically calculated field that contains a dynamic URL based on the content of that specific row of data. With this, you can set URL parameters to open a dashboard that has already been filtered on specific column values in your selection.

Conditional Formating

With this option, you can set conditional formatting. There are three options for conditional formatting:

  1. Change the font color of the cell

  2. Change the background color of the cell

  3. Change the background color of the entire row

Background Color

Click on the circle to open the color palette and choose the color you wish to use. Please note that you cannot configure colors for a dimension with more than 50 members.

Check the tick box to use the chosen colors to color the background entire rows.

Suppress columns in sidebar
Suppress header