|Select a computational method for aggregating report data.
The default is Count, which displays the
number of records selected.
If you select Count
Distinct, only unique records are counted.
For example, if you want to generate a report with a
distinct number of users who have one or more of the roles
in a given list of roles, these users would be counted twice
unless you use count distinct.
If you select
Sum, or Count
Distinct, this displays an additional list
of fields from the selected Table.
From this list, select a field to aggregate by. For example,
if you select a duration field, such as the
Business duration field on the
Incident table, the aggregated data is expressed in days,
hours, and minutes. If you select an integer field, such as
the Priority field, the data is expressed as a
number. If a value in a column being aggregated has a comma,
the value will be separated by the comma, and the
aggregation will not be performed accurately.
Note: For duration values, the unit of measurement displayed
in the aggregation axis cannot be customized.