# Landing Page Welcome to your team’s developer platform

Welcome to the Apps for Tableau documentation platform

What can I help with?

			Cover image
Product Guides	Get started with the product guides.	/pages/LeUvLbIwcutGmDSDmyOx	/files/icbyzIetgmbb3R50jy3G
Installation	Learn more about how to safely install our products.	/spaces/6yVPUWGXrvCkUcDV7WOV	/files/n1VjDmKhSTpf8Ugp0s4N
Frequently asked Questions	General FAQs, how to whitelist an extension and more	/spaces/dDiTxjp8LFOiDsQOFXgM/pages/7aXE006H0PPIUbBTwneI	/files/KdIInRvHRz0pLLdr8X75

{% columns %} {% column width="58.333333333333336%" %} ### Still got a question? We are here to help you along the way! Contact Support {% endcolumn %} {% column width="41.666666666666664%" %}

{% endcolumn %} {% endcolumns %} # Product Overview

		Cover image
SuperTables	Interactive Excel-like tables allow users to decide how to organize their data.	/spaces/LnoH7e1UvmBe6dtToVtG/files/REbujovtRiuRScHKjELB	/spaces/e2zyseN6XFBaLs6YTcnd
WriteBackExtreme	The ultimate on-premise solution for Tableau write-back capabilities.	/spaces/LnoH7e1UvmBe6dtToVtG/files/S40vMc4OSWsgmwuaO0CM	/spaces/0gkOLIfzuEyMP2kvoT9o
MailScheduler	Send multiple time scheduled Tableau Dashboards with filters via mail.	/spaces/LnoH7e1UvmBe6dtToVtG/files/5GFP2aZQ71aX9DWtTdXo	/spaces/OEnvavVjEKojggGVc69T
InputTables	The Excel like Tableau extension that captures and stores user input.	/spaces/LnoH7e1UvmBe6dtToVtG/files/dGiPQ8Vsk0VhavVwPzy9	/spaces/I9t4RSYLlrfjY1Kmrop5
DashboardUsage	Keep track of your dashboards and perform analytics even better.	/spaces/LnoH7e1UvmBe6dtToVtG/files/7cIHYi5wX3PH0pgrIAFQ	/spaces/rNvwGQ98FzOn9vDFlnPg
DrillDownTree	Better insights into your Tableau data through drill-down actions.	/spaces/LnoH7e1UvmBe6dtToVtG/files/AFzQcEwsIR7oyWZqopEW	/spaces/fen81laUQFBf286HYARr
HierarchyFilter	Visualize, browse and interact with your hierarchies in Tableau.	/spaces/LnoH7e1UvmBe6dtToVtG/files/bgTjdzQK5BrGeSS3RleB	/spaces/K3U0wkPv59dq9SL5SnaR
MarginalHistogram	Simplify exploratory data analysis in Tableau.	/spaces/LnoH7e1UvmBe6dtToVtG/files/kiZC1u13Bo1L1XXvPBCD	/spaces/DmxsK8p3R9fANjv4ok28
PictureThis	Create dynamic image tables and use an image table to filter your dashboards.	/spaces/LnoH7e1UvmBe6dtToVtG/files/sru2jgocct6NcJIp7Cd4	/spaces/wiROQsuR1aGKNjfajOv6
PowerKPIs	Your new central entry point for Tableau analysis.	/spaces/LnoH7e1UvmBe6dtToVtG/files/8ktPOlqQZWj0zpgDiJmY	/spaces/xF3J9z75cLxrADGYFAvj
FinanceTables	IBCS-ready financial reporting, directly in Tableau.	/spaces/LnoH7e1UvmBe6dtToVtG/files/eBTFepIlZVpheWmmNVcJ	/spaces/iZfqoxsewmqv31O4dzH1
ProcessMining	Gain insight and be in control over your business processes as they actually are.	/spaces/LnoH7e1UvmBe6dtToVtG/files/r1J0ulHFvB2xMwyqeDCE	/spaces/lMXiEkbAu7fycbUmdbrd
Scrollytelling	Craft engaging narratives using videos, pictures, and custom Tableau actions in your dashboard.	/spaces/LnoH7e1UvmBe6dtToVtG/files/Bf2fdaY7T0hqv8KwCKgL	/spaces/YSqkszLhZFW4UZlgSptC
ShowMeMore	Create beautiful new visuals in Tableau with just a few clicks.	/spaces/LnoH7e1UvmBe6dtToVtG/files/GhDb0y1vaLM0zx2YXBzn	/spaces/0ARtwElTSzdwWxw4t1pi

# Product overview

		Cover image
SuperTables	Interactive Excel-like tables allow users to decide how to organize their data.	/files/REbujovtRiuRScHKjELB	/spaces/e2zyseN6XFBaLs6YTcnd
WriteBackExtreme	The ultimate on-premise solution for Tableau write-back capabilities.	/files/S40vMc4OSWsgmwuaO0CM	/spaces/0gkOLIfzuEyMP2kvoT9o
MailScheduler	Send multiple time scheduled Tableau Dashboards with filters via mail.	/files/5GFP2aZQ71aX9DWtTdXo	/spaces/OEnvavVjEKojggGVc69T
InputTables	The Excel like Tableau extension that captures and stores user input.	/files/dGiPQ8Vsk0VhavVwPzy9	/spaces/I9t4RSYLlrfjY1Kmrop5
DashboardUsage	Keep track of your dashboards and perform analytics even better.	/files/7cIHYi5wX3PH0pgrIAFQ	/spaces/rNvwGQ98FzOn9vDFlnPg
DrillDownTree	Better insights into your Tableau data through drill-down actions.	/files/AFzQcEwsIR7oyWZqopEW	/spaces/fen81laUQFBf286HYARr
HierarchyFilter	Visualize, browse and interact with your hierarchies in Tableau.	/files/bgTjdzQK5BrGeSS3RleB	/spaces/K3U0wkPv59dq9SL5SnaR
MarginalHistogram	Simplify exploratory data analysis in Tableau.	/files/kiZC1u13Bo1L1XXvPBCD	/spaces/DmxsK8p3R9fANjv4ok28
PictureThis	Create dynamic image tables and use an image table to filter your dashboards.	/files/sru2jgocct6NcJIp7Cd4	/spaces/wiROQsuR1aGKNjfajOv6
PowerKPIs	Your new central entry point for Tableau analysis.	/files/8ktPOlqQZWj0zpgDiJmY	/spaces/xF3J9z75cLxrADGYFAvj
FinanceTables	IBCS-ready financial reporting, directly in Tableau.	/files/eBTFepIlZVpheWmmNVcJ	/spaces/iZfqoxsewmqv31O4dzH1
ProcessMining	Gain insight and be in control over your business processes as they actually are.	/files/r1J0ulHFvB2xMwyqeDCE	/spaces/lMXiEkbAu7fycbUmdbrd
Scrollytelling	Craft engaging narratives using videos, pictures, and custom Tableau actions in your dashboard.	/files/Bf2fdaY7T0hqv8KwCKgL	/spaces/YSqkszLhZFW4UZlgSptC
ShowMeMore	Create beautiful new visuals in Tableau with just a few clicks.	/files/GhDb0y1vaLM0zx2YXBzn	/spaces/0ARtwElTSzdwWxw4t1pi

# SuperTables

What can I help with?

Welcome to SuperTables, a powerful Dashboard Extension for **Tableau** and **Power BI** that brings interactive, Excel-like tables right into your Tableau environment. SuperTables offers unparalleled flexibility, enabling your dashboard users to organize and analyze their data with ease. With SuperTables, users can enhance their dashboard experience through features like on-the-fly grouping, sorting, filtering, pivoting, write back and exporting. The intuitive and user-friendly interface makes it simple to get started with just a few clicks, allowing users to dive deep into their data instantly. Whether you are looking to provide dashboard users with customizable tables or enable them to create personalized views on Tableau Server/Tableau Online and Power BI environments, Supertables has you covered.


Getting Started	If you are new to SuperTables, our Quick Start Guide is highly recommended to help you get started instantly	/pages/W7lMc8eL7SDSylf9INdt
Exploring Features	To discover all the amazing capabilities of SuperTables, visit our Features page. It contains detailed instructions and videos on each feature, helping you make the most of SuperTables	/pages/q6rNgBA4mNUkW02s3FYP
Configuration	For detailed information on setting up SuperTables, check out the Configuration Screen page	/pages/EWdZO6iudWsTcC6w4J9i
Advanced Guides	We have created comprehensive guides on the most popular and advanced features of SuperTables. Explore these guides to maximize the value you can create with SuperTables	/pages/sH7s18PKOzGrR2AyNVo4

Stay in the flow with SuperTables and transform the way you interact with your data within Tableau Dashboards! # Getting Started {% hint style="warning" %} This manual is for Tableau and Power BI, some features are only available in Tableau. This is made clear in the documentation with a banner. {% endhint %} Welcome to the Getting Started section of SuperTables! This is your go-to resource for quickly and efficiently integrating SuperTables into your Tableau or Power BI environment. Whether you’re new to SuperTables or need Assistance with installation, we’ve got you covered. To get up and running with SuperTables, choose your BI Platform:

		Cover image
Tableau	/pages/lSgw24s1xptR3XH8UYOZ
PowerBI	/pages/62NxRwBJLsBsDDC2fawX

These guides will walk you through the essential steps to begin using SuperTables in your dashboards. Dive in and start transforming your dashboards with the power of Supertables! ⚠️ **Important Deployment Requirement (InputTables)** When using **InputTables with SuperTables**, SuperTables and WriteBackExtreme must use the **same deployment model**. * SuperTables SaaS → WriteBackExtreme SaaS * WriteBackExtreme On-Prem → SuperTables On-Prem Mixed deployments (SaaS + On-Prem) are **not supported** and may result in connection errors. For details, see:\ # Tableau Welcome to the Quick Start Guide for SuperTables! By the end of this guide, you'll understand how to use the SuperTables Extension within Tableau, even if you're new to Tableau Extensions. SuperTables can be used as either a Dashboard Extension or a Viz Extension. First you need to ensure that you have the prerequisites required to run SuperTables. ## Pre-Requisites Before you begin, ensure you have the following:

Tableau Environment

You need a functioning Tableau environment (Desktop, Cloud, or Server). If you don't have one, you can [request a free trial](https://www.tableau.com/products/trial) on Tableau's website. Supported Versions: * Tableau Desktop 2018.2 and later * Tableau Server 2018.2 and alter * Tableau Cloud

SuperTables Extension

You'll need to import the SuperTables extension into your Tableau Dashboard. There are two ways to do this. 1. **Using a TREX file**\ This file contains the extension's information. If you're an existing customer or have requested a trial, you should have access to this file. If not, [request a free trial.](https://appsfortableau.infotopics.com/request-free-trial/) 2. **Using the Tableau Exchange**\ The marketplace for Tableau extensions available on versions since 2018.2. If you do not have a TREX file, a free version of SuperTables found on Tableau Exchange can be used.

*** ## Setting Up Your Extension After Setting up the pre requisites you can then setting up SuperTables following one of the guides below: {% content-ref url="/pages/n2oAuAWD5W4ASx3PYXrc" %} [Setting Up SuperTables In a Dashboard](/supertables/getting-started/quick-start-guide/setting-up-supertables-in-a-dashboard) {% endcontent-ref %} {% content-ref url="/pages/D5MNBji6x6CI4iRiq6cM" %} [Setting up SuperTables as a Viz extension](/supertables/getting-started/quick-start-guide/setting-up-supertables-as-a-viz-extension) {% endcontent-ref %} # Installation SuperTables is available in 3 different versions. This document outlines how to install the extensions for all 3 versions. 1. Enterprise Customers 2. Share Customers 3. Free Users *** ## Enterprise Customers Enterprise Customers can use the guide available here to install SuperTables: [Guide](https://appsfortableau.infotopics.com/support/documentation/enterprise-installation-guide-v1/) *** ## Share Customers Share customers can easily access SuperTables through our portal. Follow these steps: 1. **Log in to the Share Portal**: Visit our [share portal](https://my-appsfortableau.infotopics.com/my-products) 2. **Access Your Account**: Enter your login credentials and access your account dashboard. #### Downloading the TREX File After Logging in you should be able to view all the available products.

