Enum AggregationType
透過集合功能整理內容
你可以依據偏好儲存及分類內容。
匯總類型列舉項目,定義可為 Field
設定的匯總類型。
如要呼叫列舉,請呼叫其父項類別、名稱和屬性。例如
DataStudioApp.AggregationType.AVG
。
屬性
屬性 | 類型 | 說明 |
AVG | Enum | 平均。 |
COUNT | Enum | 計數。 |
COUNT_DISTINCT | Enum | 不重複值的計數。 |
MAX | Enum | 最新 |
MIN | Enum | 最舊 |
SUM | Enum | 總和。 |
AUTO | Enum | 自動。針對參照匯總欄位的計算結果欄位,請使用「自動」。 |
已淘汰的屬性
屬性 | 類型 | 說明 |
NO_AGGREGATION | Enum | 已淘汰:請改用 AUTO 。不匯總。 |
除非另有註明,否則本頁面中的內容是採用創用 CC 姓名標示 4.0 授權,程式碼範例則為阿帕契 2.0 授權。詳情請參閱《Google Developers 網站政策》。Java 是 Oracle 和/或其關聯企業的註冊商標。
上次更新時間:2025-07-26 (世界標準時間)。
[null,null,["上次更新時間:2025-07-26 (世界標準時間)。"],[[["\u003cp\u003e\u003ccode\u003eAggregationType\u003c/code\u003e is an enum used to define how data is aggregated within a \u003ca href=\"/apps-script/reference/data-studio/field\"\u003eField\u003c/a\u003e in Data Studio.\u003c/p\u003e\n"],["\u003cp\u003eYou can call an AggregationType enum through its parent class like so: \u003ccode\u003eDataStudioApp.AggregationType.AVG\u003c/code\u003e.\u003c/p\u003e\n"],["\u003cp\u003eAvailable aggregation types include \u003ccode\u003eAVG\u003c/code\u003e, \u003ccode\u003eCOUNT\u003c/code\u003e, \u003ccode\u003eCOUNT_DISTINCT\u003c/code\u003e, \u003ccode\u003eMAX\u003c/code\u003e, \u003ccode\u003eMIN\u003c/code\u003e, \u003ccode\u003eSUM\u003c/code\u003e, and \u003ccode\u003eAUTO\u003c/code\u003e, with \u003ccode\u003eAUTO\u003c/code\u003e recommended for calculated fields referencing an aggregated field.\u003c/p\u003e\n"],["\u003cp\u003eThe \u003ccode\u003eNO_AGGREGATION\u003c/code\u003e enum is deprecated; use \u003ccode\u003eAUTO\u003c/code\u003e instead.\u003c/p\u003e\n"]]],["`AggregationType` is an enum defining aggregation options for a `Field`. It includes properties like `AVG`, `COUNT`, `COUNT_DISTINCT`, `MAX`, `MIN`, `SUM`, and `AUTO`. These represent the types of calculations that can be applied to a field's data. `AUTO` is used for calculated fields that reference aggregated data. The `NO_AGGREGATION` property is deprecated and `AUTO` should be used instead. Each enum can be called by its parent class, name, and property.\n"],null,["# Enum AggregationType\n\nAggregationType\n\nAn enum that defines the aggregation types that can be set for a [Field](/apps-script/reference/data-studio/field).\n\nTo call an enum, you call its parent class, name, and property. For example, `\nDataStudioApp.AggregationType.AVG`. \n\n### Properties\n\n| Property | Type | Description |\n|------------------|--------|---------------------------------------------------------------------------|\n| `AVG` | `Enum` | Average. |\n| `COUNT` | `Enum` | Count. |\n| `COUNT_DISTINCT` | `Enum` | Count Distinct. |\n| `MAX` | `Enum` | Max. |\n| `MIN` | `Enum` | Min. |\n| `SUM` | `Enum` | Sum. |\n| `AUTO` | `Enum` | Auto. Use Auto for calculated fields which reference an aggregated field. |\n\n### Deprecated properties\n\n| Property | Type | Description |\n|------------------|--------|-------------------------------------------------|\n| `NO_AGGREGATION` | `Enum` | DEPRECATED: Use `AUTO` instead. No aggregation. |"]]