||Enter a unique and descriptive name for the
||Click the information icon () to enter a more detailed description of what the
report does and its purpose.
||Specify the table or report source containing the data
set that you want to include in the report. From the first
choice list, select Table or
Report source. Then select the
specific table or predefined data set from the second choice
||Select Funnel or
the question mark icon () to use the report type selector.
|Style your chart
||Click the gear icon () to configure the chart style options for
the look of your chart.
||Select a field to organize data into groups from the selected table. For
example, in an incident report grouped by Assignment group,
all incidents that belong to Software, Service Desk, and Network are placed in
Note: It is not possible to group or stack reports by the
||Select this check box to display details of the report
data in a table below the chart.
All reports that use charts, including reports
that are used on dashboards, display the table of report data when the glide.ui.section508 system property is set to
true. The glide.ui.section508 property overrides the
Display data table field.
||Select a computational method for aggregating report data. The default is
Count, which displays the number of records
Select Count Distinct to display only unique
records. For example, 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. Users with more
than role would be counted twice unless you use count distinct.
select Average, Sum, or
Count Distinct, a list of fields from the selected
Table appears. 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.
Select the maximum number of groups such as bars, sections, or columns, that can
be displayed in the chart. If the number of values from the selected data exceeds
this limit, only groups for the largest values appear. By default, up to 12 of the
largest values from the selected data are represented. Remaining values can be
grouped on the Other bar.
If you select Show all, all groups up to a limit of 50 are
displayed. The rest of the results are grouped as Other. If
you select Remove Other, the Other
group is hidden.
||Select this check box to display the Other group for
values that exceed the No. groups limit. This check
box is not available when Show all or Remove
Other is selected from the Max number of groups
|Add Filter Condition
||Create conditions for filtering data to include in the
report. For example, to include only records with priorities
of 2- High and 1 -
Critical, select [Priority] [less
than] [3 - Moderate].
|Add "OR" Clause
||Select a second condition that must be met if the first
condition is invalid. For example, select
[Assignment Group] [is]
[Database], to include records that are
assigned to the Database group if the first condition is
|Add Sort Field
||Select fields to sort data by. For example, to sort
results from lowest to highest priority, select
[Priority] [z to a].