Mode release notes
Mode release notes

New Supported Databases Available: Clickhouse and Denodo




You can now connect Mode to two additional databases, Clickhouse and Denodo.

Read our help documentation for additional information on supported databases, or connecting Mode to your database.

Move charts around Reports with one click




The new “Move” feature makes building and formatting reports smoother and faster by allowing you to move charts around your reports with one click. No more endless scrolling to move a new visualization from the bottom of your chart to a prominent position at the top, or quickly between rows.

When editing a report, you can move charts up or down by one row, or you can jump them to the bottom or top of your report. Click the ‘Edit’ icon on any chart in the Report Builder, and you’ll see a new option in the toolbar labeled “Move”.

Move to.gif

Label Controls in Visual Explorer




Label controls enable you to make your visualizations cleaner and easier to read by giving you more control over the text labels that appear on your chart.

Choose from First, Last, Minimum, Maximum, or a combination to label only the most important points of your visualization. You can also use label controls to identify individual series in context, eliminating the need for a legend on your chart entirely.

Label Controls are available in Visual Explorer. To access, add a measure or dimension to the text drop zone, and then click on the T located directly to the left.

label controls - min and max.gif

Updated Python Libraries Are Live




Popular Python libraries have been updated across all notebook environments.

Also, the following new libraries are now available in Mode’s Python notebooks:

  • Dask
  • DuckDB
  • Pympler
  • Tensorflow-decision-forests

For a full list of libraries visit our help docs.

Updated Background Color in SQL Editor




We’ve updated the background color of the SQL editor to a darker gray in order to meet common accessibility and usability standards.

Upon review, we determined that the background color released with our brand update was slightly under the recommended contrast ratio between white text and base background, and with this new color, the contrast is well above the standard.

If you have any additional feedback, please share with our support team or your account representative.

Updates to Mode's Notebook




There are new updates to Mode’s Notebook environment to help you set up faster and manage memory better.

  1. Add public libraries to your Python and R notebooks using a simpler command. For Python, use ! pip install and for R, use the command install.packages() to quickly install public libraries and set up your notebook environment faster. For more information about how to install public libraries in Mode's Notebook check out the help doc here.
  2. Python notebooks will only load query results into the notebook environment when explicitly referenced to avoid using up RAM from unused query results. Read our help doc for more information about Python memory management.
  3. Dask, DuckDb, and Pympler are new Python libraries available in Mode's Edge environment to help efficiently ingest data into the notebook environment and monitor memory usage. Tensorflow-decision-forests has also been added to train, run, and interpret decision forest models in Tensorflow. Additionally, new versions of Matplotlib, statsmodels, NetworkX, and XGBoost have been updated in Edge. See the full list of updated libraries on our help site.

Make sure to test out the compatibility of these new libraries in your reports and notebooks before they are rolled out to the standard environment on January 12th. Read this blog post for instructions on how to get started with Edge.

Introducing Datasets




Datasets allow you to create and distribute verified, canonical datasets to teams throughout your business to power end-to-end, code-free, self-service reporting, simply by writing SQL.

Blog Header - Tile Picker - 1200x627@2x.png

A single Dataset can power multiple reports so your team can access and explore centralized data on their own, reduce repetitive requests and decrease costly warehouse hits.

Learn more and sign up for the beta here.

Faster, More Intuitive Pivot Tables




Jump into a pivot table with one click. You can quickly aggregate and summarize your data right from a query or an exploration using the new Pivot Table button in Quick Charts.

The new entry point clearly outlines where to add your fields. To create a pivot table, drag and drop at least 1 field to columns, rows, and values. This familiar, intuitive workflow makes creating pivot tables faster and easier.


For more information about how to create pivot tables in Quick Charts check out our help docs.

New Calculated Field Functions




There are new string and analytical calculated field functions available in Mode.

Utilize STDEV to quickly generate the standard deviation for a set of values without having to go back to your SQL query. VAR has also been added to calculate the variance of a set of data.

There are also new calculated field functions such as UPPER, LOWER, and TRIM to efficiently manipulate strings in your data.

For a full list of all the new calculated field functions visit our help docs.

Make Charts Fit to Screen




When creating a visualization in Visual Explorer, make your chart fit to your browser window so you don’t have to scroll. Applying Fit to screen prevents visualizations from being cut off which is especially useful when exporting your reports to PDF.

Fit to Screen GIF.gif

Read more about Fit to screen here.