Skip to main content
Documentation
Technology areas
close
AI and ML
Application development
Application hosting
Compute
Data analytics and pipelines
Databases
Distributed, hybrid, and multicloud
Generative AI
Industry solutions
Networking
Observability and monitoring
Security
Storage
Cross-product tools
close
Access and resources management
Costs and usage management
Google Cloud SDK, languages, frameworks, and tools
Infrastructure as code
Migration
Related sites
close
Google Cloud Home
Free Trial and Free Tier
Architecture Center
Blog
Contact Sales
Google Cloud Developer Center
Google Developer Center
Google Cloud Marketplace
Google Cloud Marketplace Documentation
Google Cloud Skills Boost
Google Cloud Solution Center
Google Cloud Support
Google Cloud Tech Youtube Channel
/
English
Deutsch
Español
Español – América Latina
Français
Indonesia
Italiano
Português
Português – Brasil
中文 – 简体
中文 – 繁體
日本語
한국어
Console
Sign in
Looker Studio
Overview
Looker
Guides
How-to guides and feature descriptions
Best Practices
Best practices and specific use cases
LookML Reference
Reference for Looker's LookML modeling language
API Reference
Reference for Looker's APIs
Resources
Release, support, and contract information
Community
Community forum for Looker
Looker Studio
Guides
How-to guides and feature descriptions
Community
Community forum for Looker Studio
Guides
Contact Us
Start free
Documentation
Overview
Looker
More
Looker Studio
More
Guides
Technology areas
More
Cross-product tools
More
Related sites
More
Console
Contact Us
Start free
Get started
Welcome to the new Looker Studio documentation site
Welcome to Looker Studio!
Quick start guide
Learn Looker Studio
Find your way around Looker Studio
Create a report in Looker Studio (Lab)
How to use Looker Studio
About the 'How to' guide
Think with Looker Studio
A typical Looker Studio workflow
View, edit, and create reports
View a Looker Studio report
Drill into your data
Create a report
Edit a report
Connect to your data
About connectors, data sources, and credentials
Add data to a report
Edit a data source
Build your reports
Add charts and controls to your report
Configure report components
Explore your data
Explore your data in Looker Studio
Work with dimensions and metrics
Model your data
Work with fields in reports
Edit fields in your reports
Manage reports and data sources
Manage added reports and data sources
Copy a report
Copy a data source
Rename reports, data sources, and blends
See what's changed in reports and data sources
Delete a data source
Delete a report
Share your reports and collaborate with other users
Ways to share your reports
Invite others to your reports
For enterprise administrators
Enterprise administrator feature overview
Tutorials
Report tutorials
Report tutorials introduction
Tutorial: Create a new report
Tutorial: Add charts to your report
Tutorial: View and share your report
Data source tutorials
Data source tutorials introduction
Tutorial: Create a Google Analytics data source
Tutorial: Create a Google Sheets data source
Tutorial: Create a BigQuery data source
Calculated fields tutorials
Calculated fields tutorial introduction
Tutorial: Create calculated fields in Looker Studio
Tutorial: Create a ratio field based on filtered metrics
How to use the Looker Studio mobile app
What you need to use Looker Studio
Glossary
Aggregation
Asset
Blended data
Chart
Component
Connector
Data credentials
Data source
Dataset
Dimension
Edit mode
Editor (user type)
Field
Google Analytics property
Join key
Metric
Owned by me
Owner
Page
Properties panel
Recent
Report
Sandbox
Schedule creator (user type)
Shared with me
Team workspace
Toolbar
Trash
View mode
Viewer (user type)
Help and support
Looker Studio Pro
About Looker Studio Pro
Try Looker Studio Pro
Looker Studio Pro Essentials (Cloud Skills Boost Course)
Subscribe to Looker Studio Pro
Looker Studio Pro subscription overview
Start a new Pro subscription
Step 1: Select a Google Cloud project
Step 2: Add people to the subscription
Step 3: Buy additional Looker Studio Pro licenses
Organize and manage Looker Studio Pro content
About Looker Studio Pro content
Upgrade Looker Studio content to Looker Studio Pro
Team workspaces
About team workspaces
Create, edit, and delete team workspaces
Organize assets with folders in team workspaces
Manage team workspace assets
Best practices and tips for using team workspaces
Set a default Google Cloud project for Looker Studio Pro
Manage Looker Studio Pro subscriptions
Edit a Looker Studio Pro subscription
Link Looker Studio Pro to different projects within your organization
Link a Looker Studio Pro monthly active user subscription to a Google Cloud project
Consolidate multiple Looker Studio Pro subscriptions
Cancel a Looker Studio Pro subscription
Gemini in Looker
Gemini in Looker overview
Enable and disable Gemini in Looker for Looker Studio
Perform tasks with Gemini assistance
Add Looker Studio content to your Google Slides presentation using Gemini assistance
Create calculated fields with Gemini assistance
Conversational Analytics
Conversational Analytics - Query your data in natural language
Conversational Analytics in Looker
Conversational Analytics in Looker Studio
Conversational Analytics - Data agents
Conversational Analytics Code Interpreter
Best practices for rolling out Conversational Analytics with Looker
Connect
About connectors, data sources, and credentials
Available connectors
Connector references
Connect to Looker
Connect to Looker
Understand Looker Explore data on a Looker Studio report
Overview of Looker connector requirements, limits, feature support, and troubleshooting
Overview of Looker connector permissions
View and interact with Looker data on a Looker Studio report
Connect to databases and Cloud storage
Connect to BigQuery
Connect to Google BigQuery
Use parameters in a custom query
Visualize BigQuery GEOGRAPHY polygons with Looker Studio
BigQuery integrations
Accelerate BigQuery data with BI Engine
Set up a Google Cloud service account for Looker Studio
Connect to Google Cloud SQL for MySQL
Connect to Google Cloud Spanner
Connect to Google Cloud Storage
Connect to Microsoft SQL Server
Connect to MySQL
Connect to PostgreSQL
Connect to Amazon Redshift
Connect to spreadsheets, CSV files, and extracted data
Connect to Google Sheets
Create a report from Google Sheets
Connect to Microsoft Excel
Upload files & extract data
Upload CSV files to Looker Studio
Create and manage data sets
Extract data for faster performance
Connect to Google Marketing Platform products
Connect to Google Ads
Connect to Google Ad Manager 360
Connect to Google Analytics
Connect to Google Analytics
Google Analytics 4 sampling
Connect to Firebase (via BigQuery)
Connect to Campaign Manager 360
Connect to Display & Video 360
Connect to the New Search Ads 360
Connect to Search Console
Connect to YouTube Analytics
Developer connectors
Connect to Apigee
Connect to Appsheet
Community connectors
About community connectors
Community connector authorization
Community connector errors
Create and edit data sources
About data sources
Embedded data sources
Add data to a report
Edit a data source
Refresh data source fields
Manage data freshness
Manage auto refresh for a report
Delete a data source
Edit the data source connection
Copy a data source
Manage added reports and data sources
Connect Looker Studio to different Google accounts
Preview your data
Control access to your data
Data governance in Looker Studio: An overview
Data credentials
Filter by email address
Community connector authorization
Set up a Google Cloud service account for Looker Studio
Model your data
Model your data
Dates and times
Parameters
Query result variables
Aggregation
Data types
Work with fields in reports
Format fields in reports
Calculated fields
About calculated fields
Use functions in calculated fields
Add, edit, and troubleshoot calculated fields
Literals
Operators
Regular expressions in Looker Studio
Tutorial: Create calculated fields in Looker Studio
Tutorial: Create a ratio field based on filtered metrics
Convert Text and Numbers to Date and Date & Time
Create a custom group
Create a custom bin
Function list
Function references
Aggregation
AVG
COUNT
MAX
MEDIAN
MIN
PERCENTILE
SUM
VARIANCE
COUNT_DISTINCT
APPROX_COUNT_DISTINCT
STDDEV
Arithmetic
ACOS
ATAN
ABS
CEIL
COS
FLOOR
LOG
LOG10
ASIN
NARY_MAX
NARY_MIN
POWER
ROUND
SIN
SQRT
TAN
Conditional
CASE (Searched)
CASE (simple)
COALESCE
IF
IFNULL
NULLIF
Date
CURRENT_DATE
CURRENT_DATETIME
DATE
DATE_DIFF
DATETIME
DATETIME_ADD
DATETIME_DIFF
DATETIME_SUB
DATETIME_TRUNC
DAY
EXTRACT
HOUR
MINUTE
MONTH
QUARTER
SECOND
TODATE
TODAY
WEEK
WEEKDAY
YEAR
YEARWEEK
DATE_FROM_UNIX_DATE
UNIX_DATE
PARSE_DATE
PARSE_DATETIME
FORMAT_DATETIME
Geo
TOCITY
TOCONTINENT
TOCOUNTRY
TOREGION
TOSUBCONTINENT
Miscellaneous
CAST
HYPERLINK
IMAGE
NATIVE_DIMENSION
Text
CONCAT
CONTAINS_TEXT
ENDS_WITH
LEFT_TEXT
LENGTH
LOWER
REGEXP_CONTAINS
REGEXP_EXTRACT
REGEXP_MATCH
REGEXP_REPLACE
REPLACE
RIGHT_TEXT
STARTS_WITH
SUBSTR
TRIM
UPPER
Blend data
How blends work in Looker Studio
Create, edit, and manage blends
Blending tips and advanced concepts
Use blending to reaggregate data
Filter by multiple email addresses per row
Visualize
About reports
Create a report
Create a report from a template
Create a responsive report (Preview)
Copy a report
Report settings
Delete a report
Report publishing
Pause report updates
Edit reports
Edit report data
Work with fields in reports
Edit fields in your reports
Add comparison metrics and running totals
Add data to a report
View underlying data
Add and configure report components
Add charts and controls to your report
Modern charts
Configure report components
Add text, images, lines, and shapes to your reports
Types of charts in Looker Studio
Configure report components
Set report date ranges
Report and page layout
Add reference lines and reference bands to charts
Link to a page
Create custom bookmark links with report settings
Embed external content in reports
Add intervals to charts
Work with color
How to color your reports
Color your data
The dimension value color map
Themes
Use conditional formatting rules in Looker Studio
Copy and paste style
Chart references
Area chart reference
Bar chart and column chart reference
Bullet chart reference
Community visualizations (Developer Preview)
Gauge chart reference
Geo chart reference
Geo dimension reference
Google Maps reference
Add a Google Maps API key
Line chart and combo chart reference
Pie chart reference
Pivot table reference
Sankey chart reference
Scatter chart reference
Scorecard reference
Table reference
Time series reference
Treemap reference
Waterfall chart reference
Boxplot chart reference
Candlestick chart reference
Timeline chart reference
Funnel chart reference
Explore
Explore your data in Looker Studio
Apply persistent filter properties
About filter properties
Configure filter conditions
Filter examples
Add interactive controls
About controls
Add a quick filter
Date range control
Drop-down list and Fixed-size list
Input box control
Advanced filter control
Slider control
Checkbox control
Data control
Dimension control
Preset filter control
Apply controls to specific charts
Add drill actions to charts
Metric slider
Add buttons
Use controls across data sources
Use chart interactions to turn charts into filters
Chart cross-filtering
Metric slider
Optional metrics
Zoom and pan on charts
Share
Ways to share your reports
Roles and permissions
Invite others to your reports
Share reusable data sources
Embed a report
Download a Looker Studio report as PDF
Schedule automatic report delivery
Create alerts on a chart
Export data from a chart
Create a thumbnail image of your report
Stop sharing your reports and data sources
Complete data source ownership transfer
Transfer ownership
Share reports on social media
Get a link to your report
Get a personal report link
Share reports created with the Looker Studio Linking API
Manage
See what's changed in reports and data sources
Measure report usage
Remove or reconnect Looker Studio's access to your Google account
Change user interface language
Delete your Looker Studio service
Enterprise administration
Enterprise administrator feature overview
Resources
Looker Studio newsletter
The Report Gallery
Looker Studio ISO 27001 certification
Looker Studio FedRAMP authorization
Historical release notes
Report abuse
Solutions
Troubleshooting guide
Report a problem with Looker Studio
Improve Looker Studio performance
Hyperlinks in data
What does the 'Unable to aggregate ratio metrics' error mean?
Example reports
Missing data
Graph negative numbers
Dimension and metric improvements
Filter by multiple email addresses per row
Resolve invalid field name errors
How to add more than 10 AND/OR filters to a chart
Looker Studio Terms of Service and Policies
Looker Studio Terms of Service
Acceptable Use Policies
Additional languages
Privacy policy
Use Looker Studio with the Google Cloud Platform Agreement
About the General Data Protection Regulation (GDPR)
Data Processing Terms