Geo map
The geo map widget plots a metric on a world map, shading each country by its value. Countries with higher values appear darker.
Use it for:
- Users or sessions per country
- Revenue by country
- Event count by country
Query requirements
Section titled “Query requirements”Return one row per country with a country column and a value column. The country column must contain full country names (as stored in the country column of your events table, e.g. France, United States, Germany).
Select: country, uniqExact(identity) AS count
Filters: WHERE name = 'app_started' GROUP BY country ORDER BY count DESC
Common examples
Section titled “Common examples”Users by country
Select: country AS "Country", uniqExact(identity) AS "Total Records"
Filters: WHERE name = 'app_started' GROUP BY country ORDER BY "Total Records" DESC
Sessions by country
Select: country AS "Country", uniqExact(session_id) AS "Total Records"
Filters: WHERE name = 'app_started' GROUP BY country ORDER BY "Total Records" DESC
Event volume by country
Select: country AS "Country", count() AS "Total Records"
Filters: GROUP BY country ORDER BY "Total Records" DESC