1. Download the TREX File. 2. Open your dashboard or worksheet. 3. Click Add Extension. 4. Click Access Local (Viz) Extensions. 5. Navigate to your downloaded TREX File. 6. Click Open 7. Click Ok on the prompt asking for permission.. *** ## Free Users Free users can access SuperTables through the Tableau Exchange. Follow these steps to get started: 1. Open your dashboard or worksheet. 2. Click Add Extension. 3. Search for Super Tables 4. Click Open 5. Click Ok on the prompt asking for permission.. # Setting Up SuperTables In a Dashboard Let's setup SuperTables in Dashboard. Let's get started! ## 1. Prepare a Worksheet Create a worksheet containing the data for SuperTables. We will be using the Superstore dataset for this guide. 1. **Create a New Worksheet:** For example, Name it 'ST Worksheet'. 2. **Add Data:** Drag all columns from the left pane into the 'Detail' marks card.

## 2. Prepare a Dashboard Integrate the worksheet into a new dashboard. 1. **Create a New Dashboard:** Name it 'SuperTables'. 2. **Add the Worksheet:** Drag and drop the 'ST Worksheet' into the dashboard. 3. **Hide the Worksheet:** This ensures the worksheet is available without being visible. 1. Make the worksheet floating. 2. Set the X and Y positions to 1 and the W and H sizes to 1 under the 'Layout' pane to keep it invisible. ## 3. Add SuperTables to Your Dashboard Add the SuperTables Extension. 1. **Add Extension Object:** Drag the Extensions Object from the Dashboard pane into the dashboard

1. **Import SuperTables:** * If you have a TREX file: * Click on 'Access Local Extensions' * Navigate to the TREX file and select the TREX file. * Alternatively: * Search for SuperTables in the Tableau Exchange * Click add to the dashboard. 2. **Authorize Extension**: Click ‘OK’ to allow the extension to run in your dashboard. ## 4. Configure SuperTables Set up SuperTables for your data. 1. **Open Configuration**: Click the bright pink configuration button on the landing page. 2. **Select Worksheet**: The ‘ST Worksheet’ should be selected by default, displaying all its dimensions and measures. If you have multiple worksheets on the dashboard, select the desired one from the ‘Datasheet’ dropdown on the top left. 3. **Apply Settings**: Hit ‘Apply & Close’ to view your data in SuperTables. :tada:Congratulations! :tada: You have successfully added and configured SuperTables in your Tableau dashboard. Now, explore all the[ powerful features](broken://pages/YZjxbGJatqlek9xQdeJR) SuperTables offers. For more information on configuring SuperTables, check out the detailed [Configuration Screen documentation](/supertables/configuration/configuration-screen). # Setting up SuperTables as a Viz extension Let's setup SuperTables in Dashboard. Let's get started! ## 1. Prepare a Worksheet Create a worksheet containing the data for SuperTables. We will be using the Superstore dataset for this guide. 1. **Create a New Worksheet:** For example, Name it 'ST Worksheet'. 2. **Add Data:** Drag all columns from the left pane into the 'Detail' marks card.

## 2. Add SuperTables to Your WorkSheet 1. **Add The Extension:** Navigate to the Marks Pane and Select Add Viz Extension from the dropdown.

