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

1. Go to Data Search and open the required table.

2. Perform the required operations to get the data you want to use in the chart.

3. Click the gear icon on the toolbar and select Charts → Maps → Flat World Map by Country.

4. Click and drag the column headers to the corresponding fields. This chart requires you to select two fields:

   Required field	Data type
   Country	string
   Color	float, integer, duration

5. The flat world map by country has been built.
   
   

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 Operation: select 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 reduction: select 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:

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

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

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