Flat world map by country
- Juan Tomás Alonso Nieto (Deactivated)
- Borja Moro Moreno
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 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:
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 |
|---|---|---|
from siem.logtrust.web.activity
group every 30m by country
every 1d
select count() as count | Country | country |
Color | count |