Looker Studio release notes

Preview your data

The data source editor displays a preview of the data in your fields. This feature is available for the following data sources:

• Google BigQuery
• Google Sheets
• Looker
• Microsoft Excel
• CSV upload

Gemini in Looker enhancements

When creating a calculated field with Gemini assistance, Looker Studio now suggests sample prompts to help you get started.

Warnings for external links

When users click an external link, Looker Studio displays a redirect notice.

Proportional heights for inverted triangle funnels

You can now use the Use proportional heights setting to display the value of categories in a funnel chart by varying the height of each bar when you select the inverted triangle funnel style option. Larger values have taller bars while smaller values have shorter bars.

Improved hide/remove data source fields

We've improved the functionality of hiding and removing fields from a data source:

• You can remove any field from a data source. (Previously, you could only remove calculated fields.)
• Hiding or removing a field from a data source prevents report viewers from accessing metadata about that field. Field metadata includes information such as the field name and type of connector that is used to access that field.

These improvements help you control access to your organization's sensitive information while still promoting data democratization.

Learn more about data governance in Looker Studio.

Dimensions in scorecard charts

You can now choose whether to display a dimension or a metric as the primary field in a scorecard chart. When a dimension is selected as the primary field, you can also select a different field for sorting the dimension values.

New condition option for filters on date or time data type dimensions

Report editors can now specify a value and a unit of time for the following filter conditions with date or time data type dimensions:

• Is in the Last
• Is Before
• Is On or After
• Is Previous
• Is This
• Is Next
• Is in the Month
• Is in the Year

Learn more about filter conditions.

Looker connector filter enhancements

Looker data sources now support a Matches (advanced) filter option with date or time data type dimensions.

Learn more about the Looker connector.

Autogenerated titles for charts

When you enable the Show title option for a chart, Looker Studio automatically generates a chart title by default. The title is based on both the chart type and the fields that are used. You can add a custom title to a chart by entering it into the Title field.

More data from New Search Ads 360

You can visualize the following fields using the New Search Ads 360 connector:

• Conversions (by conv. time)
• All conv. rate
• Cost / client account conv.
• Google Ads Auction-time bidding
• Currency code

Let report viewers see all filters

Report editors can let report viewers see all of the filters applied to a report, including filters that viewers can't edit.

Filter value suggestions

When defining filters on charts, pages, or reports that use Equal to (=) or In conditions, report editors can select from a list of possible filter values that are provided from the underlying data. Filter suggestions are supported for all data connectors and can be disabled during filter creation.

Learn more about filter properties.

Looker connector filter enhancements

The following features are now available for use with the Looker connector:

• Filter-only fields can be set as a report control and a quick filter.
• Looker Studio displays suggestions for filter values based on the data source's LookML suggest_dimension and suggest_explore definitions when Equal to (=) and In conditions are used.

Text wrapping for pivot table row headers

You can now choose to wrap row header text in pivot table charts by enabling the Wrap text option in the Style tab.

New funnel chart option

The new funnel chart option lets you visualize how a metric changes over events in a sequential process.

Learn more about funnel charts in Looker Studio.

Microsoft Excel connector available

The Microsoft Excel connector lets you access the data stored in an Excel worksheet.

Text wrapping for pivot table column headers

You can choose to wrap column header text in pivot table charts by enabling the Wrap text option in the Style tab.

Public Preview of Gemini in Looker Conversational Analytics

You can query data in natural language. The Conversational Analytics feature is a Gemini-powered data querying experience that makes it easier to find answers, explore data, and share insights using natural language. This feature is now available in Public Preview.

Learn more about Gemini in Looker and how to enable it in Looker Studio.

Conditional formatting for collapsed pivot table charts

You can now apply single color conditional formatting to collapsed pivot table charts.

Sort list controls by any metric

List controls now support sorting the options on any metric, rather than just the reference metric.

New formatting options for the bin calculated field type

New formatting options for the Bin calculated field type let you customize the appearance of ad hoc numeric tiers. These options include:

• Interval "[x,y)" — This format displays the range including x, and up to but not including y.
• Integer "x to y" — This format must be used with discrete integer values (such as age).
• Relational ">= x and < y" — This format is best used with continuous numbers (such as dollars).

