Create a map report in the Report Designer

Map reports

Map reports display data on a map. You can display data as a geographical heatmap () or view specific data points (The pin locations icon for map reports).

Zoom in on a map to get a more detailed view. In heatmap mode, click any region on the map that contains data to drill down into its map.
Note: Save the map report to drill down into it. You cannot drill down into unsaved reports.

The lowest level of a map hierarchy can display only data points. Click data on this lowest level to see the data in list view, or in drill-down view if one has been configured.

Limitations

  • Maps are not supported on Internet Explorer versions 7 and 8.
  • Map reports cannot be saved as images on Internet Explorer versions 7 to 9, Firefox versions 31 to 37, Safari 5, or all versions of the Edge browser. For best results, use Chrome to work with map reports.
  • Map reports cannot be exported or scheduled as PDFs, but can be saved as images.
Map report example

Create a map report in the Report Designer

Create a map report to plot your data on a map.

Before you begin

Role required: itil

About this task

This task refers to the Jakarta release under UI15 and UI16. If you are using an earlier UI or the Classic UI for creating reports, follow the instructions in the Helsinki documentation instead: Report types and creation details.

Procedure

  1. Navigate to Reports > Create New.
  2. On the Data tab, give the report a name that reflects the information being grouped.
  3. Select the source for the report:
    OptionDescription
    Data source A table with filters applied to provide a single source of information for all users.
    Table The raw data from a table with no filters applied.
    External import Choose an existing imported report source, or click the Upload icon (Upload icon) to import a new file. See Create a report from an imported Microsoft Excel document
  4. Click Next.
  5. On the Type tab, select Map in the Other section and click Next.

    A preliminary version of the report is displayed. To view the updated report at any time, click Run.

  6. On the Configure tab, fill in the following fields and click Next.
    Field Description
    Display data table Check this box to display report data in a grid beneath the report. The table appears on dashboards where the report is added.

    All reports that use charts, including reports that are used on dashboards, display the table of report data when the glide.ui.section508 system property is set to true. The glide.ui.section508 property overrides the Display data table field.

    Aggregation Mathematical calculation to perform on the data. The default is Count, which displays the number of records selected.

    To display only unique records, select Count Distinct. For example, if you want a report on the distinct number of users who have one or more of the roles in a given list of roles. Users with more than one role would be counted twice unless you use Count Distinct.

    Select Average, Sum, or Count Distinct, to display a list of fields from the selected Table. Select a field to aggregate by from this list. For example, if you select a duration field, such as Business duration on the Incident table, the aggregated data is expressed in days, hours, and minutes. If you select an integer field, such as Priority, the data is expressed as a decimal value number.

    If you choose Sum or Average, select Show related fields to aggregate on dot-walked fields. See Dot-walking

    Note: For duration values, the unit of measurement displayed in the aggregation axis cannot be customized.
    Map this data The data that you want to plot on the map. Only data that a report administrator has prepared as a map source is available.
    Set map The starting map for the report. You can zoom in but cannot zoom out from this map.
  7. (Optional) To limit the information displayed in the report, click the filter icon (filter icon) and select conditions to filter the report data.
    For more details on how conditions are constructed, see Condition builder.
  8. On the Style tab, configure the appearance of the report. Fill in the fields as appropriate.
    Table 1. Map report style options
    Field Description
    General
    Use heatmap colors Check box to use different colors to indicate different values on the map. If you clear this check box, all geographical locations with data are displayed in the same color.
    Color for high scores Color to indicate high values.
    Color for low scores Color to indicate low values.
    Display data labels Check box to display the value for each data point.
    Display geographical labels Check box to display the names of geographical objects on the map, such as countries, regions, and states.
    Custom chart size Check box to specify the width and height of the report in pixels.
    Note: The chart size is ignored when you export the report to PDF. In PDFs, the full page width is used to display the chart.
    Chart width Width of the report in pixels. The default value is 600.

    This field is available when Custom chart size is selected.

    Chart height Height of the report in pixels. The default value is 450.

    This field appears when Custom chart size is selected.

    Chart size Chart size. This field is available when Custom chart size is cleared. Options are Small, Medium, and Large.
    Note: The chart size is ignored when you export the report to PDF. In PDFs, the full page width is used to display the chart.
    Drilldown view List view to display when a user selects a segment of a report for which no drilldown report type is specified. This view is also used when the user reaches the lowest drilldown level of a report. See Configure the list layout . If you specify a Report drilldown, Drilldown view is ignored.
    Note: All users can view report visualizations, such as pie charts and column reports. However, the last level of a drill down is always a list. Platform access control lists determine user access to list information. Users who do not have rights to any part of the list data see the message "Number of rows removed from this list by Security constraints:" followed by the number. See Access control rules.

    For more information, see Define a report drilldown in the Report Designer.

    Decimal precision Number of decimal places to display. You can display From zero to four decimal places. Default value: 2. To change the default value, create the system property glide.chart.decimal.precision and specify the value.
    Title
    Show chart title When the chart title is displayed for the report.
    • Never: Never displays the chart title.
    • Report only: Displays the chart title on reports.
    • Always: Displays the chart title on reports, and dashboards and homepages.
    Chart title The chart title has a maximum length of 40 characters. If no title is entered, the report name is used for the title. This field appears when Report only or Always is selected from the Show chart title list.
    Size of the chart title Size of the chart title in pixels. This field appears when Report only or Always is selected from the Show chart title list.
    Chart title color Color of the chart title. This field appears when Report only or Always is selected from the Show chart title list.
    Custom chart title position Check box to specify X and Y coordinates for the position of the chart title. This field appears when Report only or Always is selected from the Show chart title list.
    Chart title X position Number of pixels to adjust the chart title position right or left. By default the title appears at the center top of the chart. To move the chart title to the right, enter a positive value. To move the title to the left, enter a negative value.

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

    Chart title Y position Number of pixels to adjust the chart title position up or down. By default the title appears at the center top of the chart. To move up the chart title, enter a positive value. To move the chart title down, enter a negative value.

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

    Title horizontal alignment How the chart title is aligned horizontally. This field is available when Custom chart title position is cleared.
    Title vertical alignment How the chart title is aligned vertically. This field appears when Custom chart title position is cleared.
    Legend tab fields (available only when colors are used on the report)
    Show legend Check box to display a chart legend. This check box appears when a Group by field is selected on the report form.
    Legend horizontal alignment How the legend is aligned horizontally. This field appears when Show legend is selected.
    Legend vertical alignment How the legend is aligned vertically. This field appears when Show legend is selected.
    Show legend border Check box to display a border around the legend. This check box appears when Show legend is selected.
    Left align legend text Check box to left-align the legend text. By default, the legend text is centered. This check box appears when Show legend is selected.
  9. (Optional) To limit the information displayed in the report, click the filter icon (filter icon) and select conditions to filter the report data.
    For more details on how conditions are constructed, see Condition builder.
  10. Click Save.
    The report is generated.

What to do next

  • Click the Report info icon (Report info icon) and add a description of the report.
  • Click the sharing icon (Sharing icon) to open the Sharing menu. On this menu, you can add the report to a dashboard, export the report to PDF, publish the report to the web, and set visibility and schedules. For more information, see Share a report – Report Designer.