|Mathematical calculation to perform on the data. The default is
Count, which shows the number of records selected.
show 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.
Sum, or Count Distinct, to show 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 number.
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.