The Map Widget shows information from a User report in a heat map style chart (darker shades are applied to areas of most activity and lighter shades are applied to areas of least actviity). The map areas available are: USA, World, North America, South America, Europe, Asia, Australia and Africa.
Functionality
Hovering over a country displays the count for that country/state depending on the selected map area.
The widget supports drill-in to view the data within the chart. The report behind the widget is simple to configure as it does not require the user to aggregate the data in report, as the widget will perform this.
Click the
icon to refresh data while in the map view.
Adding a Map Widget
Select Map Widget from the Add Widget Templates side panel and click the
From here you can modify the following fields:
Name: This is a mandatory field. Users should give the widget a specific name to differentiate it from other instances of the widget.
Title: The title of the chart appears on the widget.
Description: Description of the widget which is only viewable by users editing the dashboard. Descriptions are limited to 500 characters.
Theme: Select a color using the color picker. This will be the background color of the widget title and the color is used in the heat map color palette. If no color is selected, white will be the defaulted color used for the title header and blue will be used for the heat map and legend.
Map Type: Select a geographical view. This is a mandatory field. By default, World is selected. Other views include: USA North America, South America, Europe, Asia Australia and Africa.
User Report: Specify a user report from the list. This is a mandatory field. The selected Data User Report must have one column named “Location”. Values in this Column determine the name and count of the map areas in the chart. The chart will count the number of records within each category. An option to open the report via
which will happen on a new tab and run the report is available via
which will happen on a new tab. Please check the Things to Note section for more details about User Reports including a screenshot of the user report for this example.
Refresh Time Override (Hours): The number of hours to refresh the report data can be set to override the default dashboard refresh setting. A higher value improves general system performance by running reports less often. A lower value refreshes data more frequently. Certain widgets can override this setting. A user can always force a refresh in a widget to see the latest data and update their cache.
Click
to finish configuration.
The newly added widget will be added. Widgets can be moved around and resized whilst in editing mode. You can change configuration with the
icon and delete it with
Click on any point on the map chart to open the drill-in data table. The chart supports drill-in to further analyze the data in the chart. The Data User Report should contain additional columns that will be displayed in the drill-in data table. The drill-in data table can be resized.
To return to the Map widget, click on the Widget Title. Changes will only apply if the
button is clicked at the top of the Landing Experience Dashboard screen.
Things to Note
User Report must contain a field with "Location" as the column caption. This field supports country, and state/province data types and must contain the full names of Country and State/Province. Currently, codes (e.g. ISO codes) and Custom SQL / Calculated fields returning Country/State/Province names are not supported. Here is an example of the user report used to create the example widget:
If the Location field is missing from the backing User Report of the widget, then the following prompt will be visible in the widget in the dashboard: A 'Location' column is required in the linked user report for Map Widgets.
If the a record’s location field is blank or a value other than a country or state/providence appears, that record will not be included in the count.
USA map type functions when US state names are used in the location field. The same applies to Australia for Australian States/Provinces.
For all map types excluding USA and Australia, only countries are supported in the location field.
In the case of Georgia - if a USA map is selected, the value will be set to the US state of Georgia. For World and Europe map types, the value will be set for the country of Georgia. If any other map type is selected, the value will not be applied.
User Report prompts are supported for context filters