||Enter a unique and descriptive name for your
||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 list.
||Select Line. Alternatively, click the question mark
icon to use the
|Style your chart
||Click the gear icon after the
Type field and configure the
chart style options to edit the layout and look of your
||Select the field that you want to group the report
data by. For example, in an incident report that is grouped
by Assignment group, all incidents
belonging to Software, Service Desk, Network, and so on, are
grouped together. Make sure you give the report a name that
reflects the field you select.
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 as gauges on
homepages, display the table of report data details if
the glide.ui.section508 system
property is set to true, even if
Display Grid is
||Select the table field whose values you want to
display in a time sequence.
||Select the time period to display in the chart. Time
periods range from a year down to an hour. You can also
select a specific date.
||Select a computational method for aggregating report
data. The default is Count, which
displays the number of records selected.
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
, or Count
, a list of fields from the
selected Table appears. From this list, select a
field to aggregate by. For example, if you select a
duration field, such as the Business
field on the Incident table,
the aggregated data is expressed in days, hours, and
minutes. If you select an integer field, such as the
field, the data is
expressed as a number.
Note: For duration values,
you cannot customize the unit of measurement
displayed in the aggregation
||Select a computational method used for calculating
percentages for each element (selected record) in a data
This field is only available when
Aggregation is set to
Sum, or Count
- Use Aggregation: default
method that computes percentages for each element
using the sum of all elements in the data set.
- Use Record Count:
computes percentages for each element using the
total number (count) of elements in the data set.
|Add Filter Condition
for filtering and ordering data. For example, you can create
a condition that states Priority + less than + 3
- Moderate to have the report include only
records with priorities of 2- High
and 1 - Critical.
|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].