Mode release notes
Mode release notes
mode.com

Introducing Datasets

 

New

  

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

 

New

  

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.

PTQC NEW GIF.gif

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

New Calculated Field Functions

 

New

  

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

 

New

  

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.

Python 3.9 and Updated Libraries Are Live Across All Notebooks

 

Improvement

  

Mode now supports Python 3.9 in the standard Notebook environment.

In addition, popular libraries such as pandas, plotly, NumPy, matplotlib, and statsmodels have been updated and added to the standard environment. Visit our help site for a full list of the updated Python libraries.

R Version 4.2.0 and Updated Libraries Now Available!

 

Improvement

  

Two new R updates are now live in Mode’s Notebook environment:

  • The current version of R has been updated from 3.6.1 to 4.2.0
  • R libraries have been updated including plotly, ggplot2, and stringr. For a full list of libraries visit our help docs

Make sure to test the compatibility of your notebooks and reports with these new updates. Happy analyzing!

New ways to manage visualizing large data fields

 

New

  

Manual Update Mode enables you to make multiple changes to your visualization without waiting for it to render after every alteration. In Manual Update Mode, you can make multiple changes, click Apply changes, and see all updates at once.

Auto Update.gif

You’ll also see guidance on how to stay within browser limits when you come up against them. When you try to pull in a field that surpasses the limits, you’ll see a popup with instructions on how to adjust your data and continue with your analysis.

Screen Shot 2022-10-06 at 5.39.58 PM.png

Read more about these updates here.

Update: Infrastructure Upgrades

 

New

  

Mode is performing infrastructure upgrades for Helix, Mode’s in-memory database. We are changing our backing storage technology to modernize our platform, and as a result, a few of the details about how Calculated Fields and visualizations are displayed will change.

Please note: In testing & evaluation, these changes were observable in just 0.25% of customer visualizations. Any changes are likely very minor. If you have additional questions on the specific changes, please contact the support team.

These infrastructure upgrades will be rolled out starting on Wednesday, September 28, 2022 and all customers will be on the new infrastructure by Thursday, October 6, 2022.

Python 3.9 and Library Updates Now in Edge

 

Improvement

  

There are two new updates to Mode’s Edge environment.

  1. Python 3.9 has been added to Edge.
  2. Popular Python libraries such as pandas, NumPy, Matplotlib, and statsmodels have also been updated in Edge. See the full list of updated libraries on our help site.

Make sure to test your reports' and notebooks' compatibility before updates are rolled out to the standard notebook environment on October 25. Read this blog post for instructions on how to get started with Edge.

Top/Bottom N Filters Available in Visual Explorer

 

New

  

Top/Bottom N filters have been added as new filter types in Visual Explorer. Easily apply a top or bottom N filter to see the highest or lowest values in your dataset without writing additional code.

Top N Filter.gif

Applying a top or bottom N filter can help you understand a new dataset faster by loading a small batch of data instead of the entire table.

Read more about top/bottom N filters here.