Displaying alerts of different thresholds on a map
The previous recipe was a very useful demonstration of how to set up alerts on a Map component. However, the threshold values of all provinces were the same. In reality, this may not be the case for metrics such as sales. For example, a province such as Nunavut is much smaller than Ontario, and thus should not have the same sales threshold as Ontario.
Getting ready
Insert a Canada by province component into the canvas and bind data to the map. We will use the data setup from the Displaying alerts on a map recipe to select the data of an area or country.
Tip
Please refer to the first screenshot in the introductory section of the recipe Making alert ranges dynamic to understand how the data should look.
You may also refer to the data setup in the source file, Displaying alerts of different thresholds.xlf.
How to do it...
To the right-hand side of the Sales column (column B), add the target thresholds for each province. The larger provinces will have...
