AWS::QuickSight::Analysis NumericalAggregationFunction

Aggregation for numerical values.

Syntax

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

JSON

{
  "PercentileAggregation" : PercentileAggregation,
  "SimpleNumericalAggregation" : String
}

YAML

  PercentileAggregation: 
    PercentileAggregation
  SimpleNumericalAggregation: String

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