|Mathematical calculation to perform on the data. The default is
Count, which displays the number of records selected.
To 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
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
Note: For duration values, the unit of measurement
displayed in the aggregation axis cannot be customized.