Project Description

📖 2 mins read

What’s changing

Google is adding several new features that will give you more ways to work with, display, and organize your BigQuery data when using Connected Sheets. Specifically, the new abilities and improvements are:
  • Column stats
  • Filter by value
  • Calculated fields for pivot tables
  • Pivot table grouping
  • Slicers
See below for more details on these features. If you’re new to BigQuery and Connected Sheets, check out this video demo.

Who’s impacted

Admins and End users

Why you’d use it

Column stats 
This new feature allows easy access to aggregated insights about the data in any column of your BigQuery table. These insights help you understand the shape of your data and include sum, average, median, unique count, max, min, list of most and least frequent values and distribution of the values in the column.
More ways to work with and analyze BigQuery data using Connected Sheets 1
Filter by value 
In addition to the ability to filter a column “by condition”, you can now filter a column “by value”. Connected Sheets will retrieve the list of values for any column that you can access for your analysis. Use the Help Center to learn more about filtering columns by value when using Connected Sheets.
More ways to work with and analyze BigQuery data using Connected Sheets 2

 

Calculated fields in pivot tables 
Calculated fields for pivot tables allow for custom aggregation of formulas in pivot table buckets. Use the Help Center to learn more about how to use calculated fields.
Pivot table grouping 
You can now group numeric values from your source data into buckets of equal size in Connected Sheets pivot tables. This is useful when you’re working with a pivot table with numerous unique values—grouping can better narrow down your data by a minimum, maximum, and interval. Use the Help Center to learn more about using pivot table grouping in Google Sheets. 
More ways to work with and analyze BigQuery data using Connected Sheets 3

 

Slicers for Connected Sheets 
You can also use a slicer to filter your Connected Sheets tables, charts, and pivot tables. A slicer is based on a column/field from the BigQuery data source. The slicer influences all the Connected Sheets charts, extracts and pivot tables in the same tab. Use the Help Center to learn more about using slicers with Connected Sheets. 

Additional details

In the coming weeks, Google will introduce improvements for scheduled refresh, allowing you to automate refresh at a specified frequency with more granular scheduling options. These options include:
  • Hourly refreshes
  • Specific start dates
  • Frequency options such as every five days, every two months, etc.
More ways to work with and analyze BigQuery data using Connected Sheets 4
When this feature becomes available, Google will provide an update on the Workspace Updates Blog.

Getting started

Rollout pace

Thanks for sharing and spreading the word!