Audit logging for Gemini in Looker

You can view Gemini in Looker log events in the Admin Console (Security Investigation Tool). Gemini in Looker can be enabled for Looker Studio Pro subscriptions, which are associated with a Google Cloud project. To see which Google Cloud projects have Gemini in Looker enabled, as well as those with Gemini in Looker's Trusted Tester capabilities, filter the log by choosing the Setting name attribute and view the entries in the Project ID column.

Learn more about Looker Studio log events.

Ads Location Extension Fields

The following asset location fields are available in the Google Ads and New Search Ads 360 connectors:

• Asset location address line 1
• Asset location address line 2
• Asset location business name
• Asset location city
• Asset location country code
• Asset location phone number
• Asset location postal code
• Asset location province

Pro feature: Gemini in Looker public preview features

The following Gemini in Looker features are now available in Public Preview:

• Create calculated fields: Create custom fields and calculations in Looker Studio without prerequisite knowledge or experience with Looker Studio formula language.
• Add Looker Studio content to Google Slides: Import components from your Looker Studio reports into a Google Slides presentation.

Learn more about Gemini in Looker and how to enable it in Looker Studio.

Group Others available in more chart types

The Group Others chart setting lets you aggregate results that are outside of specified limits into a category labeled Others. This checkbox lets you compare data against the context of the remaining results.

Group Others is supported for the following chart types:

• Table charts
• Time series charts
• Bar charts and column charts
• Pie charts
• Line charts and combo charts
• Area charts
• Pivot table charts
• Treemap charts

Expanded data label customization options

The Data label section in the Style tab of the Properties panel provides expanded customization options, including font type, font color, font size, and font styling, as well as background color, opacity, and border radius settings. These options are supported for the following chart types:

• Area charts
• Bar charts and column charts
• Line charts and combo charts
• Time series charts

New Bin calculated field type

The Bin calculated field type lets you create ad hoc numeric tiers for numeric dimensions without needing to develop CASE WHEN expressions in calculated fields or logic in SQL.

New Color by tooltip option for Timeline charts

You can use the Color by tooltip style option to color timeline charts by tooltip dimension values.

Create totals that ignore canvas filters

You can configure totals and comparison metrics to ignore any viewer-applied filters.

Looker connector support for filter-only fields

Filters that are defined in LookML models with the parameter and filter LookML parameters are now displayed as filter-only fields in Looker Studio charts that use a Looker data source.

Learn more about LookML filters for Looker data sources.

Looker drill fields now available in Looker Studio

Drill fields and links that are defined with the drill_fields and link LookML parameters in Looker are now available to Looker Studio report viewers in the Drill Actions menu on Looker Studio table charts.

Learn more about drill fields in the Looker connector.

New Looker Studio log event attributes

New event logging attributes are now available for the Looker Studio log event data source. These attributes let Looker Studio administrators audit and monitor how Looker Studio users in their organization interact with schedules and alerts.

Learn more about audit log events in Looker Studio.

Looker data sources now display LookML filters

Filters that are defined in LookML models with the conditionally_filter and always_filter LookML parameters are now displayed in Looker Studio charts with a Looker data source.

Learn more about LookML filters for Looker data sources.

Chart titles

You can now add a title directly to a chart in Looker Studio. You can customize the title's font, color, size, styling, and positioning within the Title section of the Style tab of the properties panel.

Learn more about adding and styling titles for charts.

Timeline chart option

The new timeline chart option lets you visualize the relationships between groups of events and compare the timespans over which these events took place.

Learn more about timeline charts in Looker Studio.

Create a Looker Studio report within Google Sheets

You can create a Looker Studio report directly within Google Sheets. To create a report from a Google Sheets worksheet or range, use the Looker Studio extension in Google Sheets.

Create a Google Cloud project while subscribing to Looker Studio Pro

You can create a new Cloud project during the Looker Studio Pro subscription process. This project is used to host your Looker Studio Pro content.

Learn more about linking Looker Studio Pro to a Google Cloud project.

Viewer role for team workspaces

The Viewer role can now be assigned to members of a team workspace. The Viewer role lets users view existing assets in the team workspace, view folders in the team workspace, and view the team workspace Trash.

