Home Madrid Analytics, Intelligence, and Reporting Analytics, Intelligence, and Reporting Reporting Administering reports Report ranges

Report ranges

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

Sometimes it can be helpful to group results into ranges or buckets rather than viewing every result as an individual score. Think of a bar or pie chart which shows a percentage result. By default each individual value from 0% – 100% would be a separate data point, creating an unnecessarily crowded-looking visual. However, segmenting the results into logical groups of scores can add context and help the audience understand which ranges are good, bad, or concerning. A report range is used to define data intervals for bar, pie, and donut charts. For example, if you're interested in understanding how many tasks were completed well within the SLA versus how many elapsed during the SLA.

Example use case: There is a significant cost involved to a business each time a SLA is breached at a company. A Service Manager can understand which SLAs are being easily met versus which ones are being breached, or are coming close to being breached. This information helps her identify which SLAs may need to be adjusted.

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.

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.

Navigate to Reports > Administration > Report Ranges.
Select New.

Fill in the form (see table):

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. Note: This field is required before you can select from the Element list.
Element	The table field to draw the values from.
Label	The name for the report range that is displayed in reports.
Value list	For 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. Note: When creating reports, colors may not display as specified for ranges on Group by report fields selected via dot-walking. For this feature to work appropriately, select applicable Group by fields from the base table only.
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. Note: When creating reports, colors may not display as specified for ranges on Group by report fields selected via dot-walking. For this feature to work appropriately, select applicable Group by fields from the base table only.
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.

Note: Once configured, a report range will show as empty if there's no data available in your report. Context fields such as data labels or legend related to the configured report range will still show and be highlighted.

Previous topic

Next topic

Send feedback

Release version

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.

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.

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.

Navigate to Reports > Administration > Report Ranges.
Select New.

Fill in the form (see table):

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. Note: This field is required before you can select from the Element list.
Element	The table field to draw the values from.
Label	The name for the report range that is displayed in reports.
Value list	For 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. Note: When creating reports, colors may not display as specified for ranges on Group by report fields selected via dot-walking. For this feature to work appropriately, select applicable Group by fields from the base table only.
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. Note: When creating reports, colors may not display as specified for ranges on Group by report fields selected via dot-walking. For this feature to work appropriately, select applicable Group by fields from the base table only.
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.

How search works:

Topics are ranked in search results by how closely they match your search terms

Report ranges

Report ranges

How report ranges work

View all report ranges

Create a report range

On this page

Report ranges

Report ranges

How report ranges work

View all report ranges

Create a report range

Log in to personalize your search results and subscribe to topics