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 PivotOperation
A transform operation that pivots data by converting row values into columns.
Syntax
To declare this entity in your Amazon CloudFormation template, use the following syntax:
JSON
{ "Alias" :String, "GroupByColumnNames" :[ String, ... ], "PivotConfiguration" :PivotConfiguration, "Source" :TransformOperationSource, "ValueColumnConfiguration" :ValueColumnConfiguration}
YAML
Alias:StringGroupByColumnNames:- StringPivotConfiguration:PivotConfigurationSource:TransformOperationSourceValueColumnConfiguration:ValueColumnConfiguration
Properties
Alias-
Alias for this operation.
Required: Yes
Type: String
Minimum:
1Maximum:
64Update requires: No interruption
GroupByColumnNames-
The list of column names to group by when performing the pivot operation.
Required: No
Type: Array of String
Minimum:
1 | 0Maximum:
127 | 128Update requires: No interruption
PivotConfiguration-
Configuration that specifies which labels to pivot and how to structure the resulting columns.
Required: Yes
Type: PivotConfiguration
Update requires: No interruption
Source-
The source transform operation that provides input data for pivoting.
Required: Yes
Type: TransformOperationSource
Update requires: No interruption
ValueColumnConfiguration-
Configuration for how to aggregate values when multiple rows map to the same pivoted column.
Required: Yes
Type: ValueColumnConfiguration
Update requires: No interruption