1. **Apply Settings**: Hit ‘Apply & Close’ to view your data in SuperTables. :tada:Congratulations! :tada: You have successfully added and configured SuperTables in your Tableau dashboard. Now, explore all the[ powerful features](broken://pages/YZjxbGJatqlek9xQdeJR) SuperTables offers. For more information on configuring SuperTables, check out the detailed [Configuration Screen documentation](/supertables/configuration/configuration-screen). # PowerBI Start by adding SuperTables from the Microsoft AppExchange to your dashboard. Make sure to use **SuperTables** and not 'SuperTables Legacy'. You can find it [here.](https://marketplace.microsoft.com/en-us/product/power-bi-visuals/infotopicsbv1652776028763.supertables_next?tab=Overview) {% embed url="" %} After adding it to the dashboard, add your dimensions and measures to the column and value sections in the sidebar. After that you are ready to start! You can click on the configure button to customize your SuperTables. All settings are done through the configuration button. {% hint style="info" %} The sidebar is only used to set the license key if you bought a license directly through us. {% endhint %} # Licensing ### Named License If you have purchased or are looking for named licenses, you can buy them directly through the Microsoft store here: After that, assign the licenses to your Power BI users in your Microsoft Admin area. More information on how to do this [here](https://appsforpowerbi.infotopics.com/2022/10/06/assign-visuals-to-users/). You are now ready to use SuperTables! ### Enterprise License {% embed url="" %} Start by downloading your license key from the customer portal: [here](https://my-appsfortableau.infotopics.com/my-products) Paste the license in the 'license' section of the sidebar. When you have a valid license, you will see your company name, email, number of users, and expiration date. You are now ready to use SuperTables!

# InputTables username setup In SuperTables for Power BI, the username for InputTables is chosen in the general InputTables configuration (configuration → InputTables), *not* from the visual’s Format pane. To make a column available for selection, first add it to the visual (either the **Column** or **Value** box in the Format pane). If the username column isn’t added to the visual, InputTables won’t detect it and it won’t appear in the configuration dropdown. Once you add the column it will appear in the SuperTables grid. Open the **Custom configuration**, go to the InputTables tab, log in, and select the column as the username. After you save the InputTables configuration, the chosen username column will be registered with InputTables and will be removed from the SuperTables grid.

InputTables configuration with the selected username column.

If you don’t already have a username column, you can create one in your semantic model by adding a new measure that uses the `USERNAME()` function — this creates a column containing the current user’s name which you can then add to the visual and select in InputTables. For more information on InputTables, see the original documentation here: [InputTables](https://docs.infotopics.com/inputtables/) # UI Overview The UI of super tables contains the follow parts, ### The Data section This is the most important section this is the part of super tables which contains all of your row data.

### The Side Configuration Pane On the right side of the super tables we have a configuration pane that can be used to customize the appearance of presented data.

#### The side configuration pane contains 3 tabs:

#### Columns Pane This panel contains all the columns that are available. The check box can be used to display the column in the table.

#### Filters Pane

Filter panel provides an overview of all the available filters and can be used to setup filters. #### Formulas Pane

Formula panel can be used to create formulas. # Pivot SuperTables has Pivot mode, which is a feature that allows users to summarize, analyze, explore, and present large amounts of data dynamically. In pivot mode, users can reorganize and aggregate data to generate meaningful insights through a pivot table.

The Pivot Mode can be enabled by opening the side panel and clicking on the Pivot Mode toggle. Your table will now only display the aggregate values of the columns that you had enabled. Try enabling some dimension columns. Enabling the columns will the dynamically aggregate the data based on the data in the column.

# Formulas This section describes the formulas available to users for on-the-fly data analysis. The formula editor allows end users to add formula-based columns to their SuperTables view using the measures and dimensions available to them.

#### Alignment options You can align the Column or just the Header either 'Left', 'Right' or 'Center'. There is also an 'Auto' option to align the text in relation to the rest of the table. #### Formatting options Formulas can be formatted as a decimal number, currency or percentage. The amount of decimals can be edited, as well as the pre-and-suffix appended to the calculated measure. #### Color options You can customise the column background color, column font color, header background color or the header font color with this option. #### IF/ELSE configuration Using the If-Else Formula Editor, advanced formulas can be created using conditions for both strings and values. Set the “if” statement, calculations for when the condition is and isn’t met, and potential other “if” statements using additional “else-if” blocks. Advanced conditions using AND/OR clauses can also be set in these formulas.

To learn more about how to create formulas, read the [guide on calculations](/supertables/guides/setting-up-calculations). # Row Groupings

A feature of SuperTables is that it allows your dashboard users to create their grouping hierarchy. This can be done without the need for a Tableau fixed Hierarchy 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 hierarchies just by adding columns to the grouping bar.

# Status Bar The Status Bar is present at the bottom of the SuperTables by default. The Status Bar contains the current information about the data.

Status bar can contain information about the rows, filtered rows, count and other things depending on the context. # Custom Views {% hint style="info" %} This guide is for **Tableau** only. For Power BI you can use the bookmarks feature which will automatically save the state of your current table. {% endhint %} 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 settings 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**”

* Save/Store your parameter * Head to the General tab of your SuperTables configuration pane and select the new parameter from the dropdown

#### Custom Views Create your own custom views of SuperTables! Each user can create their own unique view of their dashboard containing SuperTables. Wish to just see a compact view, sales view or a customer only view? Save as many views as you wish to be easily accessible every time you log in. You can make any view your default as well as making them available for your team! # Inline Filter 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.

### Configuration To enable Inline Filtering, Follow these steps: 1. Open the **configure screen** within the extension. 2. Under the **Data** tab click on the **dimension(s)** you wish to have an inline filter. 3. Halfway down you will see ‘**filter style**’, click on ‘**Wildcard Match**’ to have the inline filter activated on your table. 4. **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. ### Limitation The inline filter can not be used if advanced filter is being used. # Advanced Filter The advance filter feature consists of one long bar which can combine multiple filters into one expression. In addition to typing the filters by yourself, you can also use the builder tool to visually create complex filters to fit your use-case. Optionally enable the use of hidden columns in the advanced filter.

### Configuration To enable advanced filter follow these steps: 1. Open the configuration screen 2. Navigate to the appearance tab 3. Click on enable **Advance inline filter**

### Limitation The advanced filter can not be used in conjuction with inline filter. # Grouping 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.

### Configuration To enable this feature, follow these steps: 1. Go to the **configuration screen** 2. Navigate to the **Appearance** tab, 3. Under **Grouping Options** , tick the ‘**Enable group bar’**. 4. **Also,** within the **Appearance** tab under **Grouping Options** 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.
# Column order Click, drag and drop any header along the columns to change the order.

# Hiding a column 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.

# Sorting Columns 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.

Set a **default sort order** for dimensions, or set a **custom sort order**, overwriting the default alphabetical order: # 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 designed to help your Dashboard users with some extra self-service analytics on the SuperTables data.

# Column Pane 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 un-check tick boxes to show/hide columns you would like to see in your SuperTable. # Filter Pane In the **Sidebar** on the right side of your SuperTable you also see a “**Filters**” 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.

# Row Groups A feature of SuperTables is that it allows your dashboard users to create their own grouping hierarchy. This can be done without the need for a Tableau fixed Hierarchy 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. # Autosize Columns SuperTables allows user to autosize columns, this can be done by double clicking 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, auto size all columns, or dynamically size columns based on the window size, just with one click!

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

[Cell Features](/supertables/features/context-menu/cell-features) [Copy With Headers](/supertables/features/context-menu/copy-with-headers) [Clear All Filters](/supertables/features/context-menu/clear-all-filters) [Export to PDF](/supertables/features/context-menu/export-to-pdf) [Export to Excel & CSV](/supertables/features/context-menu/export-to-excel-and-csv) # Cell Features ### Keep Only **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.

### Exclude **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.

### Anonymize 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**.

# Copy With Headers 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.

# Clear All Filters Clear all active filters in one foul swoop by right clicking anywhere on your SuperTables and then going to ‘Clear all filter(s). See it below in action.

# Export to PDF Now export directly to PDF! This can include images too (for enterprise users). This will create a multi page PDF showing all the data in your view when exported. You can use export tab in the configuration screen to format your view. **TIP:** When renaming the filename be sure to add ‘.pdf’ to the end.

# Export to Excel & CSV 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 will respect the data type of the field.

**NOTE:** This feature is not available on iOS devices due to technical limitations. # Pivot Your Table

SuperTables has Pivot mode, which is a feature that allows users to summarize, analyze, explore, and present large amounts of data dynamically. In pivot mode, users can reorganize and aggregate data to generate meaningful insights through a pivot table.

# Dynamic Aggregation {% hint style="info" %} This guide is for **Tableau** only. {% endhint %} We combine the power of Tableau Parameters and visible columns in SuperTables. By doing this we will automatically remove / add detail from the datasheet which results in a different level of aggregation. With this incredible feature you only query the data you are looking at, and Table Calculations / LOD calculations will also keep working like you expect! On top of that you benefit from a performance boost! #### Dynamic Aggregation V2 (SuperTables 5.5.1+) We have introduced an easier and faster way of setting up dynamic aggregation which only requires 1 parameter! Please find attached workbook for an example: {% file src="/files/6QkKITxEaQ8Of3UQTQb8" %} #### Set up Dynamic Aggregation V2 * 1\. Create a string parameter with allowable values on 'All', and select it in the dropdown above. For example: My Parameter * 2\. Create a calculated field for the dimension you want to auto aggregate. For example: 'My Ship Mode' * 3\. Use this calculation:\ IIF(CONTAINS(\[My Parameter], "|My Ship Mode|"), \[Ship Mode], "\_")\ Optional: Surround the name of the calculation in "|" to ensure unique column selection * 4\. Remove the original \[Ship Mode] from the datasheet. * Tip: If you want to reuse your current \[Ship Mode] column configuration, rename \[Ship Mode] to something else (i.e. 'Original Ship Mode') and name you calculated field 'Ship Mode'.

#### Set up Dynamic Aggregation V1 (deprecated) Enter the configuration screen of SuperTables and head to the **Appearance** tab. Under Layout Options tick ‘Enable auto aggregation based on the visible columns in the table’

**Our example:** 1\. Create a string parameter with the exact same name as your column. For example: ‘Category’\ 2\. Create a calculated field with the same name as the parameter in step 1.\ 3\. Use this calculation: IIF(\[parameter\_name] = ‘true’, \[name\_of\_the\_dimension], ‘\_’)\ 4\. Check if the parameter updates when you show/hide the column. In this example the column ‘Category’. Next create a parameter of type ‘string’ with the current value ‘true’ as next we will be creating a calculated field. Follow our GIF to set up the calculated field. **Parameter:**

**Calculated Field:**

All done, reload the extension to implement the dynamic aggregation to your SuperTable!

#### Formatting options Formulas can be formatted as a decimal number, currency or percentage. The amount of decimals can be edited, as well as the pre-and-suffix appended to the calculated measure. #### IF/ELSE configuration Using the If-Else Formula Editor, advanced formulas can be created using conditions for both strings and values. Set the “if” statement, calculations for when the condition is and isn’t met, and potential other “if” statements using additional “else-if” blocks. Advanced conditions using AND/OR clauses can also be set in these formulas.

To learn more about how to create formulas, read the [guide on calculations](/supertables/guides/setting-up-calculations). # Configuration Screen ***Note: Configuration screen can only be accessed if you are in authoring mode.*** This section describes the configuration of your SuperTables you can customize how the data is presented. The configuration screen is further divided into multiple tabs. For a more detailed guide on configuring the options on each tab follow one of the subpages below: [Data Tab](/supertables/configuration/configuration-screen/data-tab) [Actions Tab](/supertables/configuration/configuration-screen/actions-tab) [Appearance Tab](/supertables/configuration/configuration-screen/appearance-tab) [Theme Tab](/supertables/configuration/configuration-screen/theme-tab) [Restrictions Tab](/supertables/configuration/configuration-screen/restrictions-tab) [Tooltip Tab](/supertables/configuration/configuration-screen/tooltip-tab) [Export Tab](/supertables/configuration/configuration-screen/export-tab) [About Tab](/supertables/configuration/configuration-screen/about-tab) **Note**: You’re able to use SuperTables whilst the configuration screen is open! # General Tab This general tab allows users to configure various settings for SuperTables, including data handling, performance, accessibility options, and exporting/importing configurations.

#### **Datasheet** * **Datasheet:** Dropdown menu to select the datasheet. * **Use parameter to select datasheet:** Enable use of a parameter to select the datasheet. When checked, an input field appears to specify the parameter containing the datasheet name. #### **Data Fetch Method** * **Load all data at once:** Loads all the data once (not recommended) * **Paginated loading:** Recommended for large datasets, which fetches data in pages. #### **Store Table Layout In** * **Parameter PM Savestate grouping:** Dropdown menu to select the parameter used to store the table layout state. 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). \ \ Guide: [Custom Views](/supertables/features/custom-views) #### **Performance Booster** * **Enable booster!:** Enable a performance booster. Improve performance (up to 40% with Tableau 2021.2 and later). This will use native values only and ignores the value formatting done in Tableau. Resulting in a big performance boost #### **Accessibility** * **Enhanced accessibility mode:** Checkbox to enable enhanced accessibility mode. Enabling this mode might negatively impact performance. #### Export SuperTables Configuration * **Configuration Name:** Name of the configuration to export. * **Export Button:** Button to export the configuration based on the selected options. #### Import SuperTables Configuration * **Select File:** Select a file for importing a configuration. * **Import Button:** Import the selected configuration file. # Data Tab On this tab, you can configure how SuperTable fetches and represents your data. For a detailed overview, visit one of the following sections: [Create Alias](/supertables/configuration/configuration-screen/data-tab/create-alias) [Data Fetch Method](/supertables/configuration/configuration-screen/data-tab/data-fetch-method) [Dimension Data Pane](/supertables/configuration/configuration-screen/data-tab/dimension-data-pane) [Measure Data Pane](/supertables/configuration/configuration-screen/data-tab/measure-data-pane) [Calculations Pane](/supertables/configuration/configuration-screen/data-tab/calculations-pane) [Column Groups Pane](/supertables/configuration/configuration-screen/data-tab/column-groups-pane) # Create Alias 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 “Column display name” on the Data pane of Configuration allows you to create an alias that will be shown in your column headers.

# Data Fetch Method SuperTables offers two ways to fetch your data to the extension, a bulk load all at once or paged loading. The Paged loading option “Loading Screen” requires Tableau version 2024.1 or higher or Tableau Cloud. **All at once** This is recommended for smaller data sets and the quickest way to see your data. The data will be sent all at one time. **Loading Screen** Recommended for larger data sets, the data will be sent via paged loading where you will see a loading screen. This will prevent any timeouts but may take longer than the “All at once” option.

# Dimension Data Pane In this section, we will take you through the dimension data pane and explain the options in the dimension configuration screen. Format each dimension field individually to suit your dashboard needs. The sections below provide a more detailed overview on configuring your dimensions. [Dimension Format](/supertables/configuration/configuration-screen/data-tab/dimension-data-pane/dimension-format) [Colors](/supertables/configuration/configuration-screen/data-tab/dimension-data-pane/colors) [Dimension Properties](/supertables/configuration/configuration-screen/data-tab/dimension-data-pane/dimension-properties) # Dimension Format Here, you can choose the style of your dimension. Plenty of options such as a Text field, a URL that can be rendered into an image, HTML, Markdown or even an emoji: ### Text The text field will view similar to what you’d see in a Tableau table.

### Image If your dimension holds data of an image URL, have that shown in your SuperTable. Add the width and height in px into the text boxes to set the proportions of the image. A good tip is to 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 calculated. We suggest setting at least one of the dimensions of the image size for better layout control. Leave the width and/or height empty for auto-detection and show the full image (max sizes). {% hint style="info" %} You can use base64 encoded images by creating a column in your dataset or calculated field to store these values as strings. {% endhint %}

### HTML Would you like videos shown within your Supertable? If your data holds embedded HTML, choose HTML as your dimension Type.

### Markdown Use the markdown language on your dimension. Such as header styles, # and more. Use this [website](https://www.markdownguide.org/basic-syntax/) to see the markdown language that can be used in SuperTables.

### Emoji Using the emoji codes in your dataset, show emojis in your SuperTable.

You can find the emoji codes [here](https://www.quackit.com/character_sets/emoji/emoji_v3.0/unicode_emoji_v3.0_characters_all.cfm)

### Date Format If your dimension is a **date** type, you can format the date in the view. For example “YYYY-MM” to 2025-05 for May 2025.

#### Filter date Filter now on a date part including exact date or even a range of dates. Want to show data over a specific time, easily filter your date to show in your viz.

Formatted date fields in SuperTables can now be used for aggregation. So if you have an exact date field in your dataset, and format the column to show only Year and Month you can aggregate that column (using the grouping bar) on Year-Month and the exact dates are aggregated based on your date formatting. \ \
# Colors Set a fixed background or font color to your column. If you have a sales and profit column for example and they’re the most important columns in your data set, grab your users attention by colorizing each column so users see the information that’s most important in your visualization. Set the color by clicking on the color palette on any measure or dimension in the data pane.

# Dimension Properties ### Styles Set the individual style of the Header and the Values in the table.

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

### Hide header name Enabling the "Hide header name" option this will remove the column header from the SuperTable view.

### Hide inline filter Hide the filter option for a specific dimension in the Supertables views. You see in our example it’s not possible to filter on Order ID but possible on Product Name.

### Hide grand total Hide the column total value. For instance you want to show the Sales total but not the quantity total in the total row of a grouped SuperTable, hide 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. ***Both -*** Both styles are applied.

### 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 color formatting

#### Color style 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 Use **Background color** to color rows based on specific dimension values. To configure this: 1. Open **Format Extension** 2. Go to the **Data** tab 3. Select the relevant **dimension** 4. Scroll down to **Background color** 5. Define the value and the color you want to apply 6. Enable **Use color as background color of entire row** if the color should be applied to the full row instead of only the selected cell This setting can be used when you want specific values in a dimension to drive row-level highlighting.

{% hint style="info" %} Please note that you cannot configure colors for a dimension with more than 50 members. {% endhint %} # Measure Data Pane This section describes the configuration options you can set with Measures. Here you will be able to format the style of your measure to from a number to a percentage for example. Define the aggregation of your measure as well as conditional format the color of your cells. We will describe each option available. In one of the sections below. [Measure Format](/supertables/configuration/configuration-screen/data-tab/measure-data-pane/measure-format) [Measure Properties](/supertables/configuration/configuration-screen/data-tab/measure-data-pane/measure-properties) # Measure Format Here, you can choose the format and style of your measure. Plenty of options such as a number format, unit and how values are represented. ### Number Format For measures you can select one of the following number formats: * Decimal * Currency * Percentage * Time ### Positive & Negative Values Format how you wish your positive and negative values are displayed in your SuperTable. See options below.

### Measure styles #### Decimals 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 intact 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 a thousand separator or 2021 if you disable the thousand 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. The 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 ### Unit Configure the display units for when measures reach thousands, millions, billions or trillions.

# Measure Properties ### Styles Set the individual style of the Header and the Values in the table.

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

### Hide 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.

### Hide header name Ticking this will remove the column header from the SuperTable view.

### Hide inline filter Hide the filter from a specific dimension. You see in our example it’s not possible to filter on Quantity but possible on Profit.

### Hide grand total Hide 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 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 Dashboard creators are able to restrict users to only aggregating to their chosen aggregation method. ### Aggregation Method Using the hamburger menu alongside a column allows you to change the column aggregation (change from SUM to AVG for instance). ### Truncate Values Truncate the measure to show a range by deciding on a minimum and maximum value. ### 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 measure. By default, it will show the measure name. This tooltip is for the column header only.

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 color formatting

#### Color style 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. #### Gradient 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 into a bar chart, setting the minimum and maximum bounds.

### Use color as background color of entire row Fill entire rows in your SuperTable by using the conditionally formatted colours of your upper and lower bounds.

# Calculations Pane 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](/supertables/guides/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.

# Sparklines Pane You can now have a cell that displays a graphical overview of the data summarised at group level. All you have to do is select the type of graph, the aggregation type, the x-axis and the y-axis fields.

There are different graphical visualisation types of Sparkline: * Area * Line * Bar ( Vertical ) * Bar ( Horizontal ) {% tabs %} {% tab title="Area" %} Displays a line that connects the data points with a highlight that is shown 'under' the line to the origin ( Zero point ).

{% endtab %} {% tab title="Line " %} This displays a line that connects the data points.

{% endtab %} {% tab title="Bar ( Vertical )" %} Displays the traditional bar chart in the vertical setting.

{% endtab %} {% tab title="Bar ( Horizontal )" %} Displays the traditional bar chart in the horizontal setting.

{% endtab %} {% endtabs %} ### How to create a Sparkline Creating a Sparkline is an easy process as you need just four variables: Type of Sparkline( Area by default), Aggregate type, X-Axis field and the Y-Axis field.
A detailed guide on how to create a Sparkline can be found in [How to create a Sparkline](/supertables/guides/how-to-create-a-sparkline) . # Sparkline Formatting You can customize how you want your Sparkline to look using the multiple formatting and styling options provided. ### Properties

* **Hide columnin sidebar -** Hides the Sparklin column in the sidebar. * **Hide header name -** Hides the name of the column in the SuperTables view. * **Column header alignment -** Horizontally aligns the header text. * **Header tooltip -** A custom tooltip you can create for the header. ### 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.

### Sparkline styling This is where you can assign a color to the unique properties of a Sparkline or where you can create a marker to show a data point. The styling options are unique to each type of Sparkline as these are explained below: {% tabs %} {% tab title="Area Sparkline" %}

* **Fill styling -** The color of the area highlight. * **Missing-data connection -** Toggles the option to connect broken area segments when there is a missing data point. * **Marker styling** - These are customizable points drawn at each data value point. You can choose the shape of the marker, it's size, stroke width, fill color and stroke color. {% endtab %} {% tab title="Line Sparkline" %}

* **Missing-data connection -** Toggles the option to connect broken area segments when there is a missing data point. * **Marker styling** - These are customizable points drawn at each data value point. You can choose the shape of the marker, it's size, stroke width, fill color and stroke color. {% endtab %} {% tab title="Bar ( Vertical ) Sparkline" %}

* **Fill styling -** The color of the area highlight. * **Stroke styling -** The outline color and width of each bar. * **Corner radius -** Defines how rounded each corner of a bar is. * **Category-axis padding -** Defines the spacing inside or outside each bar. * **Label styling -** You can enable the feature to display the value label on each bar, you can also customize the font size, font style,font weight and label color. {% endtab %} {% tab title="Bar ( Horizontal ) Sparkline" %}

* **Domain overrides -** These are min/max values defined for the y-axis field. * **Stroke styling -** You can choose the global stroke color and stroke width of a Sparkline. * **Highlight styling** - Customizes the highlight styling such as fill color, stroke width and stroke color when hovering over a data point. * **Padding** - Defines the top,bottom,left and right padding around the sparkline chart in respect to its cell. # Sparkline Date Filtering ### Creating the Date Filter To prevent creating an overwhelming and strange looking Sparkline that includes a date field as one of its axis it is recommended to use the Date Filter panel.

You can either define a **Standard** **range** or a **Custom** **range.** {% tabs %} {% tab title="Standard Range" %}

This uses a predefined range starting from whatever anchor point you select. * **Time period -** The time between each data point. This can either be Day, Week, Month, Quarter and Year. * **Number of (Time period) -** Defines how many instances of the time period chosen are selected in the axis. * **Anchor point -** Defines where to start creating time periods from. You can choose from the current day **(Today),** the most recent data point **( Latest Data )**, or from a **Specific Date** {% endtab %} {% tab title="Custom Range" %}

This uses a predefined range starting from whatever anchor point you select. * **Time period -** The time between each data point. This can either be Day, Week, Month, Quarter and Year. * **Start Date & End Date -** Defines the starting and ending data points to create time periods between. This means the number of time periods is completely dependant on the overall time between the two data points. {% endtab %} {% endtabs %} An example of a result of using the date filter is shown below:\ \- **Using a standard range based on 12 Quarters from the Latest data point:**

# Combined Columns Combined Columns allow you to combine date of different columns into one column and style it in a beautiful way. For example an image of a Client followed by the name in bold text and a title. #### Column List Style

This is made to show an image as a first column and on the right side of the image a list of dimension values. For example the Brand, Model and Price. You can define the style per column by expanding the menu of each column added as shown in the screenshot below. **Note: Any styles you apply in this configuration panel will overwrite the default styling set for the column added. You can reuse its default styling by selecting "Use column styling".** The image size is set on the dimension of the image found in the dimensions section in the sidebar. Make sure this column is set to Dimension Style 'Image' so you get the options to set the image height and width. Configuration of above result:

Configuration of the Cars combined column

**Note:** It is important to enable **automatic row height** in the appearance tab when using the 'Column List View' as these columns can use more space than a normal column and overflow. #### Inline style With the inline style all values are set on 1 row. This gives you a beautiful 1 row combined column:

#### Value Column The value column holds the value of the column. So one of the dimensions is the actual value of this column. This value is used in Grouping, Pivoting, Filtering and Export to Excel. ### Exporting a combined column to Excel, CSV and PDF It is important to note that when exporting the table of data with a combined column included, the **value** of the combined column is exported. For example is the combined column used above (**Cars**) is exported the following result will be displayed in all formats:

Cars combined column export in both Excel and PDF

As shown above, the value "Mercedes Benz" is displayed because the value column selected is **Brand** which contains "Mercedes Benz". **Note:** **If no value column is selected, the value displayed when exported is "Make sure to select a value column" which is the placeholder to notify you the user that you did not set a value column when creating the combined column.** # Column Groups Pane Add column groups to your SuperTables for a more organized, streamlined, and visually customizable approach to presenting and managing your data. Create your column groups in the data configuration tab and personalize them with enhanced customisation options, including the ability to independently style the background and font colors of each header cell.

#### Visibility You can use the eye icons to toggle the default visiblity of the column. A blue eye icon means the column is **visible** when its group is collapsed, while a pink closed eye icon means it will be **hidden**. The column will always be visible when the column group is expanded.

If a dimension or measure is part of a column group, this will be displayed in the configuration tab of these values, as seen below:

After creating the column group, the columns in the group will now be nested under the group.

# Actions Tab {% hint style="info" %} This guide is for **Tableau** only. {% endhint %} {% hint style="info" %} To use Actions with the External Data service, an additional step is needed, which you can read about here: [Dashboard Actions and Mapping](/supertables/configuration/setting-up-supertables-with-data-service/dashboard-actions-and-mapping) {% endhint %}

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 pink “**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. 4. Hide/Show elements action: This action allows you to hide/show a floating container when selecting/deselecting a row in SuperTables. Combine it with a Filter / Parameter action to show a filtered graph when clicking on a row in SuperTables. **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. #### Dashboard actions with the Data Service In the data service, you will need to select the **mapping** you made when setting up dashboard actions. This field determines which mapping is used when the action is triggered. Since a dashboard can contain multiple mappings, explicitly selecting the correct one ensures that the action corresponds to the intended data and behaves as expected.

To set up the mapping, you can read the instructions here: {% content-ref url="/pages/wurhi6UBXnnkYPm9fKZk" %} [Dashboard Actions and Mapping](/supertables/configuration/setting-up-supertables-with-data-service/dashboard-actions-and-mapping) {% endcontent-ref %} # Appearance Tab This tab can be used to customize how your data looks. Follow one of the links below for further detail on how to customize specifics aspects.
[Multiple Layouts](/supertables/configuration/configuration-screen/appearance-tab/multiple-layouts) [Charting](/supertables/configuration/configuration-screen/appearance-tab/charting) [Layout Options](/supertables/configuration/configuration-screen/appearance-tab/layout-options) [Grouping Options](/supertables/configuration/configuration-screen/appearance-tab/grouping-options) [Pivoting options](/supertables/configuration/configuration-screen/appearance-tab/pivoting-options) [Accessibility](/supertables/configuration/configuration-screen/appearance-tab/accessibility) # Multiple Layouts

SuperTable enables users to create and store multiple custom layouts for quick access. For instance, a user might arrange specific columns in a preferred order in one layout. This functionality allows users to use pre existing layouts without starting from scratch and to easily swap between layouts. Here’s a guide on how to create and store custom layouts: #### Configuration Firstly you will need to create two parameters of type string in your worksheet. One for storing the view and one for the layout change. Leave the value empty.

Step 1

#### Create a parameter First, create **two parameters of type *****String*** in your worksheet: 1. **View parameter** * Data type: **String** * Allowable values: **All** * Current value: *(leave empty)* 2. **Layout parameter** * Data type: **String** * Allowable values: **List** * Values: leave empty for now

Step 2

#### Configure parameter in supertables Open the **SuperTables configuration screen**. By default, you will land on the **General** tab, the one we need. In the **Store table layout in** setting, select the **layout parameter** you created earlier. This parameter will store the selected table layout.

Step 3

#### Configure second parameter you created Next, go to the **Appearance** tab in the SuperTables configuration screen. Scroll down to the section **Use a parameter to switch between layouts** and enable it.\ Then select the **layout parameter** you created earlier.

Step 4

#### Setup your dashboard - **Show the parameters** Right-click the parameters you created and select **Show Parameter** to make them visible on the worksheet or dashboard. All changes made in your **SuperTables** will be saved in your stored parameter. Once you have configured your SuperTable exactly as you want, copy the text shown in your **stored parameter**.

Step 5

#### Layout parameters Edit the layout parameter by clicking on the dropdown on the parameter. This is where we will be creating our custom layouts.

Paste your layout as a value in the list and name your custom view. SuperTables Adding Stored Layout

Repeat this process for each new custom view you wish to have on your dashboard. Once you have all the custom views you want, remove the stored layout from your dashboard. You can now click on each view and see an instant change in your SuperTable!

#### Video Tutorial {% embed url="" %} # 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 designed 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 The height of each cell 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 word wrapping Allows long text inside cells to wrap onto multiple lines instead of being cut off or shown on one line.\ This option is available when **Enable auto row height based on the contents of the cells** is disabled. ### Row height in pixels Set a fixed row height for the table.\ This option is available when **Enable auto row height based on the contents of the cells** is disabled. ### Vertical alignment Choose how content is vertically aligned inside the cells.\ This helps keep the table visually consistent, especially when using custom row heights or auto row height. ### 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 * Formulas panel * [InputTables panel](https://docs.infotopics.com/inputtables/) * [AI panel](/supertables/configuration/configuration-screen/ai) ### Enable status bar This option lets you toggle the visibility of the 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. ### Always show sorting icon on all header names Keep the ‘sorting’ icon in the header at all times when enabling this. This will show less experienced users how easy it can be to sort on each header. ### Hide Index column in the columns side panel Enable to hide the index column in the SuperTables instance. This will prevent it from showing up in the “columns” tab of your end-users. ### Enable auto aggregation based on the visible columns in the table V2 {% hint style="info" %} This is a **Tableau** only feature. {% endhint %} [Dynamic Aggregation](/supertables/features/dynamic-aggregation) ### Enable checkbox to select entire row Adds a checkbox that allows users to select an entire row.\ This is useful when users need a clear visual way to select records in the table. ### Enable to allow multiple rows to be selected with clicks When using devices where Ctrl and Shift is not an option, turn on this feature where each click of a row will keep all rows selected. Clicking on a selected cell will deselect the row. ### Enable allow multiple rows to be selected When selected, users can highlight multiple rows; when disabled, only a single row can be selected. Each selection of a new row will deselect the previous selection.

### Show button to clear all filters Shows a button that allows users to clear all filters applied in SuperTables. Can be positioned on the top or bottom right corner. ### Enable advance inline filter Enables advanced inline filtering directly in the table.\ This gives users more filtering options inside the column headers. ### Enable context menu in column header When this option is enabled, a three-dot menu appears next to each column name in the header. From this menu, users can pin columns, sort ascending or descending, autosize columns, fit columns to the window, group data, choose visible columns, and expand or collapse grouped rows. This gives more flexibility while keeping the table easy to navigate. ### Enable RTL (Right to Left) layout RTL stands for ‘Right To Left’. This gives the SuperTable users the option to rearrange their SuperTable, as it reads from right to left of the screen. ### Enable Pagination Show pagination at the footer of your SuperTable. You can click through each page or use it to go to the last. ### Show SuperTables in a pop-up on mark selection {% hint style="info" %} This is a **Tableau-only** feature. {% endhint %} **Important**: Reload the extension after changing the pop-up settings. Choose which worksheet to trigger the pop-up. This will turn the SuperTable into a dashboard button to save that vital dashboard space and will be triggered on mark selection. Allow the pop-up only when the datasheet has data (has a 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 “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. **Enable Group aggregation filtering** By default, column filters are not applied to cell values shown in Group Rows as they do not usually have any data of their own. However when using Aggregation, group rows will show aggregated values computed based on their child rows. You can filter the grid based on the group row aggregated values by enabling this setting. **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:

**Note: Enabling this option automatically disables "Enable sticky group rows" and "Enable sticky group total rows" options as they are mutually exclusive.** **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. Enabling this option disables the "When group is expanded, hide the parent row" option. **Enable sticky group total rows** This option will make the group total rows will stick to the top/bottom of the table when scrolling. Enabling this option disables the "When group is expanded, hide the parent row" option. **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.

#### Hide expand icon for empty group rows When enabled, SuperTables will automatically hide the expand/collapse icon for group rows that do not contain any child records. This option is especially useful when working with unbalanced hierarchies, as it prevents users from attempting to expand groups that have no underlying data. **Enabled** ``` ▶ Project A Project B ``` In this example: * **Project A** contains child rows and displays the expand icon. * **Project B** has no child rows and therefore does not display an expand icon. #### **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.

# 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. ### Custom notification options A message will be shown within your SuperTables if there’s an empty datasheet. Dashboard designers can determine what message will be shown. This can be a clear message to explain how to connect data or even if you wish to have a message shown in a different language. # Event listeners This page describes how to configure event listeners ### Update when the value of a parameter changes This option adds a listener to the selected parameters. Whenever a parameter value changes and triggers an event, the grid is automatically refreshed to reflect the updated state. ### \[Data Service] Update on mark selections from This option allows users to configure listeners for mark selections from native Tableau visualisations to SuperTables. It is a multi-select field that lets users choose one or more sheets available in the dashboard. Any selection made on these sheets will trigger a filter action, provided that the appropriate mapping is configured in the column mapping settings. # Accessibility #### Enhanced accessibility mode With enhanced accessibility mode all rows and columns will be rendered in the HTML for screen readers even the rows and columns which are not visible on the screen. Animations will be disabled when using enhanced mode. **NOTE:** Accessibility mode will have a negative impact on performance. To improve performance we recommend using the pagination option, you can follow our GIF to activate this.

# Theme Tab Your dashboards are about to look even better! Our most recent upgrade of SuperTables allows creators to match their SuperTables extension to their dashboards branding. Color your headers, text, borders and background to the theme you and your users recognize! All settings can be saved in the general workbook settings or in a parameter (this can be chosen in the appearance tab of the configuration screen).

#### Packaged themes A brand new tab is available for all your theming needs. Open the configuration screen of SuperTables and head to the Theme tab. By default SuperTables will have a Tableau look, you can change the whole style by using our pre-made themes such as Modern and Compact modes in both Light and Dark. Compact mode, as you can imagine, will compact your view, ideal to get all your columns and rows as visible as possible. Why not use one of the set themes as a starting point to then tweak to your liking?

**Compact Mode** Enabling compact mode will reduce line, height and cell spacing, a good way to save that valuable space. Compact mode will work when auto cell height is enabled too! **Tableau Fonts** Inherit fonts from Tableau workbook setting. This will use the font configured for worksheets in workbook formatting. This works from Tableau 2021.4 and higher) #### Colorize your SuperTable The new theming tab allows you to individually color segments of your SuperTable, from all the borders, headers and backgrounds to just the text color. Use the color palette alongside each option to choose your color from the palette or use HEX codes and RGB color values. See our GIF to show how easy it to transform the look!

# Restrictions Tab 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 anonymize data** You can either allow or deny your Dashboard users to use the Anonymize function of SuperTables. #### **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 order of 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 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 copy data** The great thing of SuperTables is that you diminish the demand for working with Excel. 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. #### User can use switch to pivot mode This options helps you restrict the end user from being to switch the table modes between the normal table and pivot table. This means you can set the mode to whatever you desire and maintain that mode after publishing by removing the "Pivot mode" UI button from the column sidebar for the end-user not to see. # Tooltip Tab The Advanced Tooltip Function is a powerful and versatile feature designed to augment your SuperTables dashboards. This function enriches your data exploration experience by providing interactive and customizable tooltips that can follow the mouse cursor or remain fixed. With a wide range of options for customization, it allows you to tailor the tooltips according to your specific needs and preferences. Follow this guide to setup a tooltip: [How to make tool tips](/supertables/guides/how-to-make-tool-tips) #### Tooltip limitations Tooltips are supported in standard (non-pivot) table mode. When **Pivot mode** is enabled, tooltips are **not available**. This is expected behavior because pivoting restructures the underlying data into dynamically generated cells, which no longer have a direct one-to-one mapping to the original Tableau rows required for tooltips. When **Group mode** is enabled, tooltips work only on **expanded rows** in non-pivot mode. Tooltips are not shown on collapsed group rows. If tooltips are required, we recommend using standard table mode or ensuring groups are expanded and Pivot mode is disabled. # Export Tab Here you can decide what will be exported and how it will be formatted when exporting your SuperTable.

#### **Floating export buttons** Add buttons to the bottom section of SuperTables that allow for easy exporting of the current view to Excel, CSV or PDF. #### Export button display type Select the way you want the export buttons to be displayed in the table, either in a drop down menu or as an icon. {% tabs %} {% tab title="Show button as icon" %} This displays the export buttons as icons.

{% endtab %} {% tab title="Show button in dropdown menu" %} This displays the export button in a dropdown menu.

{% endtab %} {% endtabs %} #### **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 (CSV files)** 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. #### **Include formatting in copied values** In the DATA tab of configuration you can set the formatting of your measures. This option allows you to include or exclude this formatting when you copy selected cells (or rows) to the clipboard using the context menu (context menu can be accessed by using a right mouse click)

#### **Export Name** Change the default file name when exporting to CSV or Excel. By default (no changes), the extension will be “export.xlsx” for Excel and “export.csv” for CSV exports. You can change the default filename and the file extension. For example, Newfilename – Newfilename.txt. If you want a dynamic export name, you can store the export filename in a parameter in Tableau and use the "Use parameter value" option to choose a parameter as the export value.

#### **Limit Exporting** Limit the amount of rows allowed exporting. This will export only the top amount of rows you decide on. ## Enterprise Only

#### **Logging Options(Enterprise Only)** Audit export and copy actions in SuperTables in a log file on the server where SuperTables is hosted. The log file will be found in the folder where the SuperTables binary is running. Log rows exist out of: Who, When, What (Number of Rows, Number of Columns), Type (Export, Copy), Dashboard, Workbook. #### **Set usernames(Enterprise Only)** Select a worksheet and column containing the username(). enable/disable audit on export and audit on copy. To create the user name you can create a calculated field and name it ‘Username’ with the calculation ‘USERNAME()’ Drag this to the marks pane of your datasheet. #### Export Image SuperTables enterprise enables you to export images that are present in your table to Excel. Click the include images in export option to enable this functionality.

**Note: Only PDF does not support text styles. This means any text styles set for both the column header and column values such as BOLD, ITALICS etc in the SUperTables view will not be included in the PDF export.** # AI Before configuring AI features in SuperTables, make sure that **WriteBackExtreme is connected** and that the required AI configuration has been completed in the WriteBackExtreme Management Console. AI functionality in SuperTables depends on two configuration steps in WriteBackExtreme: 1. **Model configuration** – Connecting an AI provider and defining model behavior 2. **Agent configuration** – Linking the model to the Summaries & Highlights and Generative Fill features These steps only need to be completed once by an administrator. After that, AI features can be fully setup ### Configure AI features in SuperTables The steps below describe how to enable and configure AI features in SuperTables. The configuration flow is the same for both **Summarize** and **Generative Fill**. *** #### Step 1 – Open the SuperTables configuration 1. Open your dashboard in **Tableau**. 2. Select the **SuperTables** extension. 3. Click **Configure** to open the extension settings. 4. Navigate to the **AI** tab. The AI tab shows the available AI features supported by SuperTables.

*** #### Step 2 – Select an AI agent Each AI feature in SuperTables must be linked to an AI agent. **Summarize** 1. In the AI configuration menu, select **Summarize**. 2. Under **AI Agent**, choose **Summaries & Highlights** from the dropdown. This agent is responsible for generating summaries and highlighting notable findings.

**Generative Fill** 1. Select **Generative Fill** in the AI configuration menu. 2. Under **AI Agent**, choose **Generative Fill** from the dropdown. This agent is responsible for generating and filling values based on table data and schema rules.

*** #### Step 3 – Configure the system prompt (optional) Each AI feature allows you to customize the **System Prompt**. The system prompt is applied to all AI requests for the selected feature and can be used to: * Set the tone and style of responses * Define formatting guidelines * Provide additional context (for example: role, language, or level of detail) > **Note**\ > The AI agents already include a default system prompt. Any text entered here is **added on top of** the existing prompt and extends the default behavior rather than replacing it. You can leave the system prompt empty to use the default behavior. *** #### Step 4 – Save the configuration 1. After selecting the AI agent and adjusting the system prompt, click **Save**. 2. Repeat the steps for the other AI feature if needed. Once saved, AI features are enabled and ready for use in SuperTables. # About Tab 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](https://appsfortableau.infotopics.com/). # Setting up SuperTables with Data Service This guide lets you get started with SuperTables with server side processing for large data sets. SuperTables primarily relies on the Tableau Extensions API to retrieve summary data. As a result, most processing occurs on the client side, and all data is loaded at once. To address performance limitations with large datasets, we are introducing a new approach that leverages server-side processing. This significantly reduces client-side load and improves scalability. To use this feature, users must be on **SuperTables version 6.x.x or later** and **WriteBackExtreme version 6.x.x or later**. ### Setting up a data source. These steps require you to create a semantic model in the WriteBackExtreme environment. You can follow this guide here to create a semantic model in WriteBackExtreme [Semantic modeling](/writebackextreme/features/management-console/semantic-modeling)

In the general tab, select **External Data Service** and then click on the **Configure** button to log into WriteBack Extreme, and connect to a data source.

Please contact your WriteBackExtreme administrator for the login URL and credentials. #### Connecting to a Data Source In this step, you can connect to a semantic model created in WriteBackExtreme. Click on the dropdown below, select the data source to connect to a Data Source.

Once a data source is connected, a list of all available columns is displayed. When the data source loads for the first time, all columns are disabled by default. Users can select only the columns they require, and this selection can be modified at any time from the Columns sidebar. For very large datasets, loading all columns at once can negatively impact performance, so selecting only the necessary columns is recommended.

**Auto aggregation** SuperTables with Data Service also support dynamic aggregation based on the visible columns in the table. This is a processing-intensive but very useful feature. When enabled, the data is aggregated based on the currently visible columns. For example, if only **Category** and **Sales** are visible, the table displays unique categories with the sum of sales. If **Category**, **Region**, and **Sales** are visible, the table shows sales aggregated by category per region. When this option is disabled, non-aggregated data is passed directly from the database to the grid. #### Export limitations when using the External Data Service When **External Data Service (WriteBackExtreme)** is selected as the data fetching method, **export options (CSV, XLS, PDF)** are intentionally disabled. This behavior is **by design** for the following reasons: **Performance** * The External Data Service is typically used for **very large datasets**. * Exporting large datasets directly from the extension could lead to **performance issues or very large file downloads**. **Security** * The data service provides **direct access to backend data sources**. * Allowing unrestricted export could expose **large portions of the underlying dataset**, which may not be intended. Because of this, export functionality is only available when using **Tableau Datasheet-based loading methods**, where Tableau controls the dataset size. # Dashboard Actions and Mapping We need to establish a connection between Tableau data and WriteBack Extreme semantic models to ensure that dashboard actions and filters work correctly and are translated properly between the two. As mentioned in the previous section, with the introduction of the Data Service, SuperTables no longer rely on data from the Extensions API. Since the data now comes from two different sources within the same dashboard, we need to establish mapping relationships to correctly translate dashboard actions and filters between Tableau and the semantic model, using the column mapping feature. #### Column mapping Filter column mapping acts as a dictionary, translating column names while performing actions from Tableau to SuperTables and the other way around. A SuperTables column can be mapped to multiple sheet columns if needed.

First, select a SuperTables column from the first dropdown, then select a Tableau column that has been added to a sheet. You can also type in the field to make searching easier. The dropdown supports multiple selections. Once added, the mappings will appear in the **All Mappings** section below. You can click the trash bin icon to remove a mapping. If all mappings associated with a SuperTables column are deleted, the entire row is removed automatically.

It is also possible to add a manual mapping entry. For example, if a sheet does not currently contain any data but the columns are already defined, the extension may not be able to fetch those columns. Similarly, if you expect a new column to be added later, you can create a manual mapping in advance. To do this, click the **Manage** button in the **All Mappings** section, then enter the column name you want to map to the corresponding SuperTables column. #### Dashboard actions In the data service, you will need to select the **mapping** you made when setting up dashboard actions. This field determines which mapping is used when the action is triggered. Since a dashboard can contain multiple mappings, explicitly selecting the correct one ensures that the action corresponds to the intended data and behaves as expected.

# Enterprise Only Functionality The Enterprise edition of SuperTables has some additional functionality not present in other versions. The follow functionality is only available in the enterprise edition of SuperTables: {% content-ref url="/pages/zJPaTeozi6aQJKHCS1W0" %} [Custom Themes (Enterprise Only)](/supertables/configuration/enterprise-only-functionality/custom-themes-enterprise-only) {% endcontent-ref %} {% content-ref url="/pages/kzKAhCgO4K548BAxizJK" %} [Custom Events (Enterprise Only)](/supertables/configuration/enterprise-only-functionality/custom-events-enterprise-only) {% endcontent-ref %} {% content-ref url="/pages/E1gdSuqKiDtobjzPv3rW" %} [Localization (Enterprise Only)](/supertables/configuration/enterprise-only-functionality/localization-enterprise-only) {% endcontent-ref %} {% content-ref url="/pages/gjZMYVG6F0nzVxPnKlVk" %} [Export Pictures In Excel (Enterprise Only)](/supertables/configuration/enterprise-only-functionality/export-pictures-in-excel-enterprise-only) {% endcontent-ref %} # Custom Themes (Enterprise Only) Customize the layout of SuperTables With SuperTables enterprise you have the full freedom to customize the layout of SuperTables. You can do this by editing the custom.css file which is part of the installation files. With custom css you can do almost anything from: * Company fonts and colors * Custom icons * Coloring * Edit spacing, margins and more * Hide parts of SuperTables like borders, elements and more. * And many more CSS tricks you can think of. An example of a custom table:

# Custom Events (Enterprise Only) In SuperTables 2.3.0 we have added the possibility to add custom content above and below the SuperTable. You can use this feature to add custom titles, buttons and more.

**Toggle columns and/or groups** We have also added a custom event you can use to hide/show (toggle) columns with a button. This feature enables you to show/hide groups of columns with a single click. There is example code available in custom.js and custom.css for the button layout.

# Localization (Enterprise Only) With SuperTables enterprise you have the full flexibility to change the language of your SuperTables installation to your own likings. You can find the localization file in the Enterprise Installation files. Update any of the values and the SuperTable will be updated automatically. ![SuperTables Product Guide SuperTables Product Guide](https://appsfortableau.infotopics.com/wp-content/uploads/2021/09/supertables-localisation.png)
# Export Pictures In Excel (Enterprise Only) SuperTables enterprise enables you to export images that are present in your table to Excel. This can be done by following these steps: 1. Open Configuration Panel 2. Navigate to the Export tab on the top bar 3. Enable export images option

# Setting up Calculations Supertables offers you the functionality to create your own custom Calculations. To Setup a calculation follow one of these guides. [Setting up a Simple Calculation](/supertables/guides/setting-up-calculations/setting-up-a-simple-calculation) # Setting up a Simple Calculation #### Step 1: Open Configuration {% tabs %} {% tab title="Dashboard extension" %} Click on the container that has SuperTables running. This will display an arrow that you can click to open a menu. Upon opening the menu, click the 'Configure...' option to open the configuration panel for SuperTables.

Opening configuration panel in Dashboard

{% endtab %} {% tab title="Viz extension" %} To open the configuration panel, simply click 'Format extension' in the Marks pane.

Opening the configuration panel in Viz extensions

{% endtab %} {% endtabs %} #### Step 2: Navigate to the Data tab

#### Step 3: Make a Calculation Column On the left side of the data tab. There is pane that says calculations, expand that menu and click 'Make a calculation' to create one.

#### Step 4: Create your Calculation You can now select any measure column that is present in the worksheet and make a calculation. To select a column press @ this will present a list of all available columns.

This is an example calculation to calculate the profit ratio. # If-Else Calculation #### Step 1: Open Configuration {% tabs %} {% tab title="Dashboard extension" %} Click on the container that has SuperTables running. This will display an arrow that you can click to open a menu. Upon opening the menu, click the 'Configure...' option to open the configuration panel for SuperTables.

{% endtab %} {% tab title="Viz extension" %} To open the configuration panel, simply click 'Format extension' in the Marks pane.

{% endtab %} {% endtabs %} #### Step 2: Navigate to the Data tab

#### Step 3: Make a Calculation Column On the left side of the data tab. There is pane that says calculations, expand that menu and click 'Make a calculation' to create one.

#### Step 4: Open If-Else Formulas Editor To access the if Else Formula Editor, Click on the 'If-Else Formula Editor' button which can be found under 'Calculation'.

#### Step 5: Create your Calculation In this case we will create a calculation that will display 0 if profit is lower than or equal to 0 but otherwise it will display the profit value.

Click save and Apply & Close.

# Date Calculation Date calculations are added in SuperTables 5.4.0. They allow you to do powerful calculations based on date fields and number fields. You can calculate with either dates and/or numbers combined. Examples: ``` DATE(Order Date) - DATE(Delivery Date) ``` Or when using a number: ``` DATE(Order Date) + (SUM(Nr of Shipping Days) * DAY()) ``` Numbers are by default in seconds. Therefore we added multiple helpers:![](/files/uXNTaonl3nNAuqhFmEKt) #### Step 1: Open Configuration {% tabs %} {% tab title="Dashboard extension" %} Click on the container that has SuperTables running. This will display an arrow that you can click to open a menu. Upon opening the menu, click the 'Configure...' option to open the configuration panel for SuperTables.

{% endtab %} {% tab title="Viz extension" %} To open the configuration panel, simply click 'Format extension' in the Marks pane.

{% endtab %} {% endtabs %} #### Step 2: Navigate to the Data tab

#### Step 3: Make a Calculation Column On the left side of the data tab. There is pane that says calculations, expand that menu and click 'Make a calculation' to create one.

#### Step 4: Navigate to the Calculation Box Navigate to the box that contains Calculation and set the Column Display type to 'Date'

#### Step 5: Write a calculation like this {% hint style="success" %} You can also use InputTables columns to calculate with date fields. For a dynamic updating dates. {% endhint %}

# Absolute Function The absolute function allows the user to get the absolute value of a cell.

Here is a step by step guide on how to add absolute function to your calculation: 1. Click on ABS button or Type ABS() 2. Input your Calculation instead of the ABS(your calculation) Example of the same calculation with and without ABS, **Profit Ratio** is the resulting column. {% tabs %} {% tab title="Absolute" %}

{% endtab %} {% tab title="No Absolute" %}

{% endtab %} {% endtabs %} # Other Calculation Functions There are other functions that can help you create complicated calculations.

{% tabs %} {% tab title="Exponentiation ( X^2 )" %} Exponentiation is a **mathematical operation** where a number (called the **base**) is multiplied by itself a certain number of times. Formula -> **COLUMN\_NAME \*\* EXPONENT**

{% endtab %} {% tab title="Square Root ( √ ) " %} The **square root of a number** is that factor of a number which when multiplied by itself gives the original number. Formula -> **RESULT = COLUMN\_NAME \*\* (1/2)**

{% endtab %} {% tab title="Brackets ()" %} These define the order in which operations are carried out based on **PEMDAS** or **BODMAS.** Illustrated below are the differences in the calculation **column + 10 \* 5** and **(column + 10) \* 5**

{% endtab %} {% tab title="ABS (Absolute)" %} This function is already well explained in [Absolute Function](/supertables/guides/setting-up-calculations/absolute-function) {% endtab %} {% tab title="Round " %} This function rounds off the result to the nearest whole number.

{% endtab %} {% endtabs %} # Conditionally coloring column(s) In SuperTables you can conditionally color columns to better visualize your data.

The right most column is conditionally colored.

#### Step 1: Open Configuration {% tabs %} {% tab title="Dashboard extension" %} Click on the container that has SuperTables running. This will display an arrow that you can click to open a menu. Upon opening the menu, click the 'Configure...' option to open the configuration panel for SuperTables.

{% endtab %} {% tab title="Viz extension" %} To open the configuration panel, simply click 'Format extension' in the Marks pane.

{% endtab %} {% endtabs %} #### Step 2: Navigate to the Data tab

#### Step 3: Select your column Select your column and scroll down to 'Conditional color formatting' section.

#### Step 4: Setting up your first conditional coloring 1. Select color cell background from the radio options. 2. Select a target column, select the same column as the one you have navigated to. 3. Select a below bounds color by clicking on the color swatch 4. Select a above bounds color by clicking on the color swatch 5. Setup an inbounds color. 6. Setup a lower bound. 1. if your measure spans from -100 to 100 and you want any value below 0 to be colored according to your below bounds color then choose 0 as your lower bound. 7. Setup an upper bound. 1. if your measure spans from -100 to 100 and you want any value above 50 to be colored according to your below bounds color then choose 50 as your upper bound. 8. Click Apply and Close 9. Now your measure should be color with your chosen colors. The section below explains all the additional coloring options available. ## Conditional Coloring Options #### Color cell background This options applying your coloring settings to the cell background

#### Color cell text This options applying your coloring settings to the cell background

#### Color entire row By default the conditional coloring is only applied to the column but with option you can apply it to the whole row instead.

{% tabs %} {% tab title="Normal" %}

{% endtab %} {% tab title="Whole Row" %}

{% endtab %} {% endtabs %} #### Target Column The column you use to color the column. The target column can be any other column. You can use one column to color another. #### Color bounds 1. Lower Bound: The minimum value, anything value in column that is below this value will be colored with below bounds color. 2. Upper Bound: The maximum value, anything value in column that is above this value will be colored with below bounds color. 3. Below-Bounds Color: Color used to color values lower than or equal to lower bound. 4. Above-Bounds Color: Color used to color values higher than or equal to Upper bound. 5. In-bounds Color: Color used to color values between lower and upper bound. #### Using a gradient By default conditional coloring uses discrete values for upper, in and lower bounds but turning this option on will convert discrete coloring to gradient (continuous) resulting from lower bound to upper bound.

#### Custom font color You can also assign a custom color to your font. The default color is b**lack**

#### Barchart Instead of just coloring the cell you can also create a bar chart within the cell.

Min-Value: is the value where your barchart length is 0. Max-Value: is the value where your barchart length is 100. # How to make tool tips SuperTables allows you to create custom tooltips that can be shown when you hover over a row or a specific column. To create a tooltip follow this guide. #### Step 1: Open Configuration {% tabs %} {% tab title="Dashboard extension" %} Click on the container that has SuperTables running. This will display an arrow that you can click to open a menu. Upon opening the menu, click the 'Configure...' option to open the configuration panel for SuperTables.

{% endtab %} {% tab title="Viz extension" %} To open the configuration panel, simply click 'Format extension' in the Marks pane.

{% endtab %} {% endtabs %} #### Step 2: Navigate to the Tooltip tab

#### Step 3: Click make a new tooltip On the left side of the Tooltip tab. There is a button that says make a new tooltip. Click make a new tooltip on there.

#### Step 4: Make your tooltip Choose the location of your tooltip first, for the purpose of this guide we are going to use visible on all columns(row tooltip) but you can also make the tool tip only visible on specific oclumns.

**Configure your tooltip**

Our tooltip creator uses a familiar rich text editor style for formatting the text inside of the tooltip. **1:** Adding a column name or value to your tool tip: Type '**$**' to display the current cell's name and value in the tooltip when you hover over the cell. For example, '**$Column Name**: **$Column Value**' will display the cell's column name and value in the tooltip when you hover over the cell.
**2:** Inserting a specific column: Type '**@**' followed by a column name to display the column value in the Tooltip. For instance, '**Profit Ratio: @Profit Ratio**' will replace **@Profit Ratio** with the actual value of the Profit Ratio column. **3:** Coloring your text: You can use the right most color picker to color your text a specific color. **4:** Inserting images: Your tooltip can also contain images. This can be done by clcikign the image icon.

## Additional Options On the main screen there are general options for tooltips that apply to all of the tooltips. These options determine the appearance and style of the tooltip.

**Let tooltip follow mouse**: Clicking on the makes the tooltip follow the mouse instead of appear and remaing stationary. **Make tooltip interactive:** Selecting this option allows the user to copy text inside of the tooltip. **Padding**: Determines padding of the tooltip. **Font Size**: Font size of all the text inside of the tooltip by default 12px. You can also change the font text size of each separately by highlighting the text and then using the font size dropdown menu to change the font size value. **Font weight**: Determines the boldness of the text inside the tootip by default something. **Background Color**: Determines the background color of the tooltip, by default white. **Font Color**: Determines the Font color of the tooltip, by default black. **Border Color**: Determines the Border color of the tooltip, by default grey. # Selective Aggregation In SuperTables you can use selective aggregation to aggregate only certain rows based on a condition. Selective aggregation instead of aggregating over all rows in a group, it aggregates based only on rows where a column has valid values, by using a flag system that can be setup by the user to determine valid values. 1 for valid values and 0 for invalid values. To set up selective aggregation in SuperTables, follow these instructions: 1. **Prepare Your Worksheet**: Ensure your worksheet contains atleast one column with values (e.g., 1s for rows to aggregate and 0s for rows to leave unaggregated). 2. **Set the Column as a Dimension**: Configure this column as a dimension in Tableau, and set its data type to "String". 3. **Open SuperTables Configuration**: Navigate to the SuperTables configuration settings. 4. **Assign the Aggregation Flag Column**: Select the column you want to apply selective aggregation to, and set the "Column Flag" to the column with 1s and 0s. 5. **Set Aggregation Type**: For the measure you want to aggregate, choose the "Selective Aggregation" option under the aggregation type. 6. **Apply to Multiple Columns**: Repeat the steps for multiple columns if needed, following the same process. The video below explains the whole process for 1 column but selective aggregation can be used with multiple columns.

{% file src="/files/1jvf2K82ZyE8kgBkXt1b" %} # Wildcard search in any group When working with inline filters, a common requirement arises: enabling users to search across all levels within a hierarchical structure. In scenarios where there are multiple nested levels—such as the 15-level hierarchy in question—it becomes limiting when only one level can be filtered at a time, as shown in the current implementation. A practical use case highlights this challenge: users might want to search for a specific term like "Person A" without needing to know which hierarchy level contains that value. Ideally, the filtering experience should be seamless and level-agnostic for the end user. Below workbook contains an example that solves this challenge based on a Tableau Parameter and Tableau filter on the datasheet. {% file src="/files/CI6xkVvymMo6eB3ezpPC" %} # How to create a Sparkline #### Step 1: Open Configuration {% tabs %} {% tab title="Dashboard extension" %} Click on the container that has SuperTables running. This will display an arrow that you can click to open a menu. Upon opening the menu, click the 'Configure...' option to open the configuration panel for SuperTables.

{% endtab %} {% tab title="Viz extension" %} To open the configuration panel, simply click 'Format extension' in the Marks pane.

{% endtab %} {% endtabs %} #### Step 2: Navigate to the Data tab

#### Step 3: Creating a Sparkline Expand the '**Sparklines**' panel and click on "Make a sparkline" to open the Sparkline configuration panel.

#### Step 4: Configuring the Sparkline To configure a Sparkline, give it a suitable display name then select the type of Sparkline you want to display in the cell, the aggregation type you want to aggregate the measure value by, the x-axis and the y-axis.

If you choose a field of type to be one of the axis then a Date Filter panel will be displayed:

**Note: When you choose a field of type Date on one of the axis it is recommended to use the Date Filter function. The guide about Date Filtering can be found in** [Sparkline Date Filtering](/supertables/configuration/configuration-screen/data-tab/sparklines-pane/sparkline-date-filtering) #### Step 5: Click 'Apply' to save and create the Sparkline

**Note: The Sparkline will only be rendered when a different field is added to the row group. It will not render when grouping is done using one of the fields already configured for the Y or X axis.** ### General tips * When using a Sparkline it is recommended to increase the **Row height** to clearly display the Sparkline as shown in the screenshot in [#step-5-click-apply-to-save-and-create-the-sparkline](#step-5-click-apply-to-save-and-create-the-sparkline "mention") * When using a field of type Date, it is recommended to enable the Date filter configurator to configure what dates can be used in the axis. This results in the Sparkline looking neater especially when using the Line and Area Sparkline types. # Custom Portal integration In this guide we show you how to create a custom portal integration with export buttons and redo/undo capabilities. This guide is written for customers that embed a SuperTables in a custom portal and want to utilize the powerful features of SuperTables from the portal interface like exporting to Excel. ## Example video {% embed url="" %} {% file src="/files/z8GG8d1a7eNYhCd8MDpn" %} Step 1: Tableau Desktop First create a dashboard with a SuperTables with the following settings: A string **parameter** called: stateparameter A string **parameter** called: switcher

#### General Settings Use the following settings in **SuperTables**

#### Appearance -> Use a parameter to switch between layouts select the switcher **parameter** as a parameter in the dropdown.

## Step 2: Set up the custom portal code Download our example file to create a basic looking portal with custom buttons. {% file src="/files/QZvJQvZuDI0qA3YsclTu" %} Update the following values in the html file: * the **src** value in \ to the url of you workbook

* **stateParameterName** to the name of the parameter name you use for the state parameter * **switchParameterName** to the name of the parameter name you use for the layout switcher. * **extensionURL** to the url where SuperTables is hosted.

## Step 3: The result

# Support ### Have a question about this product? We encourage you to browse our [FAQ](https://appsfortableau.infotopics.com/support/faq/) for quick answers.\ If you can’t find what you're looking for or have a feature request, feel free to visit [support](https://appsfortableau.infotopics.com/support/contact-support/) on our website or contact us at **** # Accessibility FAQ SuperTables has a mode for enhanced accessibility and Using enhanced accessibility mode, all rows and columns will be rendered in DOM, even the rows and columns which are not visible on the screen. Following are the questions you might get if you use tools like axe dev tools to assess the accessibility of SuperTables.

Why does my page not have a level one heading?

***ARIA Rule : Page must contain a level-one heading*** Generally, it is a best practice to ensure that the beginning of a page’s main content starts with an **h1** element, and to ensure that the page contains only one **h1** element. However, ARIA Standards also mention that in the case of iframes, the heading can be an <**h2**> or <**h3**> so we have added an invisible heading, which tells the screen readers that it is the SuperTables container.

Why certain elements do not have an ARIA parent role?

***ARIA Rule: For every column header ARIA parent role must be added.*** By default, SuperTables has a column header’s role described as role=”columnheader” - element containing a column header. For all the member cells there is an ARIA-Describe By tag which explains where it belongs. However, even though all aria tags have been applied to the necessary elements, some screen readers have trouble navigating the tags when the grid structure gets more complex (eg. grouped columns). This is the reason why there are some limitations in announcing the correct column names.

I cannot find the landmarks for some elements?

***Aria Rule: landmarks to element*** Navigating a web page is far simpler for screen reader users if the content splits between multiple high-level sections. Content outside of sections is difficult to find and the content’s purpose may be unclear. However, in this case, SuperTables stand as one single element instead of website where contents are spread of multiple sections. All elements in SuperTables have a role attribute which describes what it is, see the image below. [![SuperTables Role Attribute](https://appsfortableau.infotopics.com/wp-content/uploads/2022/07/Role-Attribute.png)](https://appsfortableau.infotopics.com/wp-content/uploads/2022/07/Role-Attribute.png)

Does the SuperTables element in the screen have an identifier?

***ARIA Rule: A Main landmark should be available in the SuperTables structure*** Screen reader users can use keyboard shortcuts to navigate directly to the first h1, which, in principle, should allow them to jump directly to the main content of the web page. If there is no h1 or if the h1 appears somewhere other than at the start of the main content, screen reader users must listen to more of the web page to understand its structure, wasting valuable time. To tackle this issue we have added an invisible heading which will help the screen reader to easily recognize the SuperTables container.

How do I optimize SuperTables for accessibility?

***ARIA Rule: configuration option to enable/disable Accessibility optimization for the grid*** You can use the “Enhanced accessibility option” if you wish to optimize SuperTables for accessibility. It in general disables the column and row virtualization. This as result generates all cells in the DOM thereby you will see a considerable reduction in performance. There may be 2 scenarios when you may wish to disable column virtualization (if you prefer). 1\) [Auto-sizing](https://www.ag-grid.com/javascript-grid-resizing/#auto-size-columns) of all columns. This will ensure that all columns, and not just the columns which are rendered on the screen, will be resized. 2\) Support for a11y. This is to prevent any potential issues with keyboard navigation and screen readers (https\://[www.a11yproject.com](https://www.a11yproject.com/)/).

Accessibility audit shows missing ‘Main roles’ which helps users to skip sections.

***Aria Rule: Bypass repeated blocks by setting the role to “Main”*** Since websites often display secondary, repeated content on multiple pages (such as navigation links, heading graphics, and advertising frames), keyboard-only users benefit from faster, more direct access to the primary content on a page. This reduces keystrokes and minimizes associated physical pain. Since SuperTables is just one page and there are navigation shortcuts to move around. This does not affect the accessibility of SuperTables.

Are there other general limitations to accessibility in SuperTables?

***Navigation to pinned rows/columns*** Screen readers assume that the visual and DOM element order are identical. Specifically, when you pin a row/column, it causes elements to be rendered in different containers. This is why you cannot use screen readers to navigate into pinned row/column cells, as in fact, this means they’re rendered in a different element from the rest of the columns/rows which are scrollable. ***Limitations announcing the correct column name in grouped columns*** Even though all aria tags have been applied to the necessary elements, some screen readers have trouble navigating the tags when the grid structure gets more complex (eg. grouped columns). This is the reason why there are some limitations in announcing the correct column names. ***No announcements of state change of a grid cell or grid header*** Some screen readers will not recognize changes that happen to an element that is currently focused (including children of this element). So in order to detect changes (eg. sorted state, updated labels, etc…), you will need to move focus to another element and back.

Why is my comment text in Supertables showing as one continuous block without line breaks?

To display line breaks, bold text, titles, and other formatting in Supertables, follow these steps: 1. Enable the **Rich Text (WYSIWYG)** editor for the comment field in WriteBackExtreme. This allows you to enter formatted content with line breaks.![](https://docs.infotopics.com/~gitbook/image?url=https%3A%2F%2F3888808431-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FMzOBMgQCQmnHEY9CGpbe%252Fuploads%252F3Wd0naga8shxyX3EJVGn%252Fimage.png%3Falt%3Dmedia%26token%3D8919bbf4-a3c9-40fc-b6ba-96c804a69acf\&width=300\&dpr=4\&quality=100\&sign=8aadb420\&sv=2) 2. In your Tableau dashboard, configure the comment dimension to use the **HTML** format. Go to: Dimension format → Dimension style → Select HTML ![](https://docs.infotopics.com/~gitbook/image?url=https%3A%2F%2F3888808431-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FMzOBMgQCQmnHEY9CGpbe%252Fuploads%252FKvcmUBWQqpf62knfTTxA%252Fimage.png%3Falt%3Dmedia%26token%3D15440822-909b-42fb-af90-d5bc16c91f69\&width=300\&dpr=4\&quality=100\&sign=28b4e027\&sv=2) 3. The comments will now display properly in Supertables with line breaks and formatting: ![](https://docs.infotopics.com/~gitbook/image?url=https%3A%2F%2F3888808431-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FMzOBMgQCQmnHEY9CGpbe%252Fuploads%252F96BdX6rGglRq9nV0xI2k%252Fimage.png%3Falt%3Dmedia%26token%3D5044d2f5-7d59-4058-93c0-181dfcb4642e\&width=768\&dpr=4\&quality=100\&sign=12b88585\&sv=2) Your comments will now be displayed in a user-friendly, formatted way within Supertables.

# Glossary # WriteBackExtreme

What can I help with?

Welcome to the comprehensive documentation for WriteBackExtreme. This documentation serves as your go-to resource for understanding, installing, configuring, and troubleshooting our product. **Quick Reference Links:**


Getting started	If you are new to WriteBackExtreme, our Quick Start Guide is highly recommended to help you get started instantly	/pages/9ARqg0UQ7Rnqb0cBxyj7
Features	To explore everything WriteBackExtreme has to offer, visit our Features page for a complete overview of its capabilities.	/pages/xL1lR5XCJPmJF5wYz6QZ
Configuration	For detailed guidance on configuring WriteBackExtreme, visit the Configuration page.	/pages/7MHH2yPQeBdWhvh5ShLK
Support	If you have questions or need assistance, our Support page is here to help you move forward.	/pages/QiEnb2AIEafuJMlKonD5

Whether you are a new user looking to get started or an experienced user seeking advanced configurations, this documentation provides step-by-step guidance and insights to help you maximize the benefits of WriteBackExtreme. If you encounter any difficulties or have questions, our support team is here to assist you. Enjoy exploring and enhancing your experience with WriteBackExtreme! # Release Notes ## WriteBackExtreme 4.0 ### User Roles for Management Console Introducing User Roles enables you to specify the role assigned to each user, thereby allowing you to control their actions within the management console. For instance, the Schema Manager is granted permission solely to oversee their respective schemas. The roles introduced include Schema Manager, Connection Manager, User Manager, and Administrator. ### Groups based access for connections By implementing group-based connections, you can determine which groups are granted access to specific connections. In the Management Console, users will only see their assigned connections and schemas. This feature helps with a seamless integration of WriteBackExtreme within your organization, ensuring that departments are not exposed to each other’s connections and schemas. ### Multi site support for Tableau User Sync and more We’ve incorporated the ability to choose multiple sites from your Tableau Server when synchronizing users with WriteBackExtreme. This allows you to mirror the existing structure on your Tableau Server. In cases where you’re syncing from multiple sites, group names will now carry a prefix corresponding to the site name.

### New bulk import with support for Excel files We have entirely revamped the bulk import module within the extension. Now, you have the flexibility to choose any Excel file for import. This enhanced bulk import module facilitates the mapping of Excel columns to the appropriate columns in WriteBackExtreme. We have also enhanced the feedback mechanism for identifying missing cells or incorrect values, ensuring a smoother import process. ### A fresh look & feel (Extension) We understand space is an issue in dashboards. Therefore we optimized the whole extension and made it more compact / dense. Besides that we added many new options to change the layout of the table, form and collaboration addon. You can find all the new options in the upgraded form builder. We are curious which new UI improvements you can find! ### More insights in user activity We already have the ability to look at changes/history of a record in the extension and we expanded this capability with insights in the Management Console. Visit the new Audits page in the management console or look at the audits tab when you view a schema in the management console. There are filters to help you find the audit record(s) you are looking for. ### Preview Data in Management Console With the new preview data feature you can browse the data in your schema directly in the management console. You can use this to understand what data is in the schema. There is an option to impersonate a user which can support you to enable Row Level Security. ### Data Correction enhancements Data Correction got a massive update, we added full writeback capabilities to this module. With the new + button you can easily add a new record without the need to select a Tableau datapoint. We also added the option to remove a record. Besides that we changed the interface drastically with a new table layout and other alignment and UX enhancements. Data Correction will use less space and gives you all the freedom to create an excel-like experience in your dashboard.

### Select which datasources to refresh We added the ability to select which datasources you want to refresh after a WriteBack action. This will improve performance significantly as you are no longer refreshing unneeded datasources. Select any datasource present in the dashboard you like, even datasources which have no relation with WriteBackExtreme!

### Wait, there is more! ### Extension: * Added the option to set the width of columns in tables. * Added the option to display a logout button. * Added the option to set text color in the Rich Text Editor. * Added the option to change the inactivity timer in seconds, allowing automatic user logout. * WriteBackExtreme has been made more compact. * Modified default value behavior to only populate with the first value of a worksheet when it is different from the worksheet connected to the schema, preventing unexpected | separated default values. * Improved display of relevant values in WriteBackExtreme when using multiple schemas connected to the same worksheet. * Enhanced the generation of multiple records when no marks are selected. * Updated the Rich Text Editor with a new layout and added features. * Improved the layout of tables. * Enhanced the layout of dynamic value configuration. * Better positioning of the configuration button. * Improved alignment of rich text fields in the overview. * Refined the layout of radio button fields. * Enhanced the layout of checkbox fields. * Improved rollback functionality for data correction. * Refreshed the rollback page layout. * Enhanced stability of configure conditions for adding and editing rows. * Updated the almost expired license message and layout. **DataCorrect Enhancements:** * Made the layout denser and cleaner. * Added the option to create records, which can be enabled in the configuration. * Introduced the option to delete records, with a new permission per schema required. * Added the option to set the width of a column in pixels. * Fixed column widths in the vertical layout. * Enabled updating multiple records simultaneously when the relationship is at a higher level. **Collaboration Enhancements:** * Added the option to hide the 'created at' and 'created by' properties in comments. * Columns in the overview will now respect configured column widths. * Fixed the 'select all' button not working correctly with editable conditions. **Bug Fixes and Optimizations:** * Fixed an issue where hidden fields were not dynamically populated with the correct values. * Optimized caching for worksheets containing the username. * Removed icons in front of Date fields for a cleaner appearance. * Optimized the layout of small message popups. * Removed the minimum required characters for schema label. * Fixed console warnings. * Improved RLS (Row-Level Security) for history overview. ### Management Console: * Simplified SSO (Single Sign-On) configuration. * Enhanced error insights for faulty IdP (Identity Provider) SSO configurations. * Improved rollback permissions scope for Data Correction. * Added Multi-Site Tableau Synchronization. * Improved column detection in Oracle databases. * Users and groups not active in Tableau will be removed after synchronization. * Default casting for new Snowflake connections is now set to uppercase. * Added encryption and `trust_server_certificate` options for SQL Server connections. * Enhanced scrolling experience when adding users to a group. * Removal of users from the group `Everyone` is now disabled, ensuring all users remain within. #### Security & Compliance * Enhanced License Seat Verification. ### # Changelog To view the latest updates for WriteBackExtreme, please check our [changelog](https://dl.infotopics.com/changelog/writeback-extreme). # Architecture We have created an image to show the infrastructure of the WriteBackExtreme extension. This shows what actually happens when you call in your WriteBackExtreme extension to your dashboard. When the dashboard loads the extension, Tableau connects to the WriteBackExtreme Extension Server. This server provides the required JavaScript, HTML and CSS so the extension can render inside the dashboard. All rendering happens on the **client side** (Tableau Desktop or browser).\ Write-back actions, however, are handled by the Extension Server through API calls. To use WriteBackExtreme you need a Repository Database (supported database types are listed below), as well as a connection to the database where the WriteBackExtreme data will be stored. In most cases this is already part of your existing infrastructure—your standard data sources used for Tableau reporting. Whitelisting/Safelisting of the Extension Server URL needs to be done on Tableau Server/Tableau Online to allow communication with the extension server for users visiting your published dashboard. Communication with the WriteBackExtreme extension server will only take place from the client side (whether it is Tableau Desktop or a visitor of a published workbook in the browser). As already mentioned, rendering of the extension will also take place in the dashboard (client side). ### WriteBackExtreme SaaS

### WriteBackExtreme On-premise

### Where does the write back data live? WriteBackExtreme can connect to multiple databases, depending on the connections you configure in the Management Console. The **Connections** tab in the management console shows which database drivers are available. If you need a driver that is not listed, please contact support. Write-back data is stored in the databases that already exist in your own infrastructure—the same data sources commonly used in your Tableau environment. When you create DATA Helper or ADD Data schemas, the extension automatically creates the required tables in your selected database. Any changes you make to the schema in the Management Console will also update the corresponding tables. Because this process is fully automated, we strongly recommend **not** modifying these tables manually, and instead to do all changes through the Management console of the extension. If you want to change data that already exists in your own tables, you can use the **DATA Correction** module. This module connects directly to your existing database tables and does not create new ones. Keep in mind that DATA Correction updates your actual data! WriteBackExtreme can connect to multiple databases, but the data will always stay in the database you selected when you created the schema. ### Where does the data live for repository and which databases are supported? During installation, WriteBackExtreme sets up a dedicated Repository Database. This database is separate from your Write Back databases and is preferably installed on the same machine as the WriteBackExtreme Extension Server to avoid latency and performance issues. The repository serves as a central location for configuration, connection details (securely encrypted), auditing, and logging information. It does **not** store or process your business data—only metadata required for the extension to operate. Supported database types for the repository can be found here: {% content-ref url="/pages/V3dcYJZL20qpe5IDcdJp" %} [Supported databases](/writebackextreme/prologue/architecture/supported-databases) {% endcontent-ref %}
# Data handling and security in WriteBackExtreme (SaaS) WriteBackExtreme is designed with data integrity and operational transparency in mind. Here's how data is handled during the writeback process in our **SaaS deployment**: * **Data Transmission**: Entered data is passed directly to the configured target database during the writeback operation. * **Audit Trail**: A copy of the submitted data is stored in an **audit table** within the WriteBackExtreme repository database, providing traceability and accountability. * **Linked Mark Data**: When interacting with marks in Tableau (e.g., adding a comment), the extension stores references to these marks to preserve context. * **No Data Inspection**: WriteBackExtreme **does not inspect, log, or process** the content of user-entered data beyond storage for audit and linking purposes. * **System Logs**: Operational logs are collected (e.g., for error reporting), but **they do not include any user-entered data**. We understand the importance of keeping architecture secure and transparent. On our roadmap for this year, we plan to introduce a feature that allows both audit data and linked data to be stored **directly on the target connection database instead of our repository**. Once this is released, this will provide full control and transparency over where and how your data is stored. # Supported databases


	MySQL version 5.7, 8.0 or higher (Native, no additional driver installation needed)
	Microsoft SQL Server 2016 or later (Native, no additional driver installation needed)
	PostgreSQL version 14 or later (Native, no additional driver installation needed)
	Snowflake via ODBC or natively (Editing a schema is partially supported because of database limits)
	Amazon Redshift (Native, no additional driver installation needed)
	Oracle via OCI8 ^2.2.0 or 3.0 (Native, no additional driver installation needed)
	Google Big Query Keep in mind that GBQ has Quotas and limits. For example it is limited to 1500 Table modifications per day which makes it less usable for bulk imports.
	Databricks via ODBC
	Sap Hana via ODBC (Available from WriteBackExtreme 5.5)
	Teradata via ODBC
	Azure Synapse (Native, no additional driver installation needed) (Text fields are limited to 4000 characters)
	IBM DB2 via ODBC (Available from WriteBackExtreme 5.7)

# NEW: InputTables Available as a Dashboard and Viz Extension, InputTables enables functionalities such as **cell editing (audit), commenting** **and adding columns.** Capture input, store it in your trusted database and re-use it in the dashboard! Making **real-time** adjustments and annotations directly within Tableau will revolutionise **team** **collaboration**. This Extension is a **super hybrid solution** designed to maximize value for Tableau users. {% embed url="" %} ⚠️ **Important Deployment Requirement (InputTables)** When using **InputTables with SuperTables**, SuperTables and WriteBackExtreme must use the **same deployment model**. * SuperTables SaaS → WriteBackExtreme SaaS * WriteBackExtreme On-Prem → SuperTables On-Prem Mixed deployments (SaaS + On-Prem) are **not supported** and may result in connection errors. For details, see:\ --- [Next Page](/llms-full.txt/1)

Welcome to the Apps for Tableau documentation platform

What can I help with?

SuperTables

WriteBackExtreme

MailScheduler

InputTables

DashboardUsage

DrillDownTree

HierarchyFilter

MarginalHistogram

PictureThis

PowerKPIs

FinanceTables

ProcessMining

Scrollytelling

ShowMeMore

SuperTables

WriteBackExtreme

MailScheduler

InputTables

DashboardUsage

DrillDownTree

HierarchyFilter

MarginalHistogram

PictureThis

PowerKPIs

FinanceTables

ProcessMining

Scrollytelling

ShowMeMore

What can I help with?

What can I help with?