AWS::QuickSight::DataSet AggregateOperation - Amazon CloudFormation
SyntaxProperties
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

This is the new Amazon CloudFormation Template Reference Guide. Please update your bookmarks and links. For help getting started with CloudFormation, see the Amazon CloudFormation User Guide.

AWS::QuickSight::DataSet AggregateOperation

A transform operation that groups rows by specified columns and applies aggregation functions to calculate summary values.

Syntax

To declare this entity in your Amazon CloudFormation template, use the following syntax:

JSON

{
  "Aggregations" : [ Aggregation, ... ],
  "Alias" : String,
  "GroupByColumnNames" : [ String, ... ],
  "Source" : TransformOperationSource
}

Properties

Aggregations

The list of aggregation functions to apply to the grouped data, such as SUM, COUNT, or AVERAGE.

Required: Yes

Type: Array of Aggregation

Minimum: 0

Maximum: 128

Update requires: No interruption

Alias

Alias for this operation.

Required: Yes

Type: String

Minimum: 1

Maximum: 64

Update requires: No interruption

GroupByColumnNames

The list of column names to group by when performing the aggregation. Rows with the same values in these columns will be grouped together.

Required: No

Type: Array of String

Minimum: 1 | 0

Maximum: 127 | 128

Update requires: No interruption

Source

The source transform operation that provides input data for the aggregation.

Required: Yes

Type: TransformOperationSource

Update requires: No interruption