Report ranges

Use a report range to define data intervals that are used in bar and pie charts.

Note: Reports only show historical data. It is not possible to set report ranges for dates in the future.
Figure 1. Incidents created date with ranges
Note: The module for report ranges is hidden by default. You may need to enable the module before use. For more information, see Enable or disable an application menu or module .

How report ranges work

Report ranges work with elements that hold only dates, lists, or integers.

Table 1. Report range elements list
Type Examples
Dates Using the Created field in the Incidents table: Same Day, 2 Days, 2–5 Days, 5–7 Days, 1–2 Weeks, 2–4 Weeks, 1–2 Months, > 2 Months
Lists Using the Priority field in the Incidents table: Low, Moderate, High, Critical, Planning
Integers Using the Count field in the Incidents table: Overloaded, Optimized, Under Utilized

Report ranges can be globally applied to all date type fields (date, due date, duration, date/time, date time), or you can limit report ranges to a specific table.

View all report ranges

To view all currently configured report ranges, navigate to Reports > Administration > Report Ranges.

Figure 2. Report ranges list

The following are important columns and their associated data types:

Table 2. Report range list field
Field Corresponding data type
Upper value duration Date - works with elements that store dates.
Upper value int Integer - works with elements that store numbers.
Value list List - works with elements that store a list item.

Create a report range

Create a report range to define data intervals that are used in bar and pie charts.

  1. Navigate to Reports > Administration > Report Ranges.
  2. Select New.
  3. Fill in the form (see table):
    New report ranges form

    Use the following fields to refine the data displayed in the report and to design the appearance of your line chart:

    Table 3. Report range form fields
    Field Description
    Name The name of the table to draw the values from.
    Element The table field to draw the values from.
    Label The name for the report range that is displayed in reports.
    Value list For choice list elements, this field defines which values are within the range. After the range is saved, the value list is populated with the choices of the element.
    Color name The color to display this report range in. The color appears in the Display field. If you enter a color name, you do not need to enter a color value.
    Color The hexadecimal value for the color to report this report range in. The color appears in the Display field. If you enter a value for color, you do not need to enter a color name.
    Upper value int For integer-type elements, this field defines the upper limit of the range. The upper value of the report range with nearest lower Order defines the lower limit of this range. If no range with a lower Order exists, the lower limit is zero.

    Example: One report range has an upper limit of 10 and an Order of 20. A second report range has an upper limit of 5 and the Order of 19. Values from 5 to 10 display the formatting specified by this range.

    Upper value duration For duration-type elements, this field defines the upper limit of the range. The upper value of the report range with nearest lower Order defines the lower limit of this range. If no range with a lower Order exists, the lower limit is zero.

    Example: One report range has an upper limit of 10 and an Order of 20. A second report range has an upper limit of 5 and the Order of 19. Values from 5 to 10 display the formatting specified by this range.

    Display Read-only. Shows the color that is used for the specific report range.
    Order The order in which the report ranges are used. If a value is defined within more than one label, it is reported under the report range with the lowest order.