We’re constantly shipping new features and improvements to existing ones. These release notes cover just the updates that customers experience.
January 29th, 2018
- Clicking on a series in a chart now adds a black outline for better feedback and awareness.
- Removed the empty dimensions panel when inspecting a Definition in the editor.
- The increase/decrease granularity buttons (
-) are now in-theme on Mode’s native Dark and Subway Report Themes.
- Resolved issue where erroneous actions would show up in the global header when viewing a historical report run.
- Resolved issue where moving reports would erase the report title and remove elements from the report layout in certain cases.
- Resolved issue where fullscreen reports were not auto-refreshing.
- Resolved issue where the titles of Big Number charts disappeared when hovering over the Big Number.
January 23rd, 2018
- In the chart builder, you can now select a color palette directly from the Chart Settings:
- Tooltips are now stylistically consistent with the new Report headers and denser/cleaner when hovering over charts.
- Tooltips now only show up when hovering over series in charts, so they don’t pop up unexpectedly.
- View Data table has number formatting consistent with the results panel.
- Single data points on Line and Area charts are now shown without needing to hover over them.
- Report Filters now “float” and scroll vertically with a report.
- Resolved issue where the “Save” action under the Report dropdown inside the editor was sometimes disabled even if the Report was in a dirty state.
- Resolved issue where you could not change the height on a table in the Report Builder back to “Full” once it was switched to something other than “Full”.
- Resolved issue where Safari users were unable to see the rightmost sidebar in the Chart Designer.
- Resolved issue where drilling into charts that are set at “small” height would break the chart.
- Resolved issue where charts in the Report Builder wouldn’t update after Drilling into series in the Editor.
January 8th, 2018
We’ve added support for a number of new Python libraries:
- folium (v0.5.0)
- lifelines (v0.13.0)
- prettytable (v0.7.2)
- tabulate (v0.8.2)
- wordcloud (v1.3.1)
- lifetimes (v0.8.1)
- sexmachine (v0.1.1)
- pyzipcode (v1.0)
- ua-parser (v0.7.3)
- engarde (v0.4.0)
- pandasql (v0.7.3)
- agate (v1.6.0)
- jsonify (v0.5)
- hdbscan (v0.8.11)
- tensorflow (v1.4.1)
- keras (v2.1.2)
- cufflinks (v0.12.1)
- textblob (v0.15.0)
- geomap (v0.2.1)
- gensim (v3.2.0)
We’ve also updated the versions for a number of existing Python libraries:
- beautifulsoup4 (v4.4.1 -> v4.6.0)
- matplotlib (v1.5.1 -> v2.0.2)
- nltk (v3.2.2 -> v3.2.4)
- numexpr (v2.5.2 -> v2.6.2)
- requests (v2.13.0 -> v2.14.2)
- numpy (v1.10.4 -> v1.11.3)
- pandas (v0.18.1 -> v0.20.1)
- plotly (v1.11.0 -> v2.2.3)
- scikit-learn (v0.17.1 -> v0.18.1)
- scikit-image (v0.11.3 -> v0.13.0)
- scipy (v0.17.1 -> v0.19.0)
- seaborn (v0.7.1 -> v0.8)
- statsmodels (v0.6.1 -> v0.8.0)
- sympy (v0.7.6.1 -> v1.1.1)
- Redesigned and updated the header throughout Mode for easier navigation.
- Added a Visualization Toolbar, complete with Quick Sort and Back / Forward actions!
- Fixed a bug where charts were ordered differently in cloned reports
- Python Notebooks now support the Requests library and can connect to the internet!
- Fixed a bug where color palettes weren’t getting copied over to duplicated charts.
- Custom Color Palettes accept values without the ‘#’ symbol.
- Added query_run_url and report_run_url as parameters to use in Query Headers.
- New chart colors and custom palettes! There are now four new palettes, enhanced colors on the existing ones, and the ability to customize your own palettes.
- Hovering over bar charts now displays information about all series in the column, including a total of the values.
- Tooltip now aligns properly when hovering over the Run button on reports.
- Add-chart button no longer appears erroneously in the Editor when queries fail.
- Added support for Hive Version 1.2.2.
- Fixed bugs where the Report Builder scrolled on its own, and certain users weren’t able to drag and drop elements.
- Fixed an issue where the Expanded View scrolled past the bottom of charts.
- Fixed a bug where the query timer panel reset after viewing another running query.
- Display Table filtering now works correctly when sorting by a specific column.
- Fixed an issue where the Share action appeared in the Definitions editor.
- Fixed a bug where the actions toolbar spilled over when editing text elements in the Report Builder.
- Updated the Discover page with recent releases.
- Fixed a bug where code rendering pages (e.g., Query History, Report Details) scrolled to extreme heights in Firefox.
- Fixed a bug where Display Tables with one row didn’t render correctly in the Editor.
- Visualization Filters are live! Filter charts within the Chart Editor or expanded view.
- Series colors remain consistent across all charts powered by a query.
- Charts are taller! They now extend to fit the entire screen when exploring in the Editor or in Expanded View.
- Fixed a bug where the negative symbol appeared after the currency symbol on axes in charts.
- Changing a data source in the query editor persists when you save the report via Ctrl/Cmd + S.
- Large negative numbers now round properly in Display Tables.
- The export button is no longer disabled on reports with large query results
- Fix ed a bug so that Chart names now appear on all expanded views
- Fixed a bug so that Definitions now properly render in a query when one Definition is commented out
- Fixed a bug so that Report Filters now persist when cloning reports
- Report preview images now expire after one month when sent via email
- Fixed a bug where a deleted query’s SQL would sometimes show up in other queries
- Fixed bug where tooltips on charts were becoming unstyled
- Added the ability to run a report with custom parameters via the API
- The Expanded View icon no longer shows up on Big Numbers in the Editor
- Fixed a bug with column widths in the Display Table
- Drag-and-drop now works for Pivot Tables in the Expanded View
- You will see a success message when changing the name, description, or data source of a Definition
- Cloning a query in the Editor now consistently results in the new query using the same data source as the source query
- The Display Table filter now respects decimals
- Improved table autocomplete where it was failing due to a ‘.’ character
- Tooltips no longer flash in the corner of the screen
- Tables stay pinned in the Editor
- Time dropdowns in the schedule creation flow now work in Firefox
- Fixed a bug with duplicate values in multiselect parameter fields when creating report schedules
- Fixed a bug where report descriptions were not saving
- Scrolling up/down reports on your mobile device are now improved
- Users without query access to a data soure will no longer see it the global navigation panel
- Added support for Presto version 0.181
- Updated axis titles and tick marks, legend titles and labels, and tooltips in Mode Subway and Mode Dark themes
- The Chart Picker features helpful thumbnail images of each chart type
- If a Plus Plan organization has claimed a domain and restricted Sign In Options to one specific provider, logged out members will be guided toward that provider option after entering their email address in the sign-in flow
- Former organization members no longer show up in GET requests against the data source permission grants API endpoint.
- Area charts now have better boder lines, totals are included in tooltips for multi-series charts, and values are now right aligned in the tool tips.
- Charting: added continuous/discrete toggle for fields once in a chart settings column.
- Fixed a Line+Bar chart bug related to the second y-axis settings.
- Renamed queries now persist.
- Charting: added support for continuous x-axes.
- Fixed a tooltip bug to show the query on hover in the Editor.
- Permissions: Changed our domain <> organization permissioning system for faster and easier onboarding. Domains can no longer be claimed by multiple organizations.
- Permissions: Improved the Member Authorization section of Settings to be more intuitive based on the above.
- Permissions: Admins can now prevent Mode from sending emails without transport ecryption to mail servers that don’t support it.
- SQL Editor: Fixed a bug where the Limit 100 checkbox would automatically check when running queries using Cmd + Enter.
- SQL Editor: Fixed a bug where creating multiple queries in a row resulted in all of them having the same name (e.g. “Query 2”).
- Reporting: Fixed a bug where, from time-to-time, tables were appearing without data.
- Reporting: Cleaned up the white space under tables with only a few rows of data.
- Report Builder: Fixed a chart resizing bug related to chart widths.
- Refresh your database schema right in the Editor, using the context menu that appears next to the data source switcher dropdown.
- Got data in Amazon Athena? Now you can analyze it using Mode.
- Fixed a bug where charts wouldn’t appear in the Report Builder until you refreshed the page
- Fixed a bug where charts using custom colors (via alamode) weren’t rendering correctly in PDFs
- Exporting CSVs is now much faster: we’re talkin’ milliseconds fast
- Fixed a bug where the View Details button was hidden on reports
- Multi-select parameters with > 1,000 values no longer break reports
- Fixed a bug where Internet Explorer users weren’t able to remove elements from reports
- Drop a direct link to a chart or table into Slack, and watch a preview image unfurl.
- We launched Mode Dashboards, a suite of new features that let you deliver beautiful dashboards to engage your whole office.
- New themes enable quick switching from a default light theme to Mode’s darker themes for easy viewing. Custom themes are also available on Plus Plan.
- Set reports to full width and show more charts at once in the new Report Settings.
- Full screen enables dashboards to be displayed anywhere and refreshed automatically.
- Expanded views allow deeper exploration and sharing direct links to specific charts for discussion.
- Disable the Run button to ensure report viewers won’t put unnecessary strain on your database.
- The updated sidebar makes it faster and easier to access your team’s analysis, from wherever you are in Mode. In addition to an aesthetic update, Starred reports, Recently Viewed reports, and Discover are all accessible directly from the sidebar.
- We’ve updated our Slack app capabilities to enable scheduled sharing to private channels and direct messages. With added support for link unfurling, you can also share report image previews in Slack by sharing a link to the Mode report.
- Full width text elements are more readable, with the ability to add margins to your text. Simply click Margins on the formatting toolbar when a text element is set to full width, and margins will be added to keep your text centered and readable.
- A few styling improvements make chart titles easier to read, and adjusted padding around report elements to improve data density.
- Mode’s new scheduling options enable automatic refreshes of reports as frequently as every 15 minutes. Plus, reports can be scheduled in 5-minute increments, allowing data to be refreshed and delivered exactly when it’s needed.
- With the new context menu in the schema browser, you can quickly navigate to your data source settings from the SQL editor. Next to your data source, you’ll find a new context menu with a link to your settings.
- Share more complete analyses with the new text elements for reports. Present charts and narratives side-by-side, giving coworkers the context they need to make informed decisions. With just a click, supplement your reports with captions, notes, and images.
- Quickly filter large data sets with just a few clicks with the new “Select All” option in Mode pivot tables.
- Two powerful new updates for Mode Python Notebooks. Pandas DataFrames can now be exported to CSV, making it easier to share analyses across your company for teams to explore on their own. Plus, customers of the Mode Plus Plan now have 3x more Python compute, with up to 12 GB per session.
- Enable report viewers to pull data for multiple customer accounts or compare marketing channels with the new multiselect parameters.
- Now you can quickly explore data sets using pivot tables! Adding a pivot table to your analysis is as simple as adding a chart. And once the pivot table is in the report, your colleagues can explore the always-up-to-date data on their own.
- New and returning users are now welcomed to Mode with a new and improved sign in / sign up flow.
- As a part of the new sign up flow, we’ve also made connecting to data sources more straightforward.
- When sharing reports via email, you can now choose to include an image preview of the report and/or HTML tables of your query results. Previously you could select both or neither.
- With the new ability to pin reports in Spaces, clearly surface the most relevant reports at the top of a Space, and be sure that your coworkers find the analysis they need.
- It’s even easier to star your favorite reports for quick access from your home page. When you’re viewing a report, star it simply by clicking the star in the header breadcrumb at the top left. Once you star a report, you’ll be able to access it directly from the Starred tab on your home page.
- Sometimes comments in editor were really hard to read if you were using the dark theme. So we tweaked the color contrast to make them much more legible.
- Now analysts have the flexibility to query Google BigQuery sources using Standard SQL or Google’s Legacy SQL. Choose your default in your BigQuery data source settings, or just preface any of your queries with #standardSQL or #legacySQL to switch back and forth on a query-by-query basis.
- We made a number of improvements to make Spaces faster and easier to use. When you rename a Space, the list of Spaces on your homepage will immediately be updated. Plus, the breadcrumb in the editor will update when you move a report to a different Space.
- Now you can add members to an open Space after you’ve created it, making it easier to ensure that your work gets in front of the right co-workers.
- We fixed a bug with the context menu on Display Tables to ensure that it always loads all of the correct options.
- Previews for long Definitions will automatically re-size so they fit in your editor window.
- We recently added several granular ways to control user permissions. So today we added groups to make it easier for admins subscribed to our Plus Plan. Rather than maintaining permissions for individual users, admins can create a group of users and grant permissions to the group.
- We’re getting meta and adding insights into how your team uses Mode. Mode users on the Plus Plan will now see a new Stats page under Settings.
- To quickly join Definitions with other, one-off logic, it’s helpful to understand its nuts and bolts. We’ve added a Definition preview right in the Editor, enabling you to review its logic more quickly.
- Mode’s SQL editor has been updated with support for multiple SQL statements in one query. Now analysts can create temp tables and re-format their data by using a greater set of commands then simply SELECT or JOIN.
- Settings have been reorganized to accommodate for all the recent Sharing features added to Mode and to make navigating permission options easier.
- The Mode Slack App is here! Now it’s easier than ever to put timely, relevant data into the hands of decision makers, right when and where they’re making decisions. Get started by setting up the integration in a couple of clicks, here.
- We upped the gray section of our color palette to include a few new shades—providing better legibility for folks with color blindness and low or worsening vision, without sacrificing the minimalist aesthetic that’s come to define Mode.
- Email shares have been updated to include charts and report previews.
- Mode has always stored your query history—now, we’re giving you access to your history right from the SQL editor! Test your queries as you go, and know you’ll always be able to jump back to an earlier version.
- Make sure that analysis reaches the right people at the right time—even if they’re outside your company. With the new external sharing feature available on the Plus Plan, you can make any report externally available and share it via email or url.
- White-label embeds are a fast, easy way to show key metrics to customers, right in your application. You’ll be able to guarantee that the right customer gets the right data.
- Mode’s SQL editor is even more powerful with the addition of highlight to run. Troubleshoot nested SELECT statements, test your code as you go, and iterate faster.
- We just launched Discover—a one-stop shop for learning about everything new and helpful in Mode, right on your home page.
- Curate your list of Spaces on the Mode home page and access reports faster with the new ability to join and leave Spaces. Just click Spaces in the navigation drawer, and choose the Spaces that matter most.
- We just introduced the new Mode Forum! It’s a new place to share ideas and swap best practices with other analysts.
- Report on your KPI metrics however they’re calculated. Now Big Number charts can display aggregate values by sum, count, count (distinct), and median.
- Embedded reports set to automatically run will now use default values for any parameters, instead of the most recent run.
- We added data source access controls, so you can limit querying access to a data source on a user-by-user basis. Check out our announcement last month to learn about this and other new access controls available on Mode’s Plus Plan.
- Report layouts have a cleaner feel with new tighter margins between charts and tables. Or if you want to set your own margins, remember that Mode’s HTML Editor gives you full control to customize your report’s layout.
- Negative Big Numbers and values in Display Tables now correctly display in parentheses, rather than a negative symbol, when they’re displayed using financial formatting.
- We made some small improvements to make formatting Display Tables more intuitive. Now when you format a column in the Display Table your scroll position won’t reset.
- Now you can access reports from multiple Spaces! With Mode’s new shortcuts feature, analysts can build and maintain a single report, and allow coworkers to easily discover the analysis from the Space they visit most.
- When you’re working in the Query Editor, the context menu on individual queries no longer gets hidden below the scroll bar. So you can quickly view the version history, rename, duplicate or delete a query from your report—without needing to resize your browser window.
- When you export a report to share it as a CSV, the query name will now be included in your file, making it easier to see which CSV file is associated with a particular query in a report.
- We also made our new SQL formatting functionality available in the Definitions Editor, so your SQL will always look good regardless of where you write it.
- Clear input in filters on Display Tables with the simple click of a button. Just enter the term you want to filter on, and then click the X to clear the filter.
- Our new SQL formatting capability works with parameters! Now when you click to format your SQL, it will the preserve the Liquid template formatting in your parameter form fields.
- We’ve improved several of our chart types to make it easier to display specific metrics. Big Number charts no longer round averages up or down, and we fixed a bug so now you can hover over Scatter Plots and Line + Bar charts with time series.
- If you’re looking for more information, check out our new Help menu! We made more resources easily available, so you can quickly find information to help you get started, share Mode with teammates, or learn about some of the advanced features to get the most out of Mode.
- Ever struggle to read a coworker’s sloppy code? Now you don’t have to worry, with our new SQL formatting capability! With just one click, you can format a SQL query. If you don’t like it, just click it again and you can immediately revert back to your original formatting.
- A lot has changed! We’ve re-designed Mode to make it faster and easier for everyone in your organization to discover and access analysis. Check out our full blog post to learn more details.
- Spaces let you curate reports for teams and projects (and feature preview images to help you find what you’re looking for).
- Definitions help you establish reusable, SQL-based business logic for more efficient and consistent analysis.
- Mode’s new Access Controls offer Organization Administrators powerful new user permission options.
- You can now include queries against multiple data sources in one report! With your queries from different data sources all in one place, its easier than ever to build a dashboard in Mode.
- We’ve shortened the trial period for new orgs who have connected their first private data source to 14 days.
- We made several improvements to our Big Number charts. The font size is now responsive to the width of your Big Number chart, in case you wanted to make a big number even bigger (or smaller). We also fixed a small bug, so you can export Big Number charts to PDF’s.
- We added a new Big Number chart type, making it simple to build reports and display KPI’s as, well, a big number. Combined with our recently new ability to adjust the height of report elements, it’s easier than ever to build reports and share information throughout your company.
- There’s a new database connector available: we’ve added an integration with DataVault from Tenjin, a company focused on giving marketers insights into mobile marketing and ROI analytics.
- We fixed a bug, so now you can toggle seamlessly between Python and Markdown input cells.
- Sometimes SQL queries take a long time to run! Our Python notebooks were impatient and would try to start doing their thing before the query results were ready, leading to some failed report runs. We put some logic in place to make the notebooks wait their turn.
- To make the best use of space in a report, you can adjust the height of the report elements. Set your charts and tables to small, medium or large. You can also set tables to Full to avoid scrolling up or down.
- We’ve increased the timeout for schema refreshes to deliver more consistently up-to-date data.
- Secret embeds (Plus Plan) now support images produced with Python.
- The report sharing default is now email. Click ‘Share’ and simply start typing your recipient’s email address.
- Python Notebooks now offer two new ways to reference queries: by name or query token. If you think you might rename a query after you’ve started working with it’s results in Python, we recommend using the query token option.
- PDF exports and embedded reports are more consistent with Display Table formatting.
- Some minor tweaks to make filtering and sorting Tables faster.
- Email subject line timestamps now reflect your timezone.
- Timestamps are appended to the subject lines of scheduled email runs to keep your email inbox more organized.
- We’ve added an account switcher modal to make it easier to understand your context as you switch between organizations.
- New, more powerful Display Tables. Sort columns and filter for specific values right from the report.
- New table formatting options provide additional clarity around presented data. You can now choose to display columns as a percentage or currency.
- Mode Python Notebooks now support Plotly offline. Start making interactive graphics with Python data frames.
- Last week’s schema browser updates affected the order of things. Your database tables are back in alphabetical order.
- The Date Picker allows parameter users to point-and-click on a date rather than tediously typing it in.
- Schema browser updates make it faster and more stable.
- Values weren’t appearing in hovers on Line + Bar charts. The hover is back
- Default chart names are descriptive of their types instead of “Untitled Chart.” For example, Line + Bar Charts are now called “Line + Bar Chart.”
- Launch of Mode Python Notebooks. Write a query in SQL, then switch over to the Python notebook to access the results for further analysis. Check out the full blog post.
- New pricing.
- Activity feed is no more: We retired the feature, and will now default to the Reports tab on the homepage.
- Bug fixes: The results grid is again navigable using arrow keys, and renaming queries is both cancellable and reflected in Report Builder.