Release Notes - July 2022

Builder

Basic Builder: Fixed a bug where the Stacked Column or Stack Bar chart type was not displaying the chart

Chart: Fixed a bug where map charts were not recognizing some countries correctly with two letter abbreviations

Chart: Fixed a bug where the colors of the charted columns in the table of data were all displayed as blue and did not match the colors displayed on the chart

Chart: Fixed a bug with Key Values where the comparison value was not showing if there was no data in the comparison range

Chart: Fixed a bug with Single Value metrics and Key Values where the comparison value was displaying as NaN% when the value was null

Data: Fixed a bug where sorting the warehouse tables could not be returned to the default sort

Data: Fixed a bug where the Filter Dates transform was showing an incorrect tool tip

Data: Added the ability to perform multi-key joins and to join on more than one column per table

Data: Updated the Format Dates transform to show current years in the example dates and output formats

Data: Added the ability to add a custom name for columns created by the Sum, Count, Average transform

Data: Added the ability to see the connection name and who created the connection when adding a Warehouse table to a metric or dataset

Data: Added the ability in a Join or Union All report to see the report label names instead of just seeing Report 1, Report 2

Data: Added the ability on the Sort Data transform to sort data at multiple levels

Data: Updated the Format Dates transform to dynamically update the example dates

Data: Added the option in the Group transform to perform a Median aggregation

Data: Added the ability in the Calculated Columns transform to use LOWER() and UPPER() functions

Data: Fixed a bug where changing the source in the Data Settings step would sometimes cause the Builder to get stuck in the loading state

Data: Fixed a bug with Spreadsheet Functions where the values were not visible in the data table

Data: Fixed a bug where the Sort & Limit transform was not being added when selecting the transform from the column dropdown menu in the data table

Data: Added the ability to sort the list of datasets and warehouse tables when adding a report to a metric or dataset

Data Explorer: Fixed a bug where adding a Compare Dates chart transform to a table chart was giving a white screen

Data Explorer: Fixed a bug where conditional formatting was not applying correctly to Sliced columns in a table chart

Data Explorer: Added the ability to group by 12 columns in a table chart

Data Explorer: Added messaging when changing from a series chart to a radar chart to let the user know the chart selections will be cleared

Data Explorer: Fixed a bug where the Sort chart transform was not sorting correctly when combined with a Slice chart transform

Dashboard

Dashboard: Fixed a bug where the Support button would disappear when resizing the browser window

Dashboard: Fixed a bug where some metrics were giving an error when visiting the dashboard, and could not be opened in the Builder

Dashboard: Fixed a bug where sharing a table metric with custom column sizing was not retaining the column sizing on the metric

Dashboard Filters: Fixed a bug where adding multiple filters to a table chart that filtered out all the data and then removing a filter would not reload the chart

Dashboard Filters: Fixed a bug where editing an existing dashboard filter and saving the changes would replace the column selections for other existing filters

Expanded View: Added a button to go Back to chart

Data Tab

Data Tab - Warehouse: Fixed a bug where deleted warehouse tables were still visible on the Warehouse and Needs Attention tabs

Data Tab - Warehouse: Updated the incremental sync times available in the dropdown to calculate based on the incremental sync times, not on the full rebuild times

Warehouse: Updated the warehouse behavior to no longer update metrics that have been deleted

Warehouse: Fixed a bug where some derived tables where showing row counts from a previous version of the table

Warehouse tables: Fixed a bug where some tables were displaying a socket hang up error and had stopped trying to update until another full refresh cycle had passed

Account Settings

PDFs: Removed the tile shadowing on PDF emails

Permissions: Updated the messaging when trying to view a deleted metric to state that the metric has either been deleted, cannot be found, or the user lacks permission to view it

Data Source

Facebook Ads: Updated to API v14

Facebook Social: Fixed a bug where the “Ignore posts from other pages” function was not correctly ignoring posts for all accounts

Freshservice: Fixed a bug where the connection was being invalidated if the user did not have permission to access the requested report

Google Analytics: Fixed a bug where some queries were showing intermittent error messages and could not pull data

Hubspot Warehouse: Fixed a bug where some errors were incorrectly causing the connection to become invalid

Hubspot Warehouse: Fixed a bug where the Contacts table was not handling duplicate column names properly

Hubspot Warehouse: Added the ability to see inactive owners in the Owners table

Instagram Business: Fixed a bug where some reports were incorrectly displaying a message that the data could not be pulled because the account had less than 100 followers

Postgres Warehouse: Added the ability to create warehouse tables from Postgres views

Quickbooks Online: Fixed a bug where some connections were becoming invalid

YouTube: Added the channel and video dimensions to the search

Beta Features

Amazon S3 Warehouse: Fixed a bug where csv files with less or more columns than expected based on the remaining columns will return an error explaining the problem

Date Picker: Fixed a bug where clicking on the down arrow button was not opening the date picker options

Embedding: Added the ability for Admin and Architect users to create API tokens that will eventually be used for embedding metrics

Facebook Ads Warehouse: Fixed a bug where the Ads Video Views (Formatted) table was giving an error when trying to display the watch time value as a number

Freshbooks Warehouse: Updated messaging for error handling to make it easier to understand what action needs to be taken

FTP/SFTP Warehouse: Fixed a bug where some users were unable to create a connection with their FTP/SFTP server

Google Ads Warehouse: Fixed a bug where incompatible fields were sometimes disabled and sometimes not

Hubspot Warehouse: Added the Feedback Submissions table

Infusionsoft Warehouse: Fixed a bug where the Products (Formatted) table was giving an error because the sub_category_id field no longer exists

Jira Warehouse: Fixed a bug where the Issues (Formatted) table was giving an error for some accounts

Mailchimp Warehouse: Fixed a bug where the Members table was not bringing in all the data

MongoDB Warehouse: Added the ability to use projections to remove problematic columns from tables

Pipedrive Warehouse: Fixed a bug where the Deals table was giving an error for some accounts

Stripe Warehouse: Fixed a bug where some historic data was missing from tables

Stripe Warehouse: Added the ability to turn on incremental sync for several tables

Stripe Warehouse: Improved the speed that warehouse tables can pull data

TSheets Warehouse: Fixed a bug where the Users (Formatted) table was giving an error for some accounts