Map

A prerequisite for placing a map on a dashboard is that the map is already available in Gaio, whether it is an imported map (GeoJson) or a manually created map.

Another fundamental point, is that the table containing the data to be printed on the map, needs to have a geography column in the format that the map expects. For example, the map is by State and expects the name of the State in two letters (SP, RJ, MG). So, the table that we are going to deliver to the map must have a column in this format.

To include a map in a dashboard, first click on the table with the data to print on the map, go to Tasks and choose Map .

In this interface, all configuration is in the menu on the left:

1. Choose a map already loaded into Gaio. It can be a map by State of an entire Country, it can be by city of a State or Country.

2. Choose the data table column that will relate to the Map's key column.

3. Checking this box will cause the map key field to be displayed when hovering over the map. All columns from the data table will be displayed on the map. If you do not want to display a column, you will have to remove it from the table before using it in the Map.

4. Field Format : if some simple transformation is necessary to do in GeoJSON to match the values of the key column of the data table, it can be done here, such as capitalizing letters .

5. Indicator : Choose the column that will define the colors in the geographies on the map.

6. Colors : Define how the colors will appear. Two possibilities are available.

   1. Gradient : the colors will be distributed automatically and evenly, going from red to green or another color that the analyst chooses in the next steps. When selected, you can choose the colors that should be used for low, intermediate and high values and the number of values in the gradient.

   2. Conditional : in this option the analyst defines criteria and color if the criterion is met.

7. Definition of which rules and colors should be used for low, intermediate and high values.

8. Row limit : the analyst can bring a table to the map with millions of rows and not take into account the fact that the browser can crash with this high volume. Therefore, there is a default limit of 100 lines, but this value can be changed if the analyst understands that it is necessary, reaching 10 thousand lines.

9. Link : Finally, it is possible to link the map to another process. Therefore, when a user clicks on any polygon on the map, Gaio will take him to another screen, with all the values in the data table line having been passed as parameters for the destination process.

It is on this screen that the map zoom is defined. Adjust here and it will be reflected on the dashboard.