Google area map
This chart displays data as geolocated hexagons over a world map, where the Color field represents the value and the Radius represents the coverage area. This chart may be used, for example, to represent mobile antennas and their coverage.
What data do I need for this widget?
The option to create this map will be disabled unless your query contains at least three columns with numeric values or one with numeric and one with string. Furthermore, to show meaningful content on the map, two of those columns must correspond to longitude and latitude and your data must be grouped.
Creating a Google area map
Go to Data Search and open the required table.
Perform the required operations to get the data you want to use in the chart.
If your table does not contain fields representing a pair of latitude and longitude values in integer or float format, you can use the operations in the Geolocation group to create latitude and longitude fields based on existing data in your table.
For example, you can add to your table the latitude and longitude values corresponding to a set of IP addresses using the Geolocated Latitude (mmlatitude) and Geolocated Longitude (mmlongitude) operations.
- Select Additional tools → Charts → Maps → Google area map from the query toolbar.
Click and drag the column headers to the corresponding fields. This chart requires you to select the following fields:
Latitude float, integer, duration Longitude float, integer, duration Value/Color float, integer, duration Path string Radius float, integer, duration
- The Google area map is displayed.
Working with Google area maps
Hover over an area on the map to see at the bottom the value and position in the color range.
To change the visualization area you can perform the following actions:
- Click the + button to zoom in.
- Click the - button to zoom out.
- Left-click and drag to pan the map to the desired area.
- Double-click to zoom in.
- Double-right-click to zoom out.
- Click the button at the top right to toggle fullscreen mode.
You can hit the following keys to perform different visualization actions:
W / S
Changes to the next color gradient for temperature representation. This will change the color scale for another with a different base color and number of colors to represent the lowest/coldest and highest/warmest. When you get to the last available gradient, pressing the key will go back to the first.
This might be useful when the values are very similar and belong to the same range so they would be represented in the same or very similar color. This way we might be overlooking the differences in the values because of the lack of contrast and changing the gradient could help so that the values would be represented differently.
|Increases the opacity of the areas for easier visualization of the areas represented.|
|Decreases the opacity of the areas for easier visualization of the base map.|
|Reset configuration to revert the applied operations to the display of areas on the map.|
|Applies a logarithmic operation to normalize the data, which will be reflected in the areas represented on the map. This might be useful when some values are too far from the general range so normalization is needed for a more cohesive representation.|
|Applies an arctangential operation to normalize the data, which will be reflected in the areas represented on the map. This might be useful when some values are too far from the general range so normalization is needed for a more cohesive representation.|
|Toggles markers visibility. This shows/hides the points in the center of the areas.|
|Toggles radius visibility. This shows/hides the areas' contour and fill to show only the points in the center.|
|Toggles polygons visibility.|
|Toggles intersection mode (inner). This shows only the coinciding parts of the areas that intersect.|
|Toggles intersection mode (outer). This hides the coinciding parts of the areas that intersect.|
|Changes the map style to adapt it to your visualization needs. You can choose from black or white backgrounds.|
|Toggles limit/unlimit. This limits the results shown in the displayed area showing only the most relevant to improve performance. You can check it at the bottom of the map window; Infinity means all results are shown while a number means it is limited to that number.|
|Shows/hides the list of shortcuts keys.|
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 mmlatitude(clientIpAddress) as latitude, mmlongitude(clientIpAddress) as longitude group every 5m by latitude, longitude, timeTaken, bytesTransferred, method every 5m
|Required field||Column added|