Changelog

[5.4.2] - 16-05-2025

• Added support for unbalanced groups in pivot mode (removes the null groups automatically).
• Added support for PDF export in Pivot Mode.
• Added support for unbalanced groups when exporting to Excel in Pivot Mode.
• Improved grouping on date fields with empty values.
• Improved selective aggregation for pivoting.

[5.4.1] - 07-05-2025

• Improved URL Action config in interface.
• Changed the following to an option in the pivot configuration: When pivoting with only one aggregated column, the column header layout by is simplified by removing the measure row.

[5.4.0] - 01-05-2025

• Added support for Date fields in Calculations. You can now calculate with Dates For example DATE([Order Date]) - DATE([Shipping Date]) but also DATE([Order Date]) + [InputTables column] to create a due date for example.
• Added a new column type called combined columns. With combined columns you can merge multiple columns into 1 column. For example an image of a client with a Name in bold and job title in Italic below.
• Added support for column header and cell text styling to make one column appear different from the others with the following options:
  • Normal/Bold
  • Italic
  • Underline
  • Strike
• [InputTables] Improved writing comments to databases that uses uppercase column names only.
• [InputTables] Improved calculations with InputTables columns containing no data (null values).
• [InputTables] You can now create if-else calculations with InputTables columns.
• Improved calculations. If a value is NULL it is replaced it with a 0 so calculations won't break.
• Improved Dynamic Aggregation when re-using parameters in multiple SuperTables in the same workbook.
• Improved calculating header only changing the size of the column header and not the inline filter header.
• Improved auto header height when checkboxes are disabled.
• Improved multilanguage support, improvements to Spanish.
• Improved null values for HTML, Markdown and other special dimension styles.
• Improved Selective Aggregation with calculations.
• Improved exporting to Excel include 0 values.

[5.3.3] - 17-04-2025

• Improved Excel Export containing 0 rows.

[5.3.2] - 03-04-2025

• Added support for custom messages on the loading screen.
• Improved data fetching for InputTables.
• Improved the list of columns shown when pressing @ in a calculation.
• Improved calculations with null values.
• Updated default data fetching method to latest suggested by Tableau.
• Updated to Extensions API V1.12.1.
• Added backwards compatibility checks for 2023.x Tableau Servers due to issues in Extensions API.
• Improved the column sort order when adding and removing columns.
• Improved export to excel and copy to clipboard when there are line breaks in the cell content.
• Added option to switch the way export buttons are displayed on the table between icons and in a dropdown menu.
• Improved the auto Min/Max calculation feature for barcharts.

[5.3.1] - 22-02-2025

• Added support for Selective Aggregation columns in calculations.
• Improved new calculation engine in combination with filters.
• Improved default aggregation on dimensions and measures.
• Improved authentication check for InputTables.
• Improved calculation engine stability.
• Removed pivoting with only one aggregated column, the column header layout by is simplified by removing the measure row.

[5.3.0] - 19-02-2025

• Added persisted Group Expansion State: SuperTables now remembers which groups were expanded or collapsed. When you reopen the table, it restores your previous view. The expanded/collapsed state is saved in the table layout, so your layout remains just as you left it.
• Added support for using dimensions in calculations to create calculations like: SUM(Sales) / # of Customers.
• Added support for column value aggregations in calculations. Profit / Sales is normally done like: SUM Profit / SUM Sales. You can now change the value aggregation to do AVG(Profit) / MAX(Sales) or MAX(Sales) - MIN(Sales). Change the value aggregation in the table on column level and the calculations will update automatically with that aggregation type.
• Added an option to exclude null or blank groups from the Excel export.
• InputTables: Improved login procedure when using SAML.
• Improved auto sorting of pivot columns when using a Tableau filter.
• Improved scrolling performance.
• Improved initial rendering of table.
• Improved Pivot Mode with Selective Aggregation.
• Improved sorting of date columns using custom date formats.
• Improved re-rendering to prevent columns from switching.
• Improved re-rendering when using a layout switch parameter.
• Improved charting, fixed compatibility with older browsers.
• Improved re-rendering when using dynamic aggregation.
• Improved vertical alignment of cell content.
• Improved if-else calculation editor showing error when using dimensions.
• When pivoting with only one aggregated column, the column header layout by is simplified by removing the measure row.
• [viz-extension] Fixed showing landingpage when no data.
• Changed the loading message to 'Loading Data...'.
• Removed the separate pivot date format option in appearance. Date columns are now using the date format specified from the data pane when used as column label in pivot mode.
• Added backwards compatibility checks for 2023.x Tableau Servers due to issues in Extensions API.

[5.2.1] - 20-12-2024

What's Changed

• WIP 5.1.3 dev by @merlijnbuit in https://github.com/appsfortableau/supertables/pull/491

Full Changelog: https://github.com/appsfortableau/supertables/compare/5.1.2...5.2.1

[5.2.0] - 20-12-2024

• NEW Table Calculations:
  • Percent of Total: measures can now be represented as Percent of Total (PoT).
  • When grouping choose from Percent of Total based on grand total or on group total.
