Enum AggregationType
Stay organized with collections
Save and categorize content based on your preferences.
AggregationType
An enum that defines the aggregation types that can be set for a Field.
To call an enum, you call its parent class, name, and property. For example,
DataStudioApp.AggregationType.AVG.
Properties
| Property | Type | Description |
AVG | Enum | Average. |
COUNT | Enum | Count. |
COUNT_DISTINCT | Enum | Count Distinct. |
MAX | Enum | Max. |
MIN | Enum | Min. |
SUM | Enum | Sum. |
AUTO | Enum | Auto. Use Auto for calculated fields which reference an aggregated field. |
Deprecated properties
| Property | Type | Description |
NO_AGGREGATION | Enum | DEPRECATED: Use AUTO instead. No aggregation. |
Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see the Google Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2024-12-02 UTC.
[null,null,["Last updated 2024-12-02 UTC."],[[["\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. |"]]
