Filtering and Ranking a Geographical Map :: SAS(R) Web Report Studio 4.3: User's Guide

Create a Filter for a Geographical Map

To create a filter for the geographic hierarchy in a geographical map, complete these steps:

In Edit mode, right-click in the geographical map, and then select Filter and Rank or in View mode, click on the map toolbar, and then select Filter and Rank. The Filter and Rank dialog box appears.
Select the Category Filters tab.
In the Categories list, select the geographic hierarchy. This field displays the geographic hierarchy along with any currently active filters.
Select the Filter option.
Select items in the Available values list. You can select and deselect items individually, or you can use the Select All or Deselect All buttons.
Click OK.

Note: The Measure Filter or Rank tab is not available in Edit mode.

To create a measure filter, complete these steps:

In View mode, click on the map toolbar, and then select Filter and Rank to open the Filter and Rank dialog box.
Select the Measure Filter or Rank tab.
Select the Filter option.
In the Show values of drop-down list, select the geographic hierarchy.
Select the Measure that is being used in the geographical map.
Select an Operator.
Enter a Value. (Do not include the currency symbol.)
Click OK.

Note: The Measure Filter or Rank tab is not available in Edit mode.

To create a ranking for the measure used in a geographical map, complete these steps:

In View mode, click on the map toolbar, and then select Filter and Rank to open the Filter and Rank dialog box.
Select the Measure Filter or Rank tab.
Select the Rank option.
In the Show field, select Top or Bottom, and then type a value next to the option that you chose.
(Optional) Choose one of these options:
- To evaluate the data as a percentage, select the percent(%) option, and then enter a value. The value cannot exceed 100.
- To exclude tied rankings, select the Exclude ties option. For example, by default, if you request the top five geographic areas for total revenue and there are three areas tied for fifth place, then seven geographic areas are shown on the geographical map. If you select the Exclude ties option, then only five geographic areas are shown on the geographical map.
In the Show values of drop-down list, select the geographic hierarchy.
Select the Measure that is being used in the geographical map.
Click OK.

To remove a filter or ranking from a geographical map, complete these steps:

In Edit mode, right-click in the geographical map, and then select Filter and Rank or in View mode, click on the map toolbar, and then select Filter and Rank. The Filter and Rank dialog box appears.
Remove the geographic hierarchy filter, the measure filter, or the ranking as follows:
- On the Category Filters tab, select the geographic hierarchy, and then select No filter.
- On the Measure Filter or Rank tab, select No filter (show all values).
Click OK.