• Added option to change the icons color in the header.
• Improved using special space characters in cells like a tab character.
• Improved conditional coloring with calculations and null values.
• Improved using images from your dataset directly in Tooltips.
• Improved using dynamic aggregation when using list parameters in your supertable as well for calculations.
• Improved usage of dimensions / measures with () in the name on first load of a new SuperTables instance.
• Improved cell editing when allow multiple rows is disabled.
• Improved cell editing when using Crtl or Cmd and double clicking a cell.
• Improved OAuth login.

[5.1.2.1] - 26-11-2024

• Improved usage of dimensions / measures with () in the name.

[5.1.2] - 26-11-2024

• Improved usage of dimensions / measures with () in the name.
• Dependency upgrades of third party libraries.
• InputTables: Improved session management.
• Improved tooltips for SuperTables calculated fields.
• Improved 'Replace null values' option for dimensions.
• InputTables: Improved making a connection to Snowflake databases
• InputTables: Improved defining an existing column as dropdown or multi-line textfield
• InputTables: Improved formatting for number fields

[5.1.1] - 08-11-2024

• Improved the pivot sort order when using a date field.
• Improved thousand separator checkbox default value.
• Improved the front-end calculations in combination with the InputTables.
• InputTables: Limited existing schemas selector to schemas that were created by InputTables.
• InputTables: Added confirm message when switching schema for commenting.
• InputTables: Added legenda for visibility/merge indicators.
• InputTables: Limited connection selector for new schema to connections that have groups attached.
• InputTables: Added warning when connecting to an existing schema that has a non unique primary key.

[5.1.0] - 31-10-2024

• Added the option to show sub totals at the top of a group.
• Added the option to have sub and grand total rows stick to the top/bottom of the grid.
• Improved grand total at the top of the table.
• Custom Calculations with InputTables:
  • Enhanced the functionality of custom calculations to integrate well with InputTables.
  • Improved the rendering of total values when using custom calculations in combination InputTables.
• Excel Export:
  • Enhanced the Excel export conditional color feature for more reliable data export.
• Fixed the number of rows counter of a grouped row now hiding correctly.

[5.0.2] - 29-10-2024

[5.0.1] - 23-10-2024

• Added option so you can filter the grid based on the group row aggregated values.
• Improved total row pinned to top not updating aggregated values.
• Improved datetime formatting.
• Improved grouping on columns.

[5.0.0] - 22-10-2024

• Added InputTables: Type directly into a table within Tableau, comment on cells, and add new columns.
  It has never been easier to start with write-back in Tableau with an Excel look and feel.
• Added cell editing
• Added cell editing audits
• Added commenting on cells

[4.3.0] - 09-10-2024

• Added a new aggregation method for dimensions: List of Items. Showing a comma separated list of all the members in the column when grouping/pivotting: Item A, Item B, Item C.
• Added error handler when requesting too much data and Extensions API stops working.
• Improved aggregation on dimensions.
• Made the 'no data' message more subtle.
• Improved exporting of percentages to Excel.
• Improved selective aggregation with possible null values.
• [Enterprise Only] Improved license check for on-premises.

[4.2.2] - 02-10-2024

• Improved event listeners for VizExtension.
• Improved switching columns for VizExtension.
• Improved support for Dynamic Aggregation and group columns.

[4.2.1] - 12-09-2024

Small Improvements.

[4.2.0] - 10-09-2024

• A brand new configuration UI!
• Added Excel hyperlinked cells if they are hyperlinked in SuperTables.
• Added option to group the columns in the sidebar on dimensions and measures.
• Added option to hide new columns added to the datasheet.
• Added conditional formatting of text color to entire row.
• Added the option to automatically set the minimum and maximum values for a barchart.
• Added option to switch datasheet (worksheet) based on a parameter value.
• Added option to change vertical alignment of text when using fixed row height.
• Added aggregation options for formulas.
• Added alignment, formatting, and color options for formulas.
• Added option to expand or collapse pivot(s) using the context menu.
• Added a new aggregation function called 'Selective Aggregation' to conditionally aggregate values.
• Added menu option to reorder the columns in pivot mode.
• Added option to make the tooltip interactive.
• Added option to set the header font size seperately from the font size of the cell per column.
• Added option to import/export workbook settings.
• Added option to fit columns to window.
• Added ABS(absolute) function in the calculations.
• Added loading icon when columns are being fetched in the config screen.
• Added resize functionality to SuperTables popup mode on Tableau Cloud/Server.
• [Enterprise Only] Support for images in the Excel export.
• [Enterprise Only] Added support for viz-extension trex files. (domain.com/trex)
• Improved header coloring for calculations.
• Improved grand totals in the top row.
• Improved suppress total not working in certain instances.
• Improved an issue with calculation columns not being colored in tableau and excel.
• Improved aggregated values of calculated columns when the aggregation is set to Sum/Avg....
• Improved floating export button(s).
• Improved row hover behaviour.
• Improved conditional formatting behaviour.
• Made parameter data more compact.
• Disabled hover effect on rows with conditionally formatted background colors.

[4.1.8] - 01-07-2024

• [Enterprise Only] Updated the encodings for Viz Extension.

[4.1.7] - 24-06-2024

• Added Viz Extension support for Tableau 2024.2 and later.
• New Landing page with GIFs to show how to get started.