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