New

Improvements

• Added ability for users to cancel in-progress Notebook runs

• Surfaced more helpful error messaging in the SQL Editor when results exceeded database limit

• Added username to membership endpoint in Discovery API

• Added several fields to the reports and report stats endpoints in Discovery API

• Added a new table for active Report Subscribers to Discovery Database

• Added fields to surface whether WLE and external sharing is enabled for reports to the Discovery Database

Bug Fixes

• Fixed issue in the Mode SQL Tutorial where “See the Answer” links were returning an error message

• Fixed issue where some users with viewer permission for a report could see, but not interact with, the “Edit Schedule” button

• Fixed issue where the ‘Remove from Report’ button was not working in Notebooks

Bug Fixes

• Added specific warning messaging when the selected report filter values exceeds limit

• Fixed issue where users were unable to delete their Exploration when created from a Report for which they had view-only permissions

• Fixed an issue where deleted queries were persisted in Notebook

• Removed Explore button from externally shared Reports

• Fixed an issue where tab autocomplete was not functioning in Python 3 Notebook environments

Improvements

• Improved the GitHub integration to work with non-standard named default branches

• Added visibility to errors for past runs of a query from the Report’s details view

Bug Fixes

• Modified TRUNC calculated field function to match expected truncation behavior

• Fixed an issue where Notebook session would end upon navigation to another section of open report

• Fixed an issue where some reports in Mode Studio environments were not rendering correctly

• Fixed an issue where users experienced issues loading My Work and Collections when switching between My Work and Collections

• Fixed an issue where Mode admins accessing the Query Log page would experience page timeout

• Fixed an issue where the query results grid in the SQL editor would fail to display columns with certain special characters

• Fixed an issue where Pivot Table with 30K+ rows would redirect to a legacy line chart

• Fixed an issue where date filter would jump to previous day in calendar picker if computer time zone was set to Central European Summer Time

Improvements

• Updated the Mode Editor so that each query & visualization has its own route (URL) that can be used for easier collaboration.

• Added ROUND calculated field function

• Improved discoverability of min/max settings in visualization filters

• Added support for Apache Druid connections

• Updated supported versions of popular Python libraries available in the Python 3 Notebooks

• Added support for updated versions of database drivers and deprecated older drivers

Bug Fixes

• Fixed an issue where users trying to access reports in Personal spaces resulted in a blank loading page.

• Fixed an issue where Studio users could not move reports from their personal Space to open Space.

• Fixed an issue in Chart Editor where hover tooltip automatically rounds up to the nearest whole number.

• Fixed an issue in Explorations where report filters are applied to the “View Data” page, even after they have been removed from the visualization.

• Fixed an issue where the ‘Remove’ option did not work in scatter plots.

• Fixed an issue in which Filter Options were limited to 31.

• Fixed an issue where ‘null’ x-axis values were appearing as ‘Series 1’ in tooltips.

Improvements

• Updated Discovery API documentation to use ‘id’ instead of ‘token’ for clarity.

• Added a new API endpoint and documentation to purge all report results for a given data source connection.

• Made an enhancement so that users no longer have to re-enter their password in connection settings to disable the schema refresh for a connection.

New

Bug Fixes

• Fixed an issue in Query History in which the user could not view the error of a query that failed, unless it was the most recent run.

• Fixed an issue where report filters would only be partially applied to a report.

• Fixed an issue where the tooltip colors made text unreadable in some Mode themes.

• Fixed an issue with the API where admins were only able to return a list of spaces they were members of, instead of all spaces.

• Fixed an issue in Chart Editor and Report View where tooltip did not display correctly in charts with more than 2 measures on the same axis.

Improvements

• Updated versions of some of our most popular Python libraries (including pandas and numpy!) are available on Edge now. The full list of updated libraries is published on our Help site for easy reference.

New

Bug Fixes

• Fixed an issue with Calculated Fields where explicit boolean values in logical statements weren’t working correctly.

• Fixed an issue with Discovery API where pulling a list of reports returned a 503 error.

• Fixed an issue in the Chart Editor where the tooltip header would not adjust correctly based on formatting changes.

• Fixed an issue with Calculated Fields where comparing integers larger than 2^31 in an IF statement resulted in an error.

• Fixed an issue where users couldn’t filter integers larger than 64-bit.

