Bing Maps: Shaded Maps - Adding Statistics
As well as displaying values - for example the number of People on a map - you can also generate and display a calculated statistic for those people being represented on the map.
Added in Q2 23
Whilst you can use the Add Statistics method described below, from the Q2 2023 release:
-
You can drag variables directly on to the Statistics panel on a map layer, rather than having to use the Add Statistics button.
-
A left-drag adds the statistic using the default function - eg. Sum(Cost)
-
A right-drag allows you to select from four options - Sum, Mean, Minimum, Maximum - or Add Statistics... to access all options
-
-
Changing the primary statistic on a thematic map layer automatically updates the thematic shading without the need to rebuild the map.
Let’s use the example of Occupations by Postal Areas created here . We can now amend this example to optionally display the total profit each of those occupations (in the specific Postal Area) has contributed to our business.
-
Click on the Layer tab (Entitled Occupations by Postal Areas)
-
Click on the Add Statistics… button to display the Statistics window
-
Click on the radio button Specify other Table, Variable or Expression
-
We can now drag on the Profit variable and select the statistic we want to apply - in this example Sum
-
Click OK
-
Within the Statistics panel change the Primary Statistic from People to Sum(Profit)
-
Click the Build button
When we move the mouse pointer over a chart, the tool tip that is displayed now shows the total profit figure per occupation for the Postal Area they live in.