Pro feature: New Viewer permissions to create scheduled report deliveries

When sharing a Pro report, Pro users can now grant users with a Viewer role the ability to create scheduled deliveries of the shared report.

Show field descriptions in table chart headers

You can now let report viewers access field descriptions in tooltips when the Show field descriptions option is enabled for table charts. Show field descriptions is automatically enabled for charts that are connected to a Looker or Search Ads 360 data source. Field descriptions are sourced from the Description column in the data source.​

Learn more about table chart header options.

Pro feature: Folders in team workspaces

You can use folders and subfolders to organize assets (reports and data sources) in team workspaces.

Learn more about using folders to organize assets in team workspaces.

Custom value formatting

Custom value formatting lets you specify how dimension, metric, and calculated field values appear in charts without sending additional SQL queries to your database. Custom value formatting also includes the option for report creators and editors to specify a value format by using Google Sheets style notation.

Download and third-party access controls in Workspace admin console

As a Google Workspace or Cloud Identity administrator, you can control whether viewers in your organization can download Looker Studio content. You can also restrict users from enabling data sources that use third-party connectors or from adding third-party visualizations to Looker Studio reports.

Connection map visualization

You can now visualize your location data as sequences of points that are connected by a line in a new Google Maps visualization, called a connection map.

Add value to reference line or reference band label

You can now choose to display the value of a reference line or the value range of a reference band in visualizations.

Stepped lines for time series charts, line charts, and combo charts

You can now choose stepped lines for time series charts and for line charts and combo charts.

Table chart improvements

You can now use the following options in table charts: Transpose the table, Freeze one or more columns, and Resize row height.

Schedule delivery controls in Workspace admin console

As a Google Workspace or Cloud Identity administrator, you can control where users in your organization can send Looker Studio content.

Custom grouping

The new Group calculated field type lets you create ad hoc custom groups for dimensions without needing to develop CASE WHEN expressions in calculated fields or logic in SQL.

Label fields available in the New Search Ads 360 connector

You can now include the following New Search Ads 360 fields in your reports: Label (Account), Label (Campaign), and Label (Ad group).

Pro feature: Create alerts on a chart

Report viewers can set up an alert on a chart in a Looker Studio report that will notify the alert creator and chosen recipients when the chart data meets the conditions that are specified in the alert.

View underlying data available to all users

Looker Studio and Looker Studio Pro users can view the underlying data that is available in any chart in a tabular form. This can help you make the best decisions about what to include in the chart. Viewing the underlying data can also help you troubleshoot problems with your reports.

Quick filters available to all users

Originally released as a Looker Studio Pro feature, Looker Studio users can also use quick filters to easily change how the data in the report is filtered without changing the report configuration for other users.

New function: NATIVE_DIMENSION

The NATIVE_DIMENSION function lets you create Google BigQuery SQL expressions in your BigQuery data sources.

Drag and tilt Google Maps

With enabled tilt and optimized graphics, you can now tilt and rotate Google Maps visualizations. You can tilt a combo map visualization to display a map layer in three dimensions.

New map visualization: Combo map

You can now combine the properties of a filled map and a bubble map in a new Google Maps visualization, called a combo map. Combo maps have vector graphics and three-dimensional display features that are enabled by default.

Table Drilling and Table Tooltips

The Drill Actions experience for table charts provides an updated drill experience for report creators and report viewers. Visit the Drill into your data article for more information about the report viewer experience, and visit the Add drill actions to charts article for more information about setting up drill actions.

Visualize your Apigee API analytics data in Looker Studio

Apigee is a platform for developing and managing APIs. The Looker Studio Apigee connector lets you create reports and dashboards that are based on analytics and monetization data and share them with stakeholders and customers.

Set auto refresh on a report

As a report editor, you can configure a report to automatically refresh data, at a predefined cadence, as long as the report is open. This feature helps ensure that business decisions leverage the most up-to-date data.

Pro feature: Looker Studio Mobile app

Use the Looker Studio mobile app to access your data on the go.

New control type: Dimension control

The dimension control lets report viewers change the dimensions on one or more charts without needing to edit the report.

New field available in Google Ads connector

You can now specify an Asset Group Name field for a Google Ads data source when you're using the Google Ads connector.

BigQuery native integration in Looker Studio

