||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.
Alternatively, click the question
mark icon () to use the report type selector.
|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 a field to organize data into groups from the
selected table. For example, in an incident report that is
grouped by Assignment group, all
incidents belonging to Software, Service Desk, Network, and
so on, are placed in separate groups. Make sure you give the
report a name that reflects the field you select.
to select additional group by fields. When you
select Additional group by
fields, a control is added to the bottom of the report
that groups the report by any one of the additional
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
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.
||Time period to group data by. Time periods range from an hour to a year. You
can also specify a date.
Note: Reporting per Week is not supported
when the report range includes more than one year. Inconsistent results are
produced when a week is split between two years.
||Select a computational method for aggregating report
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, 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 might
create a condition that states Priority +
less than + 3 – Moderate to have the
report include only records with priorities of
2 – High and 1 –
|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
false. In Eureka, this field is only available after at
least one filter condition has been created.
||Select fields to sort data by. For example, to sort results from lowest to
highest priority, select [Priority] [z to a]. For reports
with Group by, Stack by, Row/Column or Trend by fields to configure, you can sort by
fields that are not listed in the Group by, Stack by, Row/Column or Trend by
options. Add sort cannot be applied to dot-walked fields.