What's New
The following sections describe new features and other changes available in each version of the AtScale Connector add-on for Google Sheets.
2.16.0
New features
Localization support
The AtScale Connector has been localized for French, in addition to English. The Connector automatically detects the preferred language set in your Google Account and updates all labels accordingly, so no configuration is required.
If your Google Account is configured to use a language other than English or French, the AtScale Connector defaults to English.
ATSCALE-28011
New Top and Bottom operators for filter conditions
You can now create filter conditions that return the TopN and BottomN results for the selected metric. Top results are sorted in descending order, while bottom results are sorted in ascending order.
To use this functionality, when creating a filter condition, set the operator to either Top or Bottom, then enter the number of results to display.
ATSCALE-49518
Refresh <sheet> button renamed to Update <sheet>
The Refresh <sheet> button has been renamed to Update <sheet> for clarity.
ATSCALE-50759
Data response size optimization
Responses from the AtScale engine have been optimized to remove repeated data. This reduces the overall response size and helps prevent the AtScale Connector from crashing.
ATSCALE-50130
Conditions on dynamic date filters now retained after refreshing the browser
Conditions set on dynamic date filters are now retained after the browser is refreshed or the AtScale Connector is re-opened.
ATSCALE-51402
Resolved issues
Apply Selected button was not visible at high zoom levels
When selecting a filter range from a spreadsheet, the Apply Selection button was not visible if the user was zoomed in on their browser. This issue has been resolved: The Range section of the filter panel now becomes scrollable when the browser is zoomed in.
ATSCALE-51030
Filter panel buttons appeared inactive
The Cancel and Save Filter buttons at the bottom of the filter panel appeared to be inactive, even when they were clickable. This issue has been resolved.
ATSCALE-50756
Numeric attributes were rendered as text in pivot tables
The AtScale Connector rendered numeric attributes as text in pivot tables. This caused errors when the locale for a sheet was changed from one that uses periods as decimal separators to one that uses commas, as the separators were not properly converted. This issue has been resolved: Numeric attributes are now rendered as real numbers.
ATSCALE-49664
Issues with filter selection using spreadsheet ranges across multiple sheets
If the user selected a range of filter values from a secondary sheet and applied them to the pivot table in the main sheet, the AtScale Connector remained focused on the secondary sheet, rather than returning focus to the main sheet. Additionally, the Update <sheet> button sometimes displayed the name of the secondary sheet, rather than the main sheet. These issues have been resolved.
ATSCALE-51030
2.15.0
New features
Leading zeroes in dimensional data now display in reports
The AtScale Connector now allows reports to display leading zeroes in dimensional data. This ensures data such as postal codes and similar values display correctly.
ATSCALE-45215
Active filter values now display above pivot tables
All active filter values now display above pivot tables in a new Filters section, enabling you to easily see all filters currently applied to your data.
This functionality is disabled by default. To enable it, open Settings, enable the new Show active filters above the table option, then click Update Table.
ATSCALE-47526, ATSCALE-49750
Filter configuration enhancements
Filter configuration has been enhanced, featuring new styling and improved workflows when selecting and sorting filter values.
ATSCALE-48831, ATSCALE-49341
Metadata warnings when switching sheets
If you switch to a different sheet and attempt to update it without syncing the metadata in the AtScale Connector panel, a popup now appears, from which you can either sync the metadata to the new sheet, or return to the previous sheet.
ATSCALE-41561
Data parser optimization
The AtScale Connector's data parser has been optimized to better handle large responses from the AtScale engine and prevent the add-on from crashing.
ATSCALE-49748
Resolved issues
Dimension-only queries took a long time to process
Dimension-only queries took a long time (several minutes) to process. This issue has been resolved.
ATSCALE-45133
AtScale Connector displayed confusing error messages when users did not have access to models
When a user opened a sheet connected to a model they no longer had access to (or that had been renamed or deleted), the AtScale Connector displayed a confusing error message. This issue has been resolved: When a user tries to access a model they don't have access to, the AtScale Connector now displays an error clearly stating that they don't have access.
ATSCALE-45213
Changes to column order were not reflected in pivot table headers
When report columns were reordered in the Columns section of the AtScale Connector panel, the column data updated accordingly, but the table headers remained in their original positions. This issue has been resolved.
ATSCALE-45400
Combining Dynamic Date filters with Condition filters on metrics produced incorrect results
Combining a Dynamic Date filter with a Condition filter on a metric produced incorrect results. This issue has been resolved.
ATSCALE-50158