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.

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.

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.

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.

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.

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.

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.

Bug Fixes

• Fixed an issue where “null” values caused certain drilldowns to work incorrectly

• Fixed an issue where bars in Stacked Bar Charts displayed incorrectly

• Fixed an issue where Scheduled Reports posted to Slack do not generate a Preview

• Fixed an issue formatting dates in Chart Editor

• Fixed an issue where datapoint labels were not displaying correctly in 100% bar chart

• Fixed an issue where Filter labels were cut off in the modal if text was too long

• Fixed an issue with scrolling through the “insert chart” menu in the Report Builder

• Fixed an issue where error messaging was misaligned in the chart builder

• Fixed an issue where Chart title displayed incorrectly in Safari when edited

• Fixed an issue where code in the SQL editor only displays in the top half of the view

• Fixed an issue where numeric types from BigQuery were treated as strings

• Fixed an issue where admins could not successfully enter a credit card in billing settings.

• Fixed an issue where admins received an error when disabling a user’s membership.

Improvements

• Added an ‘Edit’ button to text blocks in the Report Builder

• Updated Docker image of the Bridge connector to address security vulnerabilities

• Added a ‘Copy Link’ button to SQL Editor that allows users to share a direct link to query results

• Fixed an issue where some users experienced slowness in the SQL and chart editors

• Fixed an issue where parameter inputs in the Report View were hidden by default

• Fixed an issue with selecting special characters in the dropdown menu for parameters

• Fixed an issue where the copy button on charts did not work in certain browsers.