Mode release notes
Mode release notes

Faster pivot table and chart loading times with automatic pagination




When building visualizations containing large amounts of data, charts and pivot tables will load faster, and result in fewer errors with automatic pagination.

This backend updates means that Mode now brings only a subset of the data into the visualization, instead of all of the data, loading a page at a time and allowing you to move between the pages. Pagination controls will appear below your Quick chart or Visual Explorer chart once you drag in a field with large amounts of data.

pivot table pagination  copy 2.jpg

To learn more about pagination in Mode, see the documentation on the Help site.

Convert fields from one data type to another with type conversion formulas




Easily convert fields from one data type into another post-SQL with type conversion calculated fields.

These new formulas enable anyone to transform data stored in your warehouse in one format (for example, a date as 3 columns: Month, Day, and Year) into another (one column that represents the date) without using code.

The new type conversion formulas are:

  • DATE
  • INT

Find the syntax and examples of these formulas, as well as all other available formulas, here.

Build visualizations faster using typeahead search




Typeahead search makes it faster and easier to find the fields you need by enabling you to pull up a list of relevant fields by typing instead of dragging and dropping.

This expedites the process of building a visualization, especially when working with wide datasets or those that contain similarly-named fields. (For example, you may have many fields that contain the word "Account", like Account ID, Account Owner, Account Status, etc.).

To use this feature, click 'Add fields here' in the Columns or Rows dropzones and begin typing. You can also tab between Columns, Rows, and Filters to create visualizations without using a mouse.

Dropzone typeahead.gif

Backup your Datasets using Github sync




You can now backup the query syntax of your Datasets using Github sync, making it easier to track changes, manage version control, and govern Datasets.

Dataset editors can push changes to a Dataset into Github, and viewers of a Dataset will be able to see the last time changes were pushed. Also, Datasets are now included in the "Push All" option in Workspace Settings, along with Reports, Definitions, and Custom Themes.


If your organization does not have Datasets enabled yet, request access here. You can read more about Github sync on our Help site.

Increased control over Top/Bottom N Filters




You can now choose to apply the Top/Bottom N filter either first or last, compared to other filters in your visualization, which gives you increased control over how your filtered chart appears. Additionally, the default behavior has been changed to being applied last, after other filters, instead of first. This ensures that if you select Top 5, you will see 5 rows in your visualization.

Previously, it was applied first, which could give you unexpected results. For example, if you filtered by the 5 most popular product by sales order volume, and then filtered by Region, you could end up with fewer than 5 results.

Top N Filter Order .gif

For more information on filters in Mode, read the docs here.

Split legends and other legend improvements




Split legends, now available in Visual Explorer, allow you to separate legends for each measure and apply different colors to each. This makes it easier to compare different elements in the same visualization, and understand it more easily.

Screenshot 2023-02-23 at 12.19.25 PM.png

We've also made a few other UI enhancements to improve consistency in the legends across chart types, including between Quick Charts and Visual Explorer, and to improve the appearance of visualizations with legends. Enhancements include:

  • Tooltips for truncated values
  • Pagination and scroll functionality for long legends
  • Top to bottom arrangement of legends to save space

Read more about split legends here on our Help site.

Automatically add conditional color formatting to pivot tables




Conditional color formatting is now available in pivot table Quick Charts, making it easier to identify patterns, trends, and points of interest in your visualization.

Colors are automatically applied to the background of your pivot tables when building them in Quick Charts. You can then edit the colors, adjust apply the colors to the text instead of the background, or remove it entirely.

Screenshot 2023-02-23 at 11.57.47 AM.png

Conditional color formatting is also available in pivot tables built with Visual Explorer, but it will not be applied automatically.

For more information on conditional color formatting, see the Help site.

Updated toolbar makes Notebooks more intuitive




Notebooks are more intuitive and easier to use with a new Notebooks toolbar.

This toolbar is on the cell level, and contains actions that apply to individual cells (delete, freeze, fold, move up, move down, etc). Actions that apply to the whole Notebook remain at the top.

Screen Shot 2023-02-15 at 8.04.51 PM.png

Additionally, there is a new “Hide all output” function available in the “More” dropdown that enables you to clear all of your Notebook output without restarting the session.


Read more about how to use Mode’s Notebooks here.

Increased customization with Table calculation settings




Table calculation settings are a new feature that enable you to customize the way an analytic formula is applied to your data to ensure that it visualizes the data the way you want it to. For example, you may want to be specific about the way a total is calculated when using Percent of Total, and now you can make these types of choices in Mode.

Start by selecting the Quick table calculation type from the dropdown. Note: This used to be called Quick calculations, but the name has been changed for clarity.

From here, you will see an additional layer of customization based on which out-of-the-box calculation type you’ve chosen (Percent difference, Difference, or Percent of Total). For example, if you choose Difference, you’ll see a dropdown of Relative to, while if you choose Percent of Total, the next dropdown will say Total using.

In the Calculate using dropdown, you’ll still see the preset options, such as table across, table down, etc. that were previously available, but you can now add a Custom order, which allows you to specify which fields are used to partition the calculation and over which fields the calculation is performed (i.e. which fields the calculation addresses).

Read more about how to use table calculations here.

Create filters for Dataset-powered Reports




You can now add filters to Reports powered by Datasets, enabling your business teams to filter an entire report based on what is most relevant to them.

Report filters in Datasets.gif

For a refresher on Datasets, check out our documentation. If you don't have Datasets yet, sign up for the beta here, or reach out directly to your Customer Success Manager.