Skip to main content
Technology areas
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
Access and resources management
Costs and usage management
Infrastructure as code
Migration
SDK, languages, frameworks, and tools
/
Console
English
Deutsch
Español
Español – América Latina
Français
Indonesia
Italiano
Português
Português – Brasil
中文 – 简体
中文 – 繁體
日本語
한국어
Sign in
Looker
Looker Studio
Start free
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
Technology areas
More
Overview
Looker
More
Looker Studio
More
Guides
Cross-product tools
More
Console
Get started
Welcome to Looker Studio!
What you need to use Looker Studio
Quick start guide
Tutorials
Find your way around Looker Studio
Think with Looker Studio
A typical Looker Studio workflow
Looker Studio Qwik Start (Lab)
Report tutorials
Report tutorials introduction
View a Looker Studio report
Drill into your data
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
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
Release notes
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
Add Looker Studio content to your Google Slides presentation using Gemini assistance
Create calculated fields with Gemini assistance
Conversational Analytics
Conversational Analytics overview
Set up Conversational Analytics in Looker Studio
Create and manage data agents
Converse with Looker Studio data
Enable and use the Code Interpreter
Troubleshooting Gemini in Looker issues
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, and feature support
Overview of Looker connector permissions
Troubleshoot errors from the Looker connector
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
Model your data
Create, rename, copy, hide, and remove fields
Dates and times
Parameters
Query result variables
Aggregation
Data types
Filter properties
About filter properties
Configure filter conditions
Filter examples
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)
Edit a report
Copy a report
Rename reports, data sources, and blends
Report settings
Delete a report
Report publishing
Pause report updates
Set up reports
Set up chart data
Work with fields in reports
Edit fields in your reports
Format fields in 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
