New

We have improved the layout of various components of the Report navigation, including the left navigation panel and the report tabs.

Report editor, left navigation panel

Changes:

• Increased Report title font size
• Introduced more discoverable rename affordance when hovering on Report title
• Updated icons for the Report Builder, Notebook, and Queries
• Query names and their associated SQL tabs have been collapsed into a single, interactive row item
• Updated active and hover state row styling
• Removed static headers for Report Builder and Notebook sections
• Minimal stylistic updates to overflow menus for Queries and Charts
• Ability to Explore a chart via its overflow menu
• Improved placement and accessibility for error iconography
• New, more accessible animated run indicator for queries
• Introduced hover tooltip when adding new charts

Report editor, horizontal tabs

Changes:

• Query names and their associated SQL tabs have been collapsed into a single, interactive tab
• Better accessibility and discoverability around overflow menus
• Minimal stylistic updates to overflow menus for Queries and Charts
• Ability to copy the share link and Explore a chart via its overflow menu
• Updated tab highlight color

Manage access to Collections directly from the My Collections page

No need to click into individual Collections to update Workspace, Group, or individual access entitlements. Simply click the three dots to bring up the Mange Access modal, and you're off to the races!

Administrators have the ability bulk remove Additional Access entitlements (Admin-only feature)

This Admin-only feature makes cleaning up permissions at the Collection level much faster and easier. Instead of removing Groups and individual entitlements one-by-one, Admins have the ability to remove entitlements in bulk.

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.