Skip to main content
Google Cloud Documentation
Documentation
  • Get Started
  • Get Started with Google Cloud
  • Product List
  • Cloud Customer Care
  • Featured Products
  • Agent Platform
  • Apigee API Management
  • BigQuery
  • Compute Engine
  • Cloud CDN
  • Cloud Run
  • Cloud Storage
  • Cloud SQL
  • Gemini Enterprise
  • Google Kubernetes Engine
  • Looker
  • Cross-product Tools
  • Access and resources management
  • Costs and usage management
  • Infrastructure as code
  • SDK, languages, frameworks, and tools
  • Technology Areas
  • 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
/
Console
  • English
  • Deutsch
  • Español
  • Español – América Latina
  • Français
  • Indonesia
  • Italiano
  • Português
  • Português – Brasil
  • עברית
  • 中文 – 简体
  • 中文 – 繁體
  • 日本語
  • 한국어
Sign in
  • Data Studio
Start free
Overview Guides Community
Google Cloud Documentation
  • Documentation
    • More
    • Overview
    • Guides
    • Community
  • 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
  • Data Studio Pro subscription overview
  • Data Studio Pro roles and permissions
  • Data Studio Pro Essentials (Cloud Skills Boost Course)
  • Subscribe to Data Studio Pro
    • 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
    • Enable cross-organizational access with Trusted Orgs
    • 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 selection error during Data Studio Pro activation
  • Security and compliance
    • Overview
    • Set up data residency
    • Use customer-managed encryption keys (CMEK)
    • Use customer-managed storage
  • 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
  • Configure network access for Data Studio
  • 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 Google BigQuery
        • Connect to BigQuery
        • Connect to date partitioned tables
        • Use parameters in a custom query
        • Optimize performance
        • Monitor and analyze queries
        • Security and governance
        • Set up a Google Cloud service account
        • Visualize BigQuery GEOGRAPHY polygons
        • Troubleshoot BigQuery errors and limitations
      • 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
        • APPROX_COUNT_DISTINCT
        • AVG
        • COUNT
        • COUNT_DISTINCT
        • MAX
        • MEDIAN
        • MIN
        • PERCENTILE
        • STDDEV
        • SUM
        • VARIANCE
      • Arithmetic
        • ABS
        • ACOS
        • ASIN
        • ATAN
        • CEIL
        • COS
        • FLOOR
        • LOG
        • LOG10
        • 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
        • DATE_FROM_UNIX_DATE
        • DATETIME
        • DATETIME_ADD
        • DATETIME_DIFF
        • DATETIME_SUB
        • DATETIME_TRUNC
        • DAY
        • EXTRACT
        • FORMAT_DATETIME
        • HOUR
        • MINUTE
        • MONTH
        • PARSE_DATE
        • PARSE_DATETIME
        • QUARTER
        • SECOND
        • TODATE
        • TODAY
        • UNIX_DATE
        • WEEK
        • WEEKDAY
        • YEAR
        • YEARWEEK
      • 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?
    • 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
    • Privacy Policy
    • Data Studio Terms of Service
    • Additional languages
    • Use Data Studio with the Google Cloud Platform Agreement
    • Data Processing Terms
    • About the General Data Protection Regulation (GDPR)
    • Data Studio HIPAA Implementation Guide
    • HIPAA Business Associate Addendum
    • Data Studio Galleries Terms of Service (Submitter)
    • Data Studio Galleries Terms of Service (User) UPDATED
  • Historical release notes
  • Get Started
  • Get Started with Google Cloud
  • Product List
  • Cloud Customer Care
  • Featured Products
  • Agent Platform
  • Apigee API Management
  • BigQuery
  • Compute Engine
  • Cloud CDN
  • Cloud Run
  • Cloud Storage
  • Cloud SQL
  • Gemini Enterprise
  • Google Kubernetes Engine
  • Looker
  • Cross-product Tools
  • Access and resources management
  • Costs and usage management
  • Infrastructure as code
  • SDK, languages, frameworks, and tools
  • Technology Areas
  • 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
Looker Studio is now called Data Studio. Learn more about this change.
  • Home
  • Documentation
  • Data analytics
  • Data Studio