Changelog

NEW

This week, we've enhanced the querying experience:

• New filter icons indicate when a column has a filter applied.

• Restyled headers more clearly highlight selected rows/columns.

• Calculated columns in Preview mode now have placeholder names for easier identification.

• You can now reference cells from queried output in subsequent queries.

IMPROVED

• Improved the aesthetics of join modals such that all menus open in the same direction.

FIXED

• Fixed an issue where text may overflow in query builder history panel.

• Fixed an issue where the group icon may no longer appear in toolbar.

• Fixed an issue where dashboard may not send.

NEW

We have added a schema selector to the query builder for Redshift database connections. Now, all Redshift users can pull from any field without writing traditional SQL.

IMPROVED

• We have optimized the performance of queries when executed from the “run all” button

FIXED

• Fixed an issue where dashboard emails may not send

• Fixed an issue where dashboard Notion embeds may not render

• Fixed an issue where copying a workbook may fail due to dashboard url

• Fixed an issue where “in” and “is” filter defaults were not “select all”

• Fixed an issue where changing a query limit would load the query preview

• Fixed an issue where workbook may be unresponsive due to spill formula overflow

NEW

• A new shortcut (Control + Home) will bring you back to cell A1 from anywhere in your sheet.

IMPROVED

• The column selector in the query builder now scrolls to the selected table by default

• Selecting a column from the query builder automatically highlights it in your connected sheet

• We’ve updated the display of warehouse data schema in the table browser to be consistent with other datasources

FIXED

• The SQL editor refocuses consistently when accepting query suggestions from AI Assist

• Fixed an issue opening the connections panel when a user does not have access to the saved query

• Formatting on columns with multiple formatting types will persist after a query run

NEW

We've enhanced MATCH formulas to accept array criteria, allowing you to identify values based on multiple conditions without the use of helper columns.

IMPROVED

• Improved typing focus when switching from the SQL editor to workbook cells.

• We more clearly display error messages for failed SQL database verifications.

FIXED

• Fixed aesthetic styling of the Connections overview panel on the right-hand side of a workbook.

• Fixed an issue where data may not register if edits are made during a query saving event.

• Fixed an issue where copies of connected sheets may not display light purple border around output data.

• Fixed an issue recognizing output data in imported sheets.

IMPROVED

• Updated the import script console log and Quickbooks & Xero report sync UI to be consistent with other in-app components.

FIXED

• Fixed an issue with refreshing a query that modifies a pivot table’s data range.

• Fixed an issue applying a default schema on a database when adding a filter in the query builder.

• Fixed an issue with opening saved queries that reference tables not accessible via the schema.

• Fixed an issue where running a query may not register until the page is refreshed.

• Fixed an issue preventing pasting input into calculated column headers.

NEW

We’re continuing to enhance the querying experience based on your feedback:

• Improved filter displays more clearly indicate the specific value being filtered. For example, date filters will show "January 2022" rather than "31 values”. Non-date filters with a single value applied will show that specific value rather than “1 value'“.

• Reordering or deleting calculated columns no longer triggers a query preview.

• A restyled loading state makes it clearer when a query preview is still being generated.

IMPROVED

• Updated the datasource setup experience to avoid triggering the “unsaved changes” modal when the datasource has failed to connect.

FIXED

• Fixed an issue where scheduled queries may not adhere to summer timezone changes.

• Fixed an issue where selection modals may overflow.

• Fixed an issue with chart legend ordering changing.

• Fixed an issue where one sheet’s query may replace current sheet’s query.

NEW

We’re continuing our push to incorporate your feedback into the querying experience in Equals:

• We’ve cleaned up our icons in the connections panel to make the actions clearer.

• You’ll find a roomier version of the full-screen editor to give you more room for SQL.

• Plus, AI Assist can now be accessed directly within the editor (without opening a side chat).

IMPROVED

We’ve improved the UI for sorts and filters in connected sheets to make these actions clearer. Sorts will have an icon calling out the type of sort in the left-hand corner of the column header, while filtered columns will have an icon in the right corner of the column header.

FIXED

• Fixed an issue where chart labels may truncate.

• Fixed an issue filtering output from the query builder for columns with the same name.

• Fixed an issue with the output when importing workbooks with array formulas.

• Fixed an issue filtering on joined columns in query builder joins.

NEW

We’re listening to your feedback and have introduced some changes to fine-tune the querying in Equals:

• You’ll find restyled headers that more clearly identify queried output (purple), calculated columns (green), and data notes (yellow).

• We’ve also improved the process of joining across datasources to make each step more intuitive.

• Finally, we’ve made the process of filtering (and removing filters) from headers on connected sheets clearer.

IMPROVED

• We now open the ‘options’ modal for cells on the dashboard when double clicking on display text.

• Added links to the schema overview for relevant datasources from the table browser.

FIXED

• Fixed an issue with table header scroll in dashboards.

• Fixed an issue where dashboards may not send.

• Fixed an issue with adding an OR criteria after several ANDs in the query builder filters.

• Fixed an issue filtering pivot tables on multiple criteria.

• Fixed the ‘only’ button selector in filters.