Aggregation in reporting

  • Rversion finale: Australia
  • Mis à jour 12 mars 2026
  • 1 minute de lecture

    • Aggregation enables you to apply calculations to data displayed in reports.

    • The count aggregation gives the number of records in each element of a report.
    • Count distinct provides the count of unique values for a given field.
    • Average shows the arithmetic mean of the values for a given field.
    • Sum shows the total of the aggregated values.
    • Minimum and Maximum show the least or greatest values for each displayed category.
    • Standard deviation shows data variation from the average value for a given field.

    If you choose Average,Sum, Count Distinct, Minimum, Maximum, or Standard deviation, you may be able to aggregate on fields from extended tables. See How to report on extended tables.

    For information about aggregating on FX currency values, see FX Currency values in reporting.

    Remarque :
    Aggregation is not supported on histogram, pareto, single score, box, calendar, and list reports.