• Fixed an issue where users without connection access were appearing in All Members list.

• Fixed an issue to ensure that users cannot delete a bridge with an active connection. Instead, they should create a new bridge, and update the connection, then delete the old one.

Improvements

• Added an endpoint for Report Stats to Discovery API, which allows users to pull information on number of active schedules, number of explorations, and emails of users who have run reports or scheduled report runs.

• Updated supported versions for plotly, chart-studio, plotly-geo, & cufflinks in Python 3.7 Notebooks.

New

Bug Fixes

• Fixed an issue where an error in an underlying query caused an incorrect error message to be displayed on the chart.

• Fixed an issue where admins were unable to re-invite pending users to the organization.

• Fixed an issue where the ‘Delete’ endpoint in the API did not remove queries correctly

• Fixed an issue in which the visualization filter displays the wrong end date upon reopening.

• Fixed an issue where the modal window closes when trying to copy or paste text into it.

Improvements

• Added support for Azure Synapse Analytics connections.

• Made an improvement to Calculated Fields to allow comparisons between similar data types

• Updated copy on error messages in Calculated Fields to make the errors more clear

• Made an improvement to allow users to open reports in a new tab using Cmd+click action from Spaces

• Made an improvement to allow users to enable automatic schema refresh on Snowflake connections.

New

Bug Fixes

• Fixed an issue where the user wasn’t able to sign in to a new Mode account.

• Fixed an issue where the user wasn’t able to connect to Databricks database to Mode.

• Fixed an issue with the Stats page so that it now shows the full range of data.

• Fixed an issue in line charts where tooltip displays “Week of” incorrectly.

• Fixed an issue where filters did not appear in WLEs, Internal Embeds and External Embeds.

• Fixed an issue where the ability to toggle the filter on and off in WLE was not working.

Improvements

• Updated Discovery API to include additional metadata for queries, charts, members, and reports. See linked documentation for details.

• Made an improvement to allow customers to choose how Mode connects to their database.

New

Bug Fixes

• Fixed an issue where users were unable to edit reports connected to a deleted datasource

• Fixed two issues where ‘Copy' button in Explorations mode converted datetime data types incorrectly

• Fixed an issue in the UI where connecting a new datasource would cause a red banner to display and the new source would not appear, despite being connected correctly

• Fixed an issue where moving reports between personal and other spaces caused reports to disappear

• Fixed a bug where rendering ‘No Results’ causes a persistent loading bar to appear in report view.

• Fixed a bug where certain reports would render a blank screen while loading

Improvements

• Made an improvement to PDF Export to minimize table widths and limit white space, allowing for more content to be displayed on the page.

• Made an improvement so that the browser tab now displays the name of an Exploration

• Added validation to prevent users from comparing different datatypes in Calculated Fields

• Updated Cufflinks on Edge for Python Notebooks

• Updated Plotly with support for Plotly Express on Edge for Python Notebooks

• Added filtering to the Discovery API to allow users to exclude reports, charts and queries from personal spaces.

• Added analytic functions to Calculated Fields

• Added ability for users to view Calculated Field formulas in both the Chart Editor

Feature Releases

• Released Explorations, a new feature to help analysts collaborate with end users.
• Released Calculated Fields, a feature that allows analysts to do post-SQL calculations
• Released Edge for Python Notebooks to provide a more seamless Python library update experience.

New

Bug Fixes

• Fixed an issue in SQL editor where SQL keywords would autocomplete even when ‘Make suggestions’ setting was turned off.

• Fixed an issue where declaring or setting variables in SQLServer incorrectly caused no rows to be returned.

• Fixed an issue where the “Archive/Delete” report was not working in private spaces.

• Fixed an issue where the “Report Links” setting could not be disabled when scheduling reports

Improvements

• Added blue as a stripe color for table visualizations.

• Made minor visual updates to context menus in SQL editor.

• Updated the API to surface “updated_at” timestamp for a Query

• Updated the API to filter report endpoints by datasource

Feature Releases

• Released SCIM Integration for Okta, available for Enterprise customers.

• Updated permissions framework and released Connection permissions, which allows Admins to control access at the data source connection level.

• Released a new API called Discovery API that lets developers pull clean lists of data resources, such as Charts, Queries, Spaces, and Reports.