NumericalAggregationFunction - 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).

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 Amazon SDKs, see the following: