NumericalAggregationFunction - Amazon QuickSight

NumericalAggregationFunction

Aggregation for numerical values.

Contents

Note

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

PercentileAggregation

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

Type: PercentileAggregation object

Required: No

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.

Type: String

Valid Values: SUM | AVERAGE | MIN | MAX | COUNT | DISTINCT_COUNT | VAR | VARP | STDEV | STDEVP | MEDIAN

Required: No

See Also

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