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. Appearance Tab

Grouping Options

PreviousLayout OptionsNextPivoting options

Last updated 9 months ago

Enable Group bar

Show or hide the grouping bar in SuperTables. This enables or disables your dashboard users to do custom groupings on the dataset you offer in your SuperTable instance.

Enable group totals within each group level

Each level will show a total of the group. Below, an example of the group total for “Office Supplies”:

Enable a ‘grand’ total across all groups

Show a grand total of all groups in your SuperTable view.

View grand total at the top of the table

Show the grand total (pinned) at the top of your SuperTable view.

When Group is expanded, hide the parent row

SuperTables allows you to hide the parent row while drilling down in your table. Below, an example with the parent row enabled:

Also an example with this option set to hide the parent row:

Enable sticky row groups

This option will make the group rows stick to the top of the table when scrolling down, meaning that the parent row of a group will remain visible while scrolling through the underlaying rows.

Hide the number of rows counter behind a group row

Normally, SuperTables shows the number of rows contained in a group or aggregation. With this switch you can turn off this row counter. By default, SuperTables shows a row counter when grouping:

You can switch this off and then the SuperTable groupings look like this:

Use multiple columns for grouping

When you use the grouping bar, SuperTables uses one column for the group by default. With this option, you can force SuperTables to use a dedicated column for each member of the grouping hierarchy. Example: Below you see a custom group of “Category” and “Sub category” where there is also a separate column for “Sub category”:

Default SuperTables combines the grouped dimensions into one column called “Group”:

Show opened group names on the rows below

This is useful when the user scrolls down through the children of the group, and the row showing what group was opened is scrolled out of view.

Show aggregation function in header

When using Measures in your SuperTable, the aggregation of the column can be shown in the SuperTable column header using this switch:

Automatically expand grouped rows

If your SuperTables has multiple groups, you can set it to open on a specified level by default. If you have, for instance, 3 group levels, you can choose to expand it by default on the first level by setting this value to 2.

Group value empty or null

Replace the empty group or null with a message of your choice, leave empty for default.

Enable URL actions for grouped values

If you are using dynamic values in the URL it will use the first row found in the grouped data to generate the URL. Deselecting will deactivate the URL action on the grouped level.

Unbalanced Groups

If there are rows containing null or undefined values for the column that is being grouped then these rows will not be grouped. This is called unbalanced grouping. If the null values should be in a column that’s current in your dataset you can set a replacement column using the dropdown. Wherever there are nulls or undefigned values, this column will be used for all.

Event listeners

Here, you can choose on what events the SuperTable should be updated from the dashboard

Update when any Tableau filter or Dashboard action changed the datasheet

Your SuperTable will be updated (reloaded) when any filter or dashboard action changed the datasheet.

When using secondary datasources to blend on your datasheet, they will by default not trigger filter updates. You can select these worksheets here.

Use the dropdown to choose the secondary datasource. This worksheet will need to be present on your dashboard.

Update on a mark selection in the datasheet

Your SuperTable will be updated on a mark selection in the datasheet that feeds the extension.

Update when the value of a parameter changes

Your SuperTable will be updated when the value of a parameter changes.

Exclude the following parameters from the event listener

In some use cases you might want your SuperTables extension to respond to parameter changes, but not to all parameter. For instance, when you have two SuperTables instances on the same dashboard that have their settings stored in a parameter, you might want your SuperTable to exclude to respond on that settings parameter changes.