Create a geographic distribution map

The Distribution map allows to compare regions or countries.

  1. When to use a geographic distribution map?
  2. Create a distribution map
  3. Configure the distribution map
  4. Example

When to use a distribution map?

The distribution map is only useful if you have a "Location" field.

If the dataset does not include a “Number” field (budget, rate, number of, etc.), you will only be able to count the items in each region. 

If the dataset includes a “Number” field (budget, rate, number of, etc.), you will be able to do calculations on this field (sum, average, etc,).

Examples:

  • Indicator values disaggregated by regions.
  • Expenditures of projects per country (Based on project's country).
  • Number of beneficiaries per region. (Data from a Beneficiaries custom form)

Create a distribution map

To create a distribution map:

  • Select the "Analytics" module in the main menu (left)
  • Click on the "+" sign
  • To create the new analytics report, you must:
    • Enter a title
    • Select a dataset
    • Select an output type (in this case: Geographic Distribution)
    • Save
  • A draft data visualization will be displayed
  • To configure the report:
    • Click the "Toolbox icon" to open the configuration panel

  • Configure the chart to fit your needs
    • Click "Generate" to view the result
  • Click "Save" to save the report
  • If you open this pie chart again in the future, it will be automatically updated to reflect the newly added data. Therefore, if you wish to keep the report that reflects the current data, you need to export it.

Configure the distribution map

In the configuration panel of the distribution map, you will see the following parameters:

Parameter Details Example or Link
Calculation method Allows to select the calculation that will be applied (Average, Sum, Count, etc.). For more details, you can read the "Calculation methods" article.
(Does not appear if the dataset does not have a "Number" field).
Field The field on which the calculation will be applied.

This must be a numerical field. (number)
(Does not appear if the dataset does not have a "Number" field or if the calculation method is "Count").
Breakdown level Allows to select the level of detail: continents, countries, district, etc. If items are linked to a lower level (example: district) and you select a higher level (example: country), the values will be aggregated to calculate the value at the higher level.
Distinct value-Column Allows to count items only once and avoid duplicates. Example: a participant could have attended multiple activities of the same type. If you need to count participations only once per attendee/type, then you need to select the Attendee field as a distinct value.

For more details, you can read the "Distinct count" article.
Legend range: minimum value and maximum value Allows to specify the range used for the legend. By default, LogAlto will take the lowest and highest values. There are 10 intervals in the legend. Sometimes, it may be preferrable to change the range so that each interval starts and ends on an integer number. (example: if the min is 10 and max is 30, the intervals will be 10-12,13-14, 15-16, etc.).
Filters Allows to filter out part of the dataset. This is optional.

Example

Example: Average grade per region (pre- and post-school survey form)

We have a "Students" form and a "Pre-post school survey" form, which collects (among other things) students' grades.

From this form, we want to know the average grade of students (per region).

Parameter Chosen option for the parameter
Calculation method Average
Field Avg. grade
Breakdown level Level 3 - Admin. breakdown (regions/provinces)
Distinct value-Column Beneficiary ID (beneficiaries were surveyed twice and we only want the grade from the most recent survey)
Legend range: minimum value and maximum value 68 to 78
Filters Not applicable (but we could have filtered by gender, age, etc.)