The main use case for SuperTables is to offer more flexibility to your dashboard users in handling tables in Tableau. Using a table in your dashboard comes in handy if you want to provide your dashboard users with extra context on their visualization or let them make their own groupings, filtering and cross sections. SuperTables provides your dashboard users with a table that supports inline filtering, pivoting, grouping and many more features of which they can create their own personalized views on Tableau Server / Tableau Online. Drag the extension to the dashboard, configure the data(sheet) to feed the table and you’re ready to offer your Dashboard users Excel like functions without leaving your Tableau Dashboards! You’ve never seen a more powerful table! Stay in the Flow! 

SuperTables Features

This section describes the flexible ‘Excel like’ features SuperTables has to offer for your Dashboard users. 

Enter text into the search box underneath the column header you wish to filter. This will instantly filter inline and can be done on multiple columns simultaneously and offer your dashboard users the most flexible way of filtering their rows based on column values.  

To enable Inline Filtering, open the configure screen within the extension. Under the Data tab click on the dimension(s) you wish to have an inline filter. Halfway down you will see ‘filter style’, click on ‘Wildcard Match’ to have the inline filter activated on your table. Alternatively, within the configure screen under the Appearance tab under the Layout Options header, you can tick the ‘Enable quick filters’ which will give every column an inline filter. 

inline filter

Dragging and dropping headers into the grouping bar will allow the users to drill down on their data. To enable this feature, go to the configuration screen under the Appearance tab, under the Layout Options header you can tick the ‘Enable group bar’. Also, within the Appearance tab under Behaviour options, you will see ‘Use multiple columns for grouping’ this will group all the columns you wish to drill down in a group within the view.  

Grouping

Click, drag and drop any header along the columns to change the order.

Column order

Click, drag and drop any column header outside the container to remove that column from the view. The column can be made visible again via the columns option in the sidebar of SuperTables.

SuperTables - how to hide a column in your SuperTables view

Click on a header to sort the rows in an ascending order. Click again for a descending order, a further click will bring you back to the original sorting order. You can also select a secondary sorting column, just hold the Shift key while clicking the second column header. For example, your first sorting is on “Product Category” and the second sorting is on “Customer Segment”. When using multiple columns for sorting, you will see a small integer appear in the column header to indicate the first, second, third etc. columns you sorted the data on.

Sorting columns in SuperTables. Use one column to sort or multiple columns to sort on.

On the right of the table (or left if you enabled RTL in Appearance) you see a side pane we call the Sidebar. By default you will see a “Column tab as well as a “Filter” tab. In the column tab you can check and uncheck tick boxes to show/hide columns you would like to see in your SuperTable

Sidebar Column Pane in SuperTables

In the Sidebar on the right side of your SuperTable you also see a “Column” tab. When you open this tab, you can click on any column header and filter though the filter pane.  Use the dropdown to choose which filter you wish to use and use the text box that will show up to dynamically filter your chosen column. You are able to do multiple filters at once. 

Sidebar Filter pane in SuperTables

An amazing feature of SuperTables is that it allows your dashboard users to create their own grouping hierarchy. This can be done without the need of a Tableau fixed Hiearchy and in any order your dashboard user would like. To use this feature just drag a column to the grouping bar and drop it in the grouping bar. The rows will now be aggregated based on the grouping which you can select yourself. You can use multiple levels of grouping to create your own hierarchies just by adding columns to the grouping bar.

Row groups in SuperTables

Just like in Excel, you can double click on the separator between column headers. This will automatically auto size the width of the column. You can also click on the hamburger menu alongside the column header, where you can auto size the selected column or all auto size all columnsjust with one click!

Autosize in SuperTables
 

With the context menu of SuperTable you can quickly select some basic functions. Just right click on your SuperTable!

Right clicking on a cell and choosing  Keep Only’ will filter and inline the column with just the chosen cell content. This can only be done on one value per column.

Keep only

Right clicking on a cell and choosing  ‘Exclude’ will exclude that and all others within your column with the same content. This can only be done on one value per column.  

Exclude in SuperTables

When sharing data, you may wish to hide certain information. This can be done by right clicking on any cell (or range of cells) and click on ‘Anonymize’. This will show ‘NN’ instead of its data. Reload the extension to clear the anonymization. 

Anonymise in SuperTables

Right click on a cell anywhere in your SuperTable. Under the Export tab you can export all the data to a CSV file, .xlsx or.xml. This will export all the data you are showing in your current SuperTable view. The details of the export can be configured in the “Export” tab of the configuration pane.

Export in SuperTables

