Map visualization
The map visualization aids in pin-pointing issues in specific regions and showing high level aggregated views of the monitoring data by providing capability to aggregate all the data mapped to each location/country/region.
The screenshot below shows the total transactions and end-to-end latency for different storage accounts. Here the size is determined by the total number of transactions and the color metrics below the map show the end-to-end latency. Upon first observation, the number of transactions in the West US region are small compared to the East US region, but the end-to-end latency for the West US region is higher than the East US region. This provides initial insight that something is amiss for West US.

Adding a map
Map can be visualized if the underlying data/metrics has Latitude/Longitude information, Azure resource information, Azure location information or country/region, name, or country/region code.
Using Azure location
Switch the workbook to edit mode by selecting on the Edit toolbar item.
Select Add then Add query.
Change the Data Source to
Azure Resource Graphthen pick any subscription that has storage account.Enter the query below for your analysis and the select Run Query.
where type =~ 'microsoft.storage/storageaccounts' | summarize count() by locationSet Size to
Large.Set the Visualization to
Map.All the settings will be autopopulated. For custom settings, select the Map Settings button to open the settings pane.
Below is a screenshot of the map visualization that shows storage accounts for each Azure region for the selected subscription.

Using Azure resource
Switch the workbook to edit mode by selecting on the Edit toolbar item.
Select Add then Add Metric.
Use a subscription that has storage accounts.
Change Resource Type to
storage accountand in Resource select multiple storage accounts.Select Add Metric and add a Transaction metric.
- Namespace:
Account - Metric:
Transactions - Aggregation:
Sum

- Namespace:
Select Add Metric and add Success E2E Latency metric.
- Namespace:
Account - Metric:
Success E2E Latency - Aggregation:
Average

- Namespace:
Set Size to
Large.Set Visualization size to
Map.In Map Settings set the following settings:
- Location info using:
Azure Resource - Azure resource field:
Name - Size by:
microsoft.storage/storageaccounts-Transaction-Transactions - Aggregation for location:
Sum of values - Coloring Type:
Heatmap - Color by:
microsoft.storage/storageaccounts-Transaction-SuccessE2ELatency - Aggregation for color:
Sum of values - Color palette:
Green to Red - Minimum value:
0 - Metric value:
microsoft.storage/storageaccounts-Transaction-SuccessE2ELatency - Aggregate other metrics by:
Sum of values - Select the custom formatting box
- Unit:
Milliseconds - Style:
Decimal - Maximum fractional digits:
2
- Location info using:
Using country/region
Switch the workbook to edit mode by selecting on the Edit toolbar item.
Select *Add, then Add query.
Change the Data source to
Log.Select Resource type as
Application Insights, then pick any Application Insights resource that has pageViews data.Use the query editor to enter the KQL for your analysis and select Run Query.
pageViews | project duration, itemCount, client_CountryOrRegion | limit 20Set the size values to
Large.Set the visualization to
Map.All the settings will be autopopulated. For custom settings, select Map Settings.
Using latitude/location
- Switch the workbook to edit mode by selecting on the Edit toolbar item.
- Select *Add, then Add query.
- Change the Data source to
JSON. - Enter the JSON data in below in the query editor and select Run Query.
- Set the Size values to
Large. - Set the Visualization to
Map. - In Map Settings under "Metric Settings", set Metric Label to
displayNamethen select Save and Close.
The map visualization below shows users for each latitude and longitude location with the selected label for metrics.

Map settings
Layout settings
| Setting | Explanation |
|---|---|
Location info using |
Select a way to get the location of items shown on the map. Latitude/Longitude: Select this option if there are columns with latitude and longitude information. Each row with latitude and longitude data will be shown as distinct item on the map. Azure location: Select this option if there is a column that has Azure Location (eastus, westeurope, centralindia, etc.) information. Specify that column and it will fetch the corresponding latitude and longitude for each Azure location, group same location rows(based on Aggregation specified) together to show the locations on the map. Azure resource: Select this option if there is a column that has Azure resource information (storage account, cosmosdb account, etc.). Specify that column and it will fetch the corresponding latitude and longitude for each Azure resource, group same location (Azure location) rows (based on Aggregation specified) together to show the locations on the map. Country/Region: Select this option if there is a column that has country/region name/code (US, United States, IN, India, CN, China) information. Specify that column and it will fetch the corresponding latitude and longitude for each Country/Region/Code and group the rows together with same Country-Region Code/Country-Region name to show the locations on the map. Country Name and Country code won't be grouped together as a single entity on the map. |
Latitude/Longitude |
These two options will be visible if Location Info field value is: Latitude/Longitude. Select the column that has latitude in the latitude field and longitude in the longitude field respectively. |
Azure location field |
This option will be visible if Location Info field value is: Azure location. Select the column that the Azure location information. |
Azure resource field |
This option will be visible if Location Info field value is: Azure resource. Select the column that the Azure resource information. |
Country/Region field |
This option will be visible if Location Info field value is: Country or region. Select the column that the Country/Region information. |
Size by |
This option controls the size of the items shown on the map. Size depends on value in the column specified by the user. Currently, radius of the circle is directly proportional to the square root of the column's value. If 'None...' is selected, all the circles will show the default region size. |
Aggregation for location |
This field specifies how to aggregate the size by columns that has same Azure Location/Azure Resource/Country-Region. |
Minimum region size |
This field specifies what is the minimum radius of the item shown on the map. This is used when there is a significant difference between the size by column's values, therefore smaller items are hardly visible on the map. |
Maximum region size |
This field specifies what is the maximum radius of the item shown on the map. This is used when the size by column's values are extremely large and they are covering huge area of the map. |
Default region size |
This field specifies what is the default radius of the item shown on the map. The default radius is used when the Size By column is 'None...' or the value is 0. |
Minimum value |
The minimum value used to compute region size. If not specified, the minimum value will be the smallest value after aggregation. |
Maximum value |
The maximum value used to compute region size. If not specified, the maximum value will be the largest value after aggregation. |
Opacity of items on Map |
This field specifies how transparent are the items shown on the map. Opacity of 1 means, no transparency, where opacity of 0 means, items won't be visible on the map. If there are too many items on the map, opacity can be set to low value so that all the overlapping items are visible. |
Color settings
| Coloring Type | Explanation |
|---|---|
None |
All nodes have the same color. |
Thresholds |
In this type, cell colors are set by threshold rules (for example, CPU > 90% => Red, 60% > CPU > 90% => Yellow, CPU < 60% => Green).
|
Heatmap |
In this type, the cells are colored based on the color palette and Color by field. This will also have same Color by and Aggregation for color options as thresholds. |
Metric settings
| Setting | Explanation |
|---|---|
Metric Label |
This option will be visible if Location Info field value is: Latitude/Longitude. Using this feature, user can pick the label to show for metrics shown below the map. |
Metric Value |
This field specifies metric value to be shown below the map. |
Create 'Others' group after |
This field specifies the limit before an "Others" group is created. |
Aggregate 'Others' metrics by |
This field specifies the aggregation used for "Others" group if it is shown. |
Custom formatting |
Use this field to set units, style, and formatting options for number values. This is same as grid's custom formatting. |
Next steps
- Learn how to create honey comb visualizations in workbooks.