BigQuery native integration in Looker Studio enables new monitoring features for Looker Studio queries, improves query performance, and supports many BigQuery features. This feature is in preview.

Upgrade to Looker Studio Pro

You can now subscribe to Looker Studio Pro directly by using our self-service upgrade tool.

Pro feature: View a chart's underlying data

Viewing a chart's underlying data can help you make the best decisions about what data to include in that chart and can also help you troubleshoot problems with your reports.

Move and delete assets in bulk

You can now select multiple Looker Studio assets at once to move or delete. For example, you can move more than one report from Owned by me to a team workspace, or delete multiple items from the Trash simultaneously.

New chart type: Boxplot chart

The new Boxplot chart lets you visualize the distribution and spread of values in your dataset.

New chart type: Candlestick chart

The new Candlestick chart lets you visualize ranges in your data, including opening and closing values, and the highs and lows of each range.

New chart type: Waterfall chart

The new Waterfall chart lets you visualize how a sequence of positive and negative values adds up to a total.

New line improvements let you customize the look and functionality of lines in Looker Studio charts. Improvements include:

• Reference bands that let you compare data against a range of values on your charts
• Vertical reference line support for Area and Time series charts
• Line style options that let you customize the appearance of lines in your charts
• Moving average trend line that lets you visualize a moving average calculation of the data on your charts

Pro feature: Add a quick filter

Quick filters provide a flexible, ad hoc way to explore your data. Use quick filters to easily change how the data in the report is filtered without changing the report configuration for other users.

Learn more about quick filters.

Pro feature: Get a personal report link

A personal report link creates a copy of your report that is only accessible to the person who opens the link. Changes made to either the original or the private report will not affect the other report.

Learn more about personal report links.

Intervals for time series charts

You can add intervals to time series charts to show how much uncertainty there is in your data. Intervals can be represented as shaded bands (area intervals), boxes, lines, or other shapes, depending on the interval type you specify.

To add an interval to a time series chart, select the Add an interval option in the STYLE section of the properties panel.

Learn more about intervals

Pro feature: Scheduled delivery using Chat

Looker Studio Pro users can schedule reports to be delivered using Google Chat. You can send reports to individual recipients or to entire Chat spaces.

Pro feature: Filter by email address for scheduled reports

Looker Studio Pro users can add row-level security to the data in a report scheduled to be delivered through email.

Learn more about Chat delivery and filter by email address.

See report and data source location on the home page

The Location field on the Looker Studio home page shows where your Looker Studio assets live. For free Looker Studio users, you can see if a report or data source is owned by you or has been shared with you. For Looker Studio Pro users, you'll see whether the asset lives in your My Workspace, lives in a Team Workspace, or has been shared with you directly.

Improvements to bar and combo charts

You can configure the following options for bar charts and combo charts with bars from the STYLE tab of the properties panel:

• For stacked bar charts, 100% stacked bar charts, and combo charts with stacked bars, you can choose between the default Metric value label type and the Stacked label type. For stacked bar charts, you can also choose the Total label type.
• You can use the Bar label position setting to specify the position of the bar label relative to the bars or columns in the chart.
• In the Chart spacing section, you can define custom spacing between bars and groups of multiple bars.
• You can select the Bar border color icon to choose a custom color for bar or column borders.

Learn more about bar charts and combo charts.

Audit logging for team workspaces

You can now view Team Workspace log events in the Admin Console (Security Investigation Tool). To see these events, filter the log by choosing Team Workspace as the asset type.

Learn more about Looker Studio log events.

GA4 API dimensions/metrics

New Google Analytics 4 data sources that you create get their fields directly from the GA4 API. Previously, GA4 data sources were based on a fixed schema with a predefined list of fields. To see new fields from the GA4 API in an existing data source, refresh the fields.

Learn how connect to Google Analytics.

Dynamic links in navigation buttons

The URL of a navigation button can be provided dynamically from a dimension value. Learn more.

Pause report updates. You can pause updates to minimize the number of data requests made while building and editing your report. While the report is paused, changes made to the report's data settings are placed on hold until you resume updates. Pausing report updates can potentially save on query costs because Looker Studio only requests the data needed to meet the report configuration as of the time you resumed updates.