|Mathematical calculation to perform on the data. The default is
Count, which displays the number of records selected.
display only unique records, select Count Distinct. For
example, if you want a report on the distinct number of users who have one or more
of the roles in a given list of roles. Users with more than one role would be
counted twice unless you use Count Distinct.
Average, Sum, or Count
Distinct, to display a list of fields from the selected
Table. Select a field to aggregate by from this list. For
example, if you select a duration field, such as Business
duration on the Incident table, the aggregated data is expressed in
days, hours, and minutes. If you select an integer field, such as
Priority, the data is expressed as a decimal value
If you choose Sum or
Average, select Show related
fields to aggregate on dot-walked fields. See Dot-walking
Note: For duration values, the unit of measurement displayed in the
aggregation axis cannot be customized.