AWS::QuickSight::Template AggregationFunction

Filter View

All

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: 
    AttributeAggregationFunction
  CategoricalAggregationFunction: String
  DateAggregationFunction: String
  NumericalAggregationFunction: 
    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_COUNT

Update 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 | MAX

Update requires: No interruption

NumericalAggregationFunction

Aggregation for numerical values.

Required: No

Type: NumericalAggregationFunction

Update requires: No interruption