Super Table
The Super Table has a breaking change on Sisense version L2025.3.0.165. Upgrading the Sisense version to L2025.3.0.175 will resolve the issue.
The Super Table delivers a new pivot table – combining customization, interactivity, and high-performance. With advanced sorting, dynamic filtering, intuitive drill-downs, and rich visual customization, it empowers designers to build highly functional dashboards while ensuring viewers can explore and interpret data effortlessly.
Release Notes for Super Table can be found here.
Installation and configuration
The Super Table plugin can be installed by an Admin, following the directions in Installing QBeeQ Plugins.
Operating system and version support:
- Linux - Latest
- Windows - Latest
Configuration file
The Super Table uses a config.js file to configure additional options, such as:
- Adjust font size, weight, and colors
- Define button background and text colors
- Specify a replacement for zero values
- Adjust the row query limit per page
- Assign icons to specific values
- Enable a loading screen when embedding the dashboard
To locate this file:
- Go to the Admin tab > App Configurations > File Management
- Click the plugins folder > QBeeQ AdvancedExpandablePivot
- Open the
config.jsfile
You can edit the file's code directly in the user interface.
Creating a new Super Table
To create a new Super Table:
- Choose QBeeQ Advanced Expandable Pivot from the widget dropdown list
- Select data in the data panel to display as Rows, Values, and Columns
- Click the checkmark button to render the data
- Define how data is displayed
- Configure field visibility in the Data Panel
- Configure basic and advanced settings
Select data in the data panel to display as Rows, Values, and Columns
- Add at least one dimension to the data panel as a column
- Add at least one measure to the data panel as a value
- Add additional data to the data panel as needed
- Click the checkmark button to generate the Super Table preview
You must add at least one dimension as a column and one measure as a value to generate a preview.
Configure field visibility in the Data Panel
You can control the visibility of data by restricting either rows or columns, but not both at the same time. You must select at least one field in each of the following categories:
- A row
- A column
- A value
Restricting rows has other impacts on functionality.
- Open the Data Panel and navigate to the 3-dot menu next to either a row or column dimension
- Choose Restrict to Column or Restrict to Row
Define how data is displayed
The Super Table inherits and respects the native Sisense formatting settings applied to columns, rows, and values. This ensures consistency with your existing dashboard design and data formatting preferences.
- Open the Data Panel and navigate to the 3-dot menu next to either a row or column dimension to access additional display settings:
- Show Subtotals: Enable subtotals for a selected dimension to provide summarized rollups
- Hide Subtotals: Optionally hide subtotals for a specific value, even if enabled at the dimension level
- Set as Guess Value: Mark a specific value (e.g., Finance metrics like
IXRorIXXR) as a “guess” value to help distinguish estimated figures from actuals
Display values with color
The Super Table will use the native value colors and/or conditional color formatting assigned in the Data Panel. Clicking on the 3-dot menu for each dimension, Designers can apply the assigned value colors to:
- None
- Text
- Background
Display row values as hyperlinks
You can display row values as clickable hyperlinks, which open in a new browser tab when clicked. This feature is only available for rows, not columns or values. You can enable links on as many rows as needed for your use case.
The dimension must first be restricted to the Rows panel for the link option to appear. Only the dimensions that have been restricted will be visible for selection
The URL must exist in the data model as a dimension
To display row values as hyperlinks
- In the Data Panel, select a dimension.
- Click the 3-dot menu and choose Restrict to Rows.
- Click the 3-dot menu again and select Enable Link.
- Choose the dimension that contains the URL you want to use as the hyperlink.
If you're adding links to multiple rows, first restrict the rows for all the values you want. Then, apply the links.
Display values as sparklines
This feature is only available for version 2025.06.18 or later
Values can be displayed as sparklines within the table.
To add data as spark lines to your Super Table:
- Select one or more timedate dimensions as a Sparkline Item in the Data Panel
- Select a Value dimension in the Data Panel, and click the 3-dot menu
- Click Sparklines and select options
Setting | Description | Options |
Sparkline Type | Type of visualization shown in the cell | Area, Column, Line, Smooth Area, Smooth Line |
X-axis | Show or hide the X-axis | On
Off |
Markers | Highlights key data points | Start & End
Min & Max |
Examples
Display images or icons in the table
You can visually enhance your table by displaying images or certain values as icons.
To display images or icons in the table
- Click the 3-dot menu on the desired dimension or value
- Select Display icon or Display Image
The Display image option only appears for dimensions restricted to Rows. Icons can be used more broadly, including in the Values panel.
Description | Availability | |
Images | Use image URLs stored in your data model. Images will be rendered directly in the table. | ⚠️ Only available for Row dimensions that are restricted to Rows. |
Icons | Use icon files stored in the plugin's folder and defined in your config.js file | Available for Row dimensions
and Values |
Use appropriately sized images (e.g., thumbnails or favicons) for optimal appearanc
Configure basic settings - UI
This section allows you to customize and control how data is displayed and manage which controls are visible and accessible to users. Each setting is binary, giving you a simple toggle to enable or disable features according to your preferences or requirements.
Setting | Description | Behavior |
Field Chooser in Viewer Mode | Controls the visibility of the dropdowns, allowing the Viewer to select and de-select categories and values and “edit” the pivot | When enabled, the configured drop downs will display at the top of the table. |
Swap rows and columns | Allows users to switch values from columns to rows, changing how data is structured in the table. | When enabled, a “Swap” button appears.
⚠️ If certain rows or columns are restricted, they remain in place while the rest of the values are swapped. |
Transpose values | Allows users to flip the table layout by swapping columns and rows while keeping the values in place. | When enabled, a “Transpose” button appears. |
Display export to XLS | Provides an option to export the table data to an XLS file
| When enabled, the XLS export button is visible to Viewers.
|
Display export to CSV | Provides an option to export the table data to an CSV file | When enabled, the CSV export button is visible to Viewers |
Configure basic settings - Layout
Control how your Super Table is displayed when the dashboard loads. These settings affect row grouping, sorting, expansion behavior, and layout structure.
Setting | Description | Behavior |
Totals Before Data | Moves the grand total row | When enabled, the grand total row is displayed at the top fo the table.
When disabled, it is displayed at the bottom. |
Compact Layout | Controls how row groupings are displayed | When enabled, all grouped items appear in a single column—even when expanded. |
Auto Expand Rows | Controls whether rows are expanded or collapsed by default when the dashboard loads. | When enabled, all row groups are expanded. (Known issue: may require rework) |
Auto Expand Columns | Controls whether columns are expanded by default. | When enabled, all column groups are expanded. (Known issue: may require rework) |
Use Custom Sorting | Allows sorting based on user-defined order rather than default values. | Disabled by default; enable to apply custom-defined sort orders. |
Configure basic settings - Data
These options control how data is calculated, displayed, and formatted within the Super Table.
Setting | Description | Behavior |
Row Grand Totals | Controls the visibility of grand totals for each row. | When enabled, totals are calculated and shown at the end of each row. When disabled, row totals are hidden. |
Column Grand Totals | Controls the visibility of grand totals for each column. | When enabled, totals appear at the bottom (or top) of each column group. |
Show Zero Values | Controls how 0 values are displayed in the table. | When disabled, 0 is replaced with a dash (- by default). You can customize the replacement in the config file using dataZeroReplaced: '-'. |
Append Text to Value | Adds text units (e.g., mc, cm, %) to numeric values, helpful when certain formats aren’t natively supported. | Applied individually to each selected Value field in the Data Panel. |
Configure advanced settings
This section lets you manage the fields displayed in your pivot area. When configured, these fields appear in the top-left corner, clearly showing which dimensions are assigned to rows or columns, as well as which data fields are in use.
Setting | Description | Behavior |
Displays Fields | Determines whether the Super Table shows all available fields that can be used in the table configuration | When enabled, all available fields (data, row, column, and filter) will be displayed in the field list. Users can interact with these fields to customize the Super Table’s layout and contents |
Data Fields | Controls the visibility of fields currently assigned to the data (value) section of the pivot table | When enabled, only the fields used for displaying aggregated data (e.g., sums, averages) will be shown. Other field types (row, column, and filter) are hidden. |
Row Fields | Determines whether fields assigned to the row labels are displayed | When enabled, only the fields designated as row fields will appear, allowing users to focus specifically on the rows in the table. |
Column Fields | Controls the visibility of fields assigned to the column labels of the pivot table | When enabled, only the fields designated as column fields will be shown. This is useful for configuring or analyzing the column structure independently. |
Header Word Wrap | Wraps text within cells to accommodate long strings without truncation. | When enabled, long text strings automatically wrap to fit within the cell boundaries, preventing overflow or truncation. When disabled, text may be truncated or cut off |
Enable Sort | Enables or disables sorting functionality for any field in the pivot table | When enabled, users can sort rows, columns, or data fields in ascending or descending order. When disabled, all sorting options are removed. |
Enable Sort by Totals | ||
Custom grand total text | ||
Query Settings - Count | Defines the number of results displayed on each page | |
Null Field Color | Allows users to choose how NULL (missing or undefined) values are visually highlighted in the pivot table | When configured, NULL values in the pivot table are displayed with the selected color. |
Minimum row width | ||
Minimum column width | ||
Grid Height | Defines the vertical height (px) allocated to the pivot table grid. | When adjusted, the pivot table's height changes, affecting how much data is visible without scrolling. Increasing the height shows more rows, while reducing it creates a more compact display. |
Enable State Storing | Saves each user’s preferred settings and restores them upon login. | When enabled, a users changes/customizations to the their changes will remain intact when they log back in or refresh the page.
When disabled, users can still drag, drop, and modify the pivot structure during their session.
⚠️ Their changes will not be saved and will reset to the original published state after a page refresh. |
Negative Formatting | Applies standard financial formatting to negative values displayed in the pivot table. | When enabled, this setting formats negative numbers using common financial conventions:
• Displays negative values in parentheses (e.g., (1,234.56))
• Highlights negative amounts using a distinct color (e.g., red) |
Value Color | ||
Grand Totals | ||
Sub Totals | ||
Row Headers | ||
Column Headers | ||
Header Text | ||
Data Text |
Jump to Dashboard (JTD)
Jump to Dashboard is a native Sisense feature that creates shortcuts from a widget in one dashboard to another widget in another dashboard via a new browser tab or a pop-up window.
Setting | Description | Behavior |
Enable Jump to Dashboard | ||
Drilled Dashboard ID | See Jump to Dashboard documentation for more information about prefixes. https://docs.sisense.com/main/SisenseLinux/jump-to-dashboard.htm | |
Jump to Dashboard Navigation | ||
Jump to Dashboard As Link |
Last updated on August 4, 2021