AWS::QuickSight::Template 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 Amazon CloudFormation template, use the following syntax:
JSON
{ "CategoricalAggregationFunction" :String, "DateAggregationFunction" :String, "NumericalAggregationFunction" :NumericalAggregationFunction}
YAML
CategoricalAggregationFunction:StringDateAggregationFunction:StringNumericalAggregationFunction:NumericalAggregationFunction
Properties
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 | MAX | MINUpdate requires: No interruption
-
NumericalAggregationFunction-
Aggregation for numerical values.
Required: No
Type: NumericalAggregationFunction
Update requires: No interruption