If you wish to export some, but not all rows or cells of your data, you can copy them from your SuperTable into your clipboard for later use in a report or excel environment. Highlight or select the rows or cells which you wish to copy by ticking the checkbox on the far left of your Supertable. Then, right click anywhere (in your selection) and click ‘Copy with headers’. This will save the information to your clipboard for you to paste outside of Tableau in for example your email, a Word report or Excel workbook 

Copy with headers in SuperTables

Empower your advanced dashboard users! Let them make columns out of values by pivoting on the data right in your tablesimilar to Pivot Tables in Excel. Open the Sidebar of your SuperTables and enable Pivot mode in the “Columns” tab. You can now configure row headers and columns based on groups or dimension values you like. 

You can, for example, replace the the column header “Category” with its values (for example “Office Supplies, Furniture and Technology” and have the rows show the “Regions” and “Ship Mode” like the example below. 

Pivot in SuperTables
Pivot Mode in SuperTables

Data Pane – Dimension

This section describes the configuration of your Dimensions, Measures and Calculated fields in SuperTables.

All columns can be aliased. By default, the name of the column will be presented in the column headers of SuperTables. Using the first option that says “Configure” on the Data pane of Configuration allows you to create an alias that will be shown in your column headers.

Alias in Supertables

This image shows how to alias the “City” field in my dataset with the word “Town” in my SuperTables presentation.

Dimension format

Here, you can choose if you want the column to be shown as text or if it is an url that can be rendered into an image.

Image

Add the width and height in px in to the text boxes to set the proportions of the image.

Enable ‘auto row height based on cell content’ under the Appearance tab to enable larger images in the grid and have the row height automatically be calculated. We suggest setting at least one of the dimensions of the images size for better layout control. Leave width and/or height empty for auto detection and showing the full image (max sizes).

Date format

If your dimension is a date type, you can format the date in the view.
For example: “YYYY-MM” to 2021-05 for May 2021.

Properties

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
Check this to remove the ability to inline filter your column

Alignment
Choose the alignment of the text within your SuperTable view.

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!

Column Grouping
Add an extra header and add all dimensions, measures and calculated fields of your choice to this extra header group. Create a unique group within your SuperTable. You can indicate if a column must only be visible when the column group is expanded or also when the column group is not expanded. This way, you can create a group with extra detail but not show all detail on the initial opening of the dashboard.

Using a column group with extra columns that hide on collapsed groups:

SuperTables column group

Or view all the details by clicking the expand option on the column groups:

SuperTables view all details

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 dynamic 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 Formatting 

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.  

Measures

In this section, the configuration options you can set with Measures are described.

Number Format

For measures you can select one of the following number formats:

  • Decimal
  • Currency
  • Percantage
  • Time

Decimal

With decimal numbers you can set a prefix and/or a suffix to be used in the presentation in the cells of your SuperTables. The numbers will remain in tact so it’s only to add extra information to the cells in SuperTables. You can also configure how negative values should be represented in your SuperTables and you can choose to enable or disable thousands separator in the display of the numbers in your cells. For instance, if your cell contains a numeric year (like 2021)  it can be shown as 2,021 if you allow thousands separators or 2021 if you disable the thousands separator.

Currency

The currency number formatting allows the same options as the number format, plus the option to top the currency shown in your SuperTable.

With currency you can use a 3 letter suffix to change the currency. Default currency is USD, but you can also use for example GBP or EUR.

Percentage

This number formatting behaves the same as the decimal format. Your cell value will be multiplied by 100 and besides that, it adds the percentage sign to your cell formatting in SuperTables.

Time (ms)

When you choose this option, you can indicate what hierarchy of time must be used for your cell representation. To use this option your values must be in milliseconds (ms) and they will be automatically presented in the entire or part of the range you selected:

  • Seconds
  • Minutes
  • Hours
  • Days

Calculations

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, Subsctract, 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.

General configuration of Measures

Suppress column in sidebar
Choose this option if you wish to hide the column from the sidebar. This comes in handy when you have columns in your data that you need for SuperTables calculations but don’t want to show in your SuperTable. Using this option never allows your dashboard users to add the column to SuperTables using the Sidebar.

Suppress header name
Ticking this will remove the header from the SuperTable view. For example, when using images, this might come in handy.

Suppress Filter
Check this to remove/disable the ability to inline filter this column.

Show aggregated value when grouping
Turn off aggregated values (SUM, AVG, MAX etc.) if you do not wish to see it in your view.

User can change aggregation method while grouping
Using the hamburger menu alongside a column allows you to change the columns aggregation (change from SUM to AVG for instance).

Truncate values above and/or below
Truncate the measure to show a range by deciding on a minimum and maximum value.

Default aggregation when grouping

Use the dropdown to choose which aggregation will be used on your measure when grouping / aggregating your data in SuperTables.

Alignment
Choose the alignment of the text within your SuperTable view.

Header tooltip
Change the tooltip of the header of your selected measure. By default, it will show the measure name.

Column Grouping
Add an extra header and add all dimensions, measures and calculated fields of your choice to this extra header group. Create a unique group within your SuperTable. You can indicate if a column must only be visible when the column group is expanded or also when the column group is not expanded. This way, you can create a group with extra detail but not show all detail on initial opening of the dashboard.

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 refer to any other value from the same row of data by wrapping the field name with angle brackets. For example, you can use a dynamic calculated field that contains a dynamic URL based on the content of that specific row of data. With this, you can set URL parameters for instance to open a dashboard that has already been filtered on specific column values in your selection.

Conditional Formatting

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 or Text Color

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

Use a gradient from upper to lower bound.

Instead of having set colors for below bound, in bound and above bound, it will gradient from below to above. Use the lower & upper bound to decide on the scope.

Show background as a bar chart

Change your cell in to a bar chart, setting the minimum and maximum bounds.

Use colour as background of entire row

Fill entire rows in your SuperTable by using the conditionally formatted colors of your upper and lower bounds.

Dashboard Actions

Interaction between visualizations and sheets in your dashboard is an important aspect of Tableau. SuperTables supports a high degree of interactivity by using a “Dashboard actions” like mechanism.

Actions in SuperTables are based on row selection. You can either select one or multiple rows which will trigger your Dashboard Action.

To start configuring the Dashboard Actions by SuperTables, click the “Actions” tab in the configure screen. In this screen you can either edit an existing action (by default, no actions are present) or create a new action.

To create a new action click the green “Add action” button. You will be presented a modal popup where you can configure your action.

Select action type

SuperTables supports three types of action:

  1. Filter action: This allows you to use one column value of the selected row to filter upon another sheet of your dashboard.
  2. Parameter action: This will allow you to fill a parameter with the value of a column of one (or more) selected rows.
  3. Highlight Action: This action allows you to highlight the value of a column of your selected row(s) in another sheet of your dashboard.

Select a column

Choose which column will be used to execute the action. This is not the column that will trigger the execution of the action but this is the value that will be used as a filter, parameter value or highlight value in this specific action.

Select a worksheet

Choose the target worksheet you wish your action to trigger, SuperTables actions can be applied to one single target sheet only.

Clearing the selection will

Select how you want your action to behave when the (row) selection is undone. You can choose to leave the filter, show all values again or exclude all values.

Data format

If you use a date field as a column value to be used in your action, you can set what format you want to use as a filter value.

Appearance

Store table layout in

All changes you make to the SuperTables layout can either be stored in the workbook settings (no personal views possible) or in a special dedicated parameter for storing the SaveState of your SuperTable. When using a Parameter to store the Layout Settings you enable your dashboard users to create personal/private views on your published dashboards (Tableau Server / Tableau Online).

Please make sure you use a dedicated parameter per SuperTables instance in your workbook, since parameters are global within a workbook. Using the same parameter twice in one workbook might lead to unexpected results!

The parameter to store your SuperTables setings can be created by:

  • Creating a new parameter
  • Using a logical name like “PM Savestate Salesdashboard”
  • Setting the “Data type” to: String
  • Empty the “Current value”
  • Setting the option “All” for the “Allowable values
Store table layout in
  • Save/Store your parameter
  • Head to the Appearance tab of your SuperTables configuration pane and select the new parameter form the dropdown
Configure appearance SuperTables

Themes

Choose a theme that suits your dashboard best! A Tableau look-a-like theme is the default selected theme.

Charting

Create a pop up chart of your selection. Within your SuperTable, select some dimensions and measures, right click and choose ‘Chart Range’. Here, you will be presented with a selection of charts. Click on your desired choice and you will be presented with a pop up chart within your dashboard. This is read only and will not be stored in your SuperTables configuration and settings. It is desgined to help your Dashboard users with some extra self-service analytics on the SuperTables data.

Layout options

Enable auto row height based on the contents of the cells
Each cells height will change automatically based on the contents of the cell to show all content in the view. The row height will be calculated on the cell containing the most content (either image, text or numbers).

Enable checkbox to select and entire row.
Select the row with just one click.

Enable compact mode
Compact the entire SuperTable, very useful to save dashboard space.

Enable group bar
Have the option to show or hide the grouping bar in your SuperTable

Enable sidebar
Enable the option to show or hide the sidebar in the SuperTables extension for Dashboard users. You can also individually set this option for only the

  • Columns panel
  • Filter panel

Enable quick filters
Have the option to show or hide quick filters in the column headers of your SuperTable.

Enable status bar
Have the option to show or hide status bar in your SuperTable. The status bar is shown in SuperTables at the bottom and holds information on the total number of rows and filtered rows.

Enable RTL
RTL stands for ‘Right To Left’. This gives the SuperTable users the option to rearrange their SuperTable for it to read from the right to the left of the screen.

Enable Pagination
Show pagination at the footer of your SuperTable. You can click through each page or use to go to the last.

Show SuperTables in a popup on mark selection

Important: Reload the extension after changing the popup settings.

Choose which worksheet to trigger the pop up. This will turn the SuperTable in to a dashboard button to save that vital dashboard space and will be triggered by your chosen worksheet. Allow the popup up only when the datasheet has data (has negative performance impact).

Grouping Options

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 “Furniture”:

SuperTables plain table

Enable a ‘grand’ total across all groups
Show a grand total of all groups in 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:

Plain Table with parent row enabled

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

Hide the parent row in SuperTables

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:

SuperTables shows a row counter when grouping

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

Row counter in SuperTables

Use multiple columns for grouping

When you use the grouping bar,  SuperTables uses one column for the group by defau;t. 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”:

Use multiple columns for grouping

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

Default SuperTables

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:

Show aggregation function in header

By default, the display of the aggregation is turned off:

Display aggregation SuperTables

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:

Automaticaly expand grouped rows SuperTables

And the result will be:

SuperTables Result aggregation

Event listeners

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

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.

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.

Exclude event listener in SuperTables

Pivoting options

Enable Pivot Header
Show or hide column headers when in Pivot mode.

Enable row total columns for each value at end of pivot table

Enable or disable row total columns for each value at the end of the pivot table.

Pivot column is date

If a column header in your pivot table is a date, you can format it’s appearance here.

Restrictions

Use the this tab to decide what the users will be able to do once you publish your dashboard to Tableau Server or Online. By default, there are no restrictions set in SuperTables. If you decide it is better for your use case to restrict people from some of the SuperTables functions, you can set it up in this configuration. screen.

User can adjust column width

When creating a pixel perfect dashboard, you might want to fix the column widths in your SuperTable. This option prevents your dashboard users from changing the column width.

User can sort columns

Some use cases require a strict sorting of the columns in your SuperTable. This option helps you maintain that sorting by preventing the dashboard users to change the column sorting in your SuperTable.

User can order columns

Some use cases require a strict order of the columns in your SuperTable. This option helps you maintain that order by preventing the dashboard users to change the column order in your SuperTable.

User can anonymize data

You can either allow or deny your Dashboard users to use the Anonymize function of SuperTables.

User can Copy data

The great thing of SuperTables is that you dimmish the demand for working with Exce However,  SuperTables allows users to copy selections of rows/cells to the clipboard by default. This option can prevent your users to copy the data of SuperTables to the clipboard.

User can export data

SuperTables allows Dashboard Users to export the (filtered) data to Excel or CSV files by default. If your use case needs to restrict this export you can use this option to restrict the Dashboard users from exporting the data.

Export

Here you can decide what will be exported and how it will be formatted when exporting your SuperTable.

Differentiate between even and odd rows

Use the row banding when you do an export to Excel.

The first line are column header names

Export the column header names as a first row in the export.

Include header column grouping

If you use grouping, you can choose to include the header of the column grouping in your export.

Include group rows

When using the grouping option, you can decide if you want to include grouped rows as well in your export.

Export visible columns only

In SuperTables you can show/hide columns, this option allows you to export visible columns only or use all available columns.

Export all rows except last level

If you want your users to prevent to export the lowest member of your groupings, you can use this option. The row level data will not be exported because the export only contains the aggregated data of your grouping structure.

Format exported values

In the DATA tab of configuration you can set the formatting of your measures. This option allows you to include this formatting in your export, or use the raw data without the formatting on the Configuration | DATA pane. SuperTables will not export the formatting of the table in your dashboard because this is only about the formatted values in the export.

About

Here, you will find which version of SuperTables you are using along with the changelog of all the updates from previous versions. Support email and the Infotopics | Apps for Tableau website link are also available in here.

We love to make solutions and help Tableau users to do things more efficiently. If you have feedback, ideas, questions or need support, please make sure to share it with us! Also, don’t forget to follow us on social media for our latest news and updates.