Document toolboxDocument toolbox

Flat world map by country

Overview

This chart displays information on a world map using values that correspond to country names.

What data do I need for this widget?

The option to create this map will be disabled unless your query contains at least one column with numeric values and one with string. The string value should coincide with the name of a country or its two-character ISO code. You can check the list of ISO codes at the following link. Furthermore, you need to group your data for the map to show meaningful content.

Creating a flat world map by country

Working with flat world maps by country

Click the dropdowns at the top of the chart and the buttons at the bottom left to operate with the following options:

  • Data Operationselect an operation (Linear or log) to change the data normalization pattern. This might be useful when some values are too far from the general range so normalization is needed for a more cohesive representation.

  • Gradient reductionselect an operation (No max min reduction or Standard deviation reduction) to change the data marginalization pattern. This might be useful when most of the values are too close to the general range so marginalization is needed for a more extensive representation.

To change the visualization area you can perform the following actions:

  • +: zoom in.

  • When zoomed in, click and drag to pan to the desired area.

  • -: zoom out.

Query example

You can recreate the example shown in the picture above with the data from the following query and mapping the fields as follows:

Query

Required field

Column added

Query

Required field

Column added

from demo.ecommerce.data select mm2country(clientIpAddress) as country group every 5m by country, timeTaken every 5m

Country

country

Color

timeTaken

In case you want another example, here is another query to create it:

Query

Required field

Column added

Query

Required field

Column added

from siem.logtrust.web.activity group every 30m by country every 1d select count() as count

Country

country

Color

count