[go: up one dir, main page]

跳至主要內容
Google Cloud
Documentation 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
  • Google Cloud SDK, languages, frameworks, and tools
  • Infrastructure as code
  • Migration
Related sites
  • 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
  • 中文 – 简体
  • 中文 – 繁體
  • 日本語
  • 한국어
控制台 登入
  • Looker Studio
總覽
  • 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
  • Guides
    How-to guides and feature descriptions
  • Community
    Community forum for Looker Studio
指南
Contact Us Start free
Google Cloud
  • Documentation
    • 總覽
    • Looker
      • 更多
    • Looker Studio
      • 更多
    • 指南
  • Technology areas
    • 更多
  • Cross-product tools
    • 更多
  • Related sites
    • 更多
  • 控制台
  • 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
    • Data agents in Looker
    • Data agents in Looker Studio
    • 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, 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
  • 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)
  • Copy a report
  • 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
    • 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
  • 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
  • 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 Looker Studio Linking API
  • Manage
  • Enterprise administration
  • 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
  • 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
    • Looker Studio HIPAA implementation guide
    • HIPAA Business Associate Addendum
    • Looker Studio Galleries Terms of Service (Submitter)
    • Looker Studio Galleries Terms of Service (User) UPDATED
  • 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
  • Access and resources management
  • Costs and usage management
  • Google Cloud SDK, languages, frameworks, and tools
  • Infrastructure as code
  • Migration
  • 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
  • Guides
  • Best Practices
  • LookML Reference
  • API Reference
  • Resources
  • Community
  • Guides
  • Community
本頁面由 Cloud Translation API 翻譯而成。
  • 首頁
  • Documentation
  • Data analytics
  • Looker Studio

指標

套用至一組值的特定匯總。

指標是來自基礎資料集的匯總資料,或是隱含或明確套用匯總函式 (例如 COUNT()、SUM() 或 AVG()) 的結果。指標本身沒有定義的值組,因此您無法像使用維度那樣,依指標進行分組。

相關資源

關於資料建模

除非另有註明,否則本頁面中的內容是採用創用 CC 姓名標示 4.0 授權,程式碼範例則為阿帕契 2.0 授權。詳情請參閱《Google Developers 網站政策》。Java 是 Oracle 和/或其關聯企業的註冊商標。

上次更新時間:2025-10-19 (世界標準時間)。

  • 選用 Google 的理由

    • 選擇 Google Cloud
    • 信任與安全性
    • 新型基礎架構雲端
    • 多雲端
    • 全球基礎架構
    • 客戶與個案研究
    • 分析師報告
    • 白皮書
  • 產品與定價

    • 查看所有產品/服務
    • 查看所有解決方案
    • Google Cloud for Startups
    • Google Cloud Marketplace
    • Google Cloud 定價
    • 與銷售人員聯絡
  • 支援服務

    • Community forums
    • 支援服務
    • 版本資訊
    • 系統狀態
  • 實用資源

    • GitHub
    • 開始使用 Google Cloud
    • Google Cloud 說明文件
    • 程式碼範例
    • 雲端架構中心
    • 訓練與認證
    • 開發人員中心
  • 互動交流

    • 網誌
    • 活動
    • X (Twitter)
    • Google Cloud 的 YouTube 頻道
    • Google Cloud Tech 的 YouTube 頻道
    • 成為合作夥伴
    • Google Cloud Affiliate Program
    • 新聞中心
  • 關於 Google
  • 隱私權
  • 網站條款
  • Google Cloud 服務條款
  • Manage cookies
  • 我們的第三個十年氣候計畫:加入我們
  • 訂閱 Google Cloud 電子報 訂閱
  • English
  • Deutsch
  • Español
  • Español – América Latina
  • Français
  • Indonesia
  • Italiano
  • Português
  • Português – Brasil
  • 中文 – 简体
  • 中文 – 繁體
  • 日本語
  • 한국어