Column reports

Column reports show how the value of one or more items changes over time by with columns.

Values along the horizontal axis of the column chart represent the time measurement (years, hours, minutes, milliseconds, and so on). Values on the vertical axis represent the changes to the items being monitored. Users with the report_admin role can define the ranges that are used in a column chart report. See Report ranges for information on creating report ranges.

For example, you can create a column chart for incident counts, to show how the number of incidents changes over time. The incident count often increases during the first few months after a product upgrade is deployed. Over time, the number of reported incidents decreases as users become more accustomed to the changes in the product.

The figure shows resolved incidents stacked by category with a legend that indicates which category the colors represent.
Figure 1. Stacked column chart
Column chart
A grouped column chart shows the categories as individual bars, rather than stacked colors in a single bar.
Figure 2. Grouped column chart
Column chart 2

Create a column report

Create a column report to show how the value of one or more data element changes over time using vertical columns.

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. Column chart
    Field Description
    Name Enter a unique and descriptive name for your report.
    Description Click the information icon (Detailed description) 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 Column.
    Style your chart Click the gear icon (Cogwheel) 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.
    Stacked / Grouped columns Choose to display the Group by field as stacked columns or grouped columns. For example, if a report groups incidents by state and the Group by field is Category, selecting Stacked shows the incidents in one column by state with different colors for each category. Selecting Grouped columns shows the incidents in separate columns for each state with different colors for each category column.

    The Stacked and Grouped columns options are not available when None is selected from the Group by list.

    Display Grid 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 the Display Grid check box is cleared.

    Trend by Select the table field whose values you want to display in a time sequence.
    per Select a time period to display in the chart. Time periods range from a year down to an hour. You can also select a specific date.
    Aggregation Select a computational method for aggregating report data. The default is Count, which displays the number of records selected.

    If you 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 Average, Sum, or Count Distinct, 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 duration field on the Incident table, the aggregated data is expressed in days, hours, and minutes. If you select an integer field, such as the Priority field, the data is expressed as a number.

    Note: For duration values, the unit of measurement displayed in the aggregation axis cannot be customized.
    Percentages Select a computational method used for calculating percentages for each element in a data set.
    • Use Aggregation: default method. 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.

    This field is only available when Aggregation is set to Average, Sum, or Count Distinct.

    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. The report is generated.

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.

Column report style options

Change the look of your column report.

When you create or edit a report, click the gear icon (Cogwheel) after the Type field to open the Style your chart window 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. Column chart style options
Field Description
General
Chart color If no group by is used, Use one color is automatically selected. Select a single predefined system color.
If a group by or stack by is used, select one of the following options:
  • Use color palette: Select a color palette from the predefined system color palettes.
  • Use several colors: Define a custom set of Colors using hex codes. You can add any number of colors.
  • Use chart colors: Use the colors defined in Reports > Chart Colors.
Display data labels Select this check box to display the current score for the start and end points of the column.
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.
Drilldown View Select a view that determines how detailed records are shown when a specific part of the chart is clicked. This option is available for charts with drill-down capabilities. If you select a view that has no fields in common to link to the table that the report is based on, the default view is used. See Drilling down within reports .
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, dashboards, and homepages.
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 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.
Legend
Show legend Select this check box to display a chart legend. This check box is available when a Group by field is selected in the visualization fields.
Legend horizontal alignment Select how the legend is aligned horizontally. This field is available when Show legend is selected.
Legend vertical alignment Select how the legend is aligned vertically. This field is available when Show legend is selected.
Left align legend text Select to left-align the legend text. By default, legend text is centered.
Show legend border Select this check box to display a border around the legend. This check box is available when Show legend is selected.
Axis
Axis tab 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.