Heatmap charts

Heatmap charts display aggregate data visually using colors to represent different values.

Note: Heatmap reports can have no more than 1000 cells.
Figure 1. Heatmap Report

Create a heatmap report

Create a heatmap report to display aggregate data visually using colors to represent different values.

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 (see table).
    Table 1. Fields
    Field Description
    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 Heatmap

    Alternatively, click the question mark icon (The question mark icon) to use the report type selector.

    Style your chart Click the gear icon (The gear icon) after the Type field to configure chart style options for the look and layout of the chart.
    Row Select the field used as the source of the data for the rows in the heatmap.
    Column Select the field used as the source of the data for the columns in the heatmap
    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, this displays an additional list of fields from the selected Table. 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. If a value in a column being aggregated has a comma, the value is separated by the comma, and the aggregation is not performed accurately.

    Note: For duration values, the unit of measurement displayed in the aggregation axis cannot be customized.
    No. groups Select the maximum number of individual values that can be represented as columns. By default, Pivot charts display up to 12 of the largest values from the selected data. Remaining values are grouped into an Other category. If you select Show all, all values up to a limit of 50 bars are displayed. The rest of the results are stacked on the Other column. If you select Remove Other, the Other column is hidden.
    Show Other Select this check box to display the Other column. This check box is not available when Show all or Remove Other are selected from the No. groups list.
    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.
  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. See Distribute reports.

Heatmap style options

Change the look of your heatmap chart.

When you create or edit a report, click the gear icon (The gear icon) 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. Heatmap chart style options
General
Use color Heatmap Select if the heatmap uses different colors to indicate different values.
Heatmap Max color Select the color used to indicate a high value on the chart.
Heatmap Min color Select the color used to indicate a low value on the chart.
Display Zero labels Select this check box to display the number 0 when the value of a cell is 0. Clear this check box to display an empty cell when the value of the cell is 0.
Drilldown view Select a view to filter the data based on that view.
Title
Show chart title Select when to display the chart title. You can hide the title, display the title only on the report form, or always display the title.
Chart title Enter a title for the chart.
Chart title size Enter the font size for the chart title.
Chart title color Select a text color for the chart title.
Custom chart title position Select whether the chart title appears at a fixed position.
Chart title X position The number of pixels to adjust the chart title position. By default the title appears at the center top of the chart. Set a value greater than 0 to move the chart title down.

This field appears only if Custom chart title position is selected.

Chart title Y position The number of pixels to adjust the chart title position. By default the title appears at the center top of the chart. Set a value greater than 0 to move the chart title to the right.

This field appears only if Custom chart title position is selected.

Title horizontal alignment Select the horizontal position that the title appears in, relative to the chart.

This field appears only if Custom chart title position is not selected.

Title verticle alignment Select the vertical position that the title appears in, relative to the chart.

This field appears only if Custom chart title position is not selected.

Legend
Show legend Select whether the chart displays a legend.
Legend horizontal alignment Select the horizontal position that the legend appears in, relative to the chart.
Legend vertical alignment Select the vertical position that the legend appears in, relative to the chart.
Show legend border Select whether a border appears around the legend.