AggregationFunction - Amazon QuickSight
ContentsSee Also
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).

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.

Contents

Note

In the following list, the required parameters are described first.

AttributeAggregationFunction

Aggregation for attributes.

Type: AttributeAggregationFunction object

Required: No

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.

Type: String

Valid Values: COUNT | DISTINCT_COUNT

Required: No

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.

Type: String

Valid Values: COUNT | DISTINCT_COUNT | MIN | MAX

Required: No

NumericalAggregationFunction

Aggregation for numerical values.

Type: NumericalAggregationFunction object

Required: No

See Also

For more information about using this API in one of the language-specific Amazon SDKs, see the following: