Skip to main content
Technology areas
close
AI and ML
Application development
Application hosting
Compute
Data analytics and pipelines
Databases
Distributed, hybrid, and multicloud
Industry solutions
Migration
Networking
Observability and monitoring
Security
Storage
Cross-product tools
close
Access and resources management
Costs and usage management
Infrastructure as code
SDK, languages, frameworks, and tools
/
Console
English
Deutsch
Español – América Latina
Français
Indonesia
Italiano
Português – Brasil
中文 – 简体
中文 – 繁體
日本語
한국어
Sign in
Data Studio
Start free
Overview
Guides
Community
Technology areas
More
Overview
Guides
Community
Cross-product tools
More
Console
Get started
Welcome to Data Studio
What you need to use Data Studio
Quick start guide
Tutorials
Think with Data Studio
A typical Data Studio workflow
Data Studio Qwik Start (Lab)
Report tutorials
Report tutorials introduction
View a Data 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 Data Studio
Tutorial: Create a ratio field based on filtered metrics
How to use the Data 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
Data Studio Pro
About Data Studio Pro
Try Data Studio Pro
Data Studio Pro Essentials (Cloud Skills Boost Course)
Subscribe to Data Studio Pro
Data 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 Data Studio Pro licenses
Organize and manage Data Studio Pro content
About Data Studio Pro content
Upgrade Data Studio content to Data 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 Data Studio Pro
Manage Data Studio Pro subscriptions
Edit a Data Studio Pro subscription
Link Data Studio Pro to different projects within your organization
Link a Data Studio Pro monthly active user subscription to a Google Cloud project
Consolidate multiple Data Studio Pro subscriptions
Cancel a Data Studio Pro subscription
Change your Data Studio Pro billing account
Troubleshoot "Project is a valid Google Cloud project and you have the permissions" error
Gemini assistance
Gemini in Data Studio overview
Troubleshooting Gemini issues in Data Studio
Enable and disable Gemini in Data Studio
Add Data Studio content to Slides with Gemini assistance
Create calculated fields with Gemini assistance
Conversational Analytics
Conversational Analytics overview
Set up Conversational Analytics in Data Studio
Data agents in Data Studio
Converse with Data Studio data
Enable and use the Code Interpreter
Connect
About connectors, data sources, and credentials
Available connectors
Connector references
Connect to Looker
Connect to Looker
Understand Looker Explore data on a Data 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 Data 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 Data Studio
BigQuery integrations
Accelerate BigQuery data with BI Engine
Set up a Google Cloud service account for Data 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 Data 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
Replace the data source for a component, page, or report
Copy a data source
Manage added reports and data sources
Connect Data Studio to different Google accounts
Preview your data
Control access to your data
Data governance in Data Studio: An overview
Data credentials
Filter by email address
Model
Model your data
Create, rename, copy, hide, and remove fields
Dates and times
Parameters
Query result variables
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 Data Studio
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 Data Studio
Create, edit, and manage blends
Blending tips and advanced concepts
Use blending to reaggregate data
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
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
Set report date ranges
Report and page layout
Add reference lines and reference bands to charts
Link to a page or component
Create custom bookmark links with report settings
Embed external content in reports
Add intervals to charts
Hide report components for viewers
Work with color
How to color your reports
Color your data
The dimension value color map
Themes
Use conditional formatting rules in Data Studio
Copy and paste style
Chart references
Types of charts in Data Studio
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 Data Studio
Add interactive controls
About controls
Add and edit 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
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 Data Studio report as PDF
Schedule automatic report delivery
Share and schedule reports with Slack
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 Data Studio Linking API
Manage
Enterprise administration
See what's changed in reports and data sources
Measure report usage
Data Studio Pro audit logging
Remove or reconnect Data Studio's access to your Google account
Change user interface language
Delete your Data Studio service
Resources
Data Studio newsletter
The Report Gallery
Data Studio ISO 27001 certification
Data Studio FedRAMP authorization
Report abuse
Solutions
Troubleshooting guide
Report a problem with Data Studio
Improve Data 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
Resolve invalid field name errors
How to add more than 10 AND/OR filters to a chart
Data Studio Terms of Service and Policies
Acceptable Use Policy
