AWS::QuickSight::Template NumericalAggregationFunction - AWS CloudFormation

AWS::QuickSight::Template NumericalAggregationFunction

Aggregation for numerical values.

Syntax

To declare this entity in your AWS CloudFormation template, use the following syntax:

Properties

PercentileAggregation

An aggregation based on the percentile of values in a dimension or measure.

Required: No

Type: PercentileAggregation

Update requires: No interruption

SimpleNumericalAggregation

Built-in aggregation functions for numerical values.

  • SUM: The sum of a dimension or measure.

  • AVERAGE: The average of a dimension or measure.

  • MIN: The minimum value of a dimension or measure.

  • MAX: The maximum value of a dimension or measure.

  • COUNT: The count of a dimension or measure.

  • DISTINCT_COUNT: The count of distinct values in a dimension or measure.

  • VAR: The variance of a dimension or measure.

  • VARP: The partitioned variance of a dimension or measure.

  • STDEV: The standard deviation of a dimension or measure.

  • STDEVP: The partitioned standard deviation of a dimension or measure.

  • MEDIAN: The median value of a dimension or measure.

Required: No

Type: String

Allowed values: SUM | AVERAGE | MIN | MAX | COUNT | DISTINCT_COUNT | VAR | VARP | STDEV | STDEVP | MEDIAN

Update requires: No interruption