AWS::QuickSight::Analysis AggregationFunction
An aggregation function aggregates values from a dimension or measure.
This is a union type structure. For this structure to be valid, only one of the attributes can be defined.
Syntax
To declare this entity in your AWS CloudFormation template, use the following syntax:
JSON
{ "AttributeAggregationFunction" :AttributeAggregationFunction, "CategoricalAggregationFunction" :String, "DateAggregationFunction" :String, "NumericalAggregationFunction" :NumericalAggregationFunction}
YAML
AttributeAggregationFunction:AttributeAggregationFunctionCategoricalAggregationFunction:StringDateAggregationFunction:StringNumericalAggregationFunction:NumericalAggregationFunction
Properties
AttributeAggregationFunction-
Aggregation for attributes.
Required: No
Type: AttributeAggregationFunction
Update requires: No interruption
CategoricalAggregationFunction-
Aggregation for categorical values.
-
COUNT: Aggregate by the total number of values, including duplicates. -
DISTINCT_COUNT: Aggregate by the total number of distinct values.
Required: No
Type: String
Allowed values:
COUNT | DISTINCT_COUNTUpdate requires: No interruption
-
DateAggregationFunction-
Aggregation for date values.
-
COUNT: Aggregate by the total number of values, including duplicates. -
DISTINCT_COUNT: Aggregate by the total number of distinct values. -
MIN: Select the smallest date value. -
MAX: Select the largest date value.
Required: No
Type: String
Allowed values:
COUNT | DISTINCT_COUNT | MIN | MAXUpdate requires: No interruption
-
NumericalAggregationFunction-
Aggregation for numerical values.
Required: No
Type: NumericalAggregationFunction
Update requires: No interruption
