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.
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.
- To the right-hand side of the Sales column (column B), add the target thresholds for each province. The larger provinces will have a target threshold of 250, whereas the smaller provinces will have a target threshold of 150. It is important that you use the key-value relationship for the thresholds, as shown in the following screenshot, for the Map component:
- Go to the Alerts section of the map properties and check Enable Alerts.
- Select the radio button As Percent of Target and bind it to the key-value pair cells C2:D14.
- For the target percentage, color anything on the target or above as green. Color anything between 70% of target and the target as yellow. And color anything less than 70% of the target as red.
Using the As Percent of Target option on Enable Alerts allows us to have a different threshold for each province, which gives a more realistic alerting mechanism.
In this recipe, we reused the data setup from the Using maps to select data of an area or country recipe of Chapter 3, From a Static to an Interactive Dashboard.