Box reports

Box charts visualize the distribution of data including the maximum, minimum, quartiles, median, and mean.

Use box charts to report multiple data sets from different sources that are related to each other.

For example, use a box chart to view the age range of all customers who attended a convention. The box chart helps you determine where most ages are grouped. With this information, you can attempt to increase attendance levels at future events by targeting advertisements at the age groups that had lower attendance levels.
Figure 1. Box chart
A box chart displays the following information for each group of data:
Figure 2. Box chart scale
1. Sample maximum: the uppermost bold red line. 2. Upper quartile: the red line that forms the top of the box and cuts off the highest 25% of the data. 3. Median: the bold red line cutting through the box. 4. Mean: the blue dot inside the box. 5. Lower quartile: the red line that forms the bottom of the box and cuts off the lowest 25% of the data. 6. Sample minimum: the lowermost bold red line.
  1. Sample maximum
  2. Upper quartile
  3. Median
  4. Mean
  5. Lower quartile
  6. Sample minimum

Create a box report

Create a box report to show the distribution of values in a data set.

Before you begin

Role required: itil, report_group, report_global, report_admin, or admin. To create a meaningful report, you must have the right to access the data you want to report on.

Procedure

  1. Navigate to Reports > Create New.
  2. Fill in the fields, as appropriate.
    Table 1. Box Charts Creating Reports
    Field Description
    Name Enter a unique and descriptive name for your report.
    Description Click the information icon to enter a more detailed description of what the report does and its purpose.
    Data 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.
    Type Select Box. 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 chart.
    Group by 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.

    Click plus icon 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 fields.

    Note: It is not possible to group or stack reports by the Tags field.
    Measured by Select a field to use as a measurement for the data. Date and time fields are not supported for box charts.
    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 false.
    Add Sort Field Select fields to sort data by. For example, to sort results from lowest to highest priority, select [Priority] [z to a].
  3. Click Save or Insert.

What to do next

Add reports to homepages or dashboards, publish to the internet, schedule email distribution of PDFs or URLs of published reports, and share reports with others. For more information, see Distribute reports.

Box report style options

Change the look of your box report.

When you create or edit a report, click the gear icon (Cogwheel) after the Type field to open the Style your chart dialog box with options to configure the look of your chart. Chart options are automatically saved when you click Close. To see how the chart looks with the saved settings, click Save.

Table 2. Chart style options
Field Description
General
Custom chart size Select this check box to specify the chart's width and height in pixels.
Chart size Select a chart size. This field is available when Custom chart size is cleared.
Decimal Precision Enter an integer from 0 to 4 to specify the number of decimal places to display. Currency values always have two decimal places.
Title
Show chart title Select when the chart title is displayed.
  • Never: never displays the chart title.
  • Report only: displays the chart title on reports.
  • Always: displays the chart title on reports, and dashboards and homepage.
Chart title Enter a title for this chart. The title has a maximum length of 40 characters. If no title is entered, the report name is used for the title. This field is available when Report only or Always is selected from the Show chart title list.
Chart title size Enter the size of the chart title in pixels. This field is available when Report only or Always is selected from the Show chart title list.
Chart title color Select the color for the chart title. This field is available when Report only or Always is selected from the Show chart title list.
Custom chart title position Select this check box to specify the X and Y coordinates for the position of the chart title. This field is available when Report only or Always is selected from the Show chart title list.
Title horizontal alignment Select how the chart title is aligned horizontally. This field is available when Custom chart title position is cleared.
Title vertical alignment Select how the chart title is aligned vertically. This field is available when Custom chart title position is cleared.
Axis
Axis button Configure the titles, appearance, and labels of the X and Y axis. For the Y axis, you can also specify a From and To range.