Mode release notes mode.com

New

You are now able to create timeline and waterfall charts in Mode's Visual Explorer. These charting improvements allow you to better visualize sequences over time, identify dependencies and relationships, and waterfall charts are particularly useful for showing how different factors contribute to a total sum or outcome.

Users can specify the start of the bar or area mark type using the new baseline channel available in Visual Explorer to create waterfall and timeline charts.

You can learn more about these new charting types here and make sure to check out these helpful sample demo reports.

New

With Default Field Settings, you now have the ability to define and apply standardized configurations for fields within a query or Dataset. This streamlines the process of creating consistent charts and Reports, empowering you to make data-driven decisions with ease.

Formatting: Users can set default formatting preferences for fields within each dataset. This ensures that charts automatically adhere to predefined formats, reducing manual effort and ensuring consistency across visualizations.

Color settings: Users can assign specific colors to values within fields, enabling consistent color-coding across charts using the same dataset.

Default aggregation: Users can specify default aggregations (e.g., sum, average) which are automatically applied when adding fields to visualizations, enhancing efficiency and standardization.

Read more about Default Field Settings here.

Improvement

Mode has released a series of updates to our Snowflake connection that make it easier for you to manage your Snowflake access and continue to enhance security.

Snowflake key pair authentication

This is an alternative method to basic authentication of username and password for enhanced security. It makes it easier for customers to manage their Snowflake access and rotate their credentials.

Bridge support for Snowflake

You can now use Mode’s Bridge connector inside your network that has direct access to your Snowflake database (e.g. Private Snowflake instances) when you are unable to connect directly.

Override the default role for querying Snowflake

You can now override the default role for querying Snowflake by setting a role in the connection settings.

You can learn more about Mode's Snowflake connection and these updates here.

New

You now have the ability to update the display label for each field in a chart to improve readability. The display label will be reflected in all places where the display label is mentioned in the chart (axis title, legend title, header titles, tooltip, etc.)

This option is available for all Quick Charts and Visual Explorer charts except for Flat Table Quick Charts.

Read more about about Display Label Controls here.

New

The introduction of the Histograms Quick Chart in Mode makes visualizing data distributions more accessible, providing users with insights into patterns, central tendencies, and outliers within their datasets.

Users can elevate their data analysis in Mode by leveraging the flexibility of binning numerical fields in Visual Explorer. This powerful feature opens up a world of possibilities, allowing users to customize their visualizations for a more tailored and in-depth analysis. Users now have the ability to create stacked histograms to understand the composition of different categories within each bin, compare distributions with overlapping histograms, create a grid of smaller histograms, each representing a subset or category of your data, and unveil data intensity patterns with heat maps – all made possible with the flexibility of binned fields.

Check out this video to learn more about Histograms, and read more in our help docs.

New

We're thrilled to announce some fantastic enhancements to Quick Charts that will elevate your data visualization experience.

The recent color updates that have been introduced to Visual Explorer are now also available in Quick Charts. You can now assign a specific color to a value in the color field in a Quick Chart and also color by measures in a Quick Chart.

We've also introduced:

• The ability to add nested and manual sorting options in Quick Charts.
• The ability to add table calculations to a Quick Chart.

These updates are designed to empower you with more control, creativity, and precision in your data visualization journey. We can't wait for you to explore these features and elevate your analytics game.

Learn more about these updates here.

Improvement

In November 2023, we introduced AI Assist, allowing analysts to seamlessly blend SQL with the flexibility of natural language. Since then, we've been hard at work enhancing your experience. Here's what's new:

🔍 Contextual ease: Now, AI Assist automatically considers your selected warehouse, providing context that refines the generated syntax for an even smoother experience.

🌐 Explore Possibilities: We've added in-product links to prompt examples, showcasing diverse use cases and styles for effortlessly integrating natural language into your SQL. See it in action!

✨ Effortless Autocomplete: Enjoy an updated autocomplete function, making it a breeze to insert AI prompts anywhere in your SQL code. Efficiency meets simplicity!

Ready to dive in? Sign up here for access to AI Assist and supercharge your workflow!

📚 Plus, here's a few more resources for you:

🎥 Mode U: AI Assist Overview Video

📝 Mode U: AI Assist Exercise

🚀 Getting Started Demo

📰 Blog Post

📖 Help Docs

Your journey with AI Assist starts here. Query on! 🤘

New

Users who use both Looker and Mode can now connect to Looker's Open SQL interface from Mode. You are now able to query your Looker Explores or Views as if they were tables in your Data Warehouse. This is helpful for analysts doing deep-dives and to ensure data consistency.

You can learn more about connecting to Looker here.

New

Mode now supports color conditional formatting allowing you to apply different colors to cells to visually represent data patterns, trends, or data points that meet certain criteria.

With this update you're now able to:

• Apply color of varying intensities to cells based on their relative values within a range.
• Create heat maps, where the intensity of the color represents the magnitude of a particular value. For example, visualize sales performance, website traffic, or survey responses.
• Highlight the highest and lowest values in a range, spot outliers, or compare values across different rows or columns. For example, comparing sales figures, grades, or customer satisfaction scores.

You can learn more about conditional formatting for measures here.

New

We have improved our Global Search experience to effectively serve you relevant content. You will now be able to quickly locate what you're looking for with better insight into who created the content and where it lives. Improvements include:

• Highlighting matched text in results
• Updating the global search header to be a spotlight search experience, with the ability to still click through to the full search results page.
• Search shortcuts (Cmd/Ctrl + K)

Learn more about Global Search here.