Rank Filtering

Rank filtering only uses the leaf item of the breakdown when creating the ranking. Consequently, this makes the number of items consistent, regardless of the hierarchy. Note that this behavior also applies to crosstabs.

Rank Filter is available in all non-time series visualizations that use the Size or Height variable.

Bar Graph
Bullet Graph – Horizontal & Vertical
Categorical Line Graph
Circle Pack
Dot Plot
Donut Chart
Donut Gauge
Funnel Chart
Heat Map
Map Plot
Network Graph
Pareto Chart
Pie Chart
Scatter Plot
Treemap
Waterfall Chart

It is also available in the Record and Table visualizations.

This section discusses the steps and guidelines to set the rank filtering using this sample data table.

Sample Data Table 1: SuperMarket

Region	Area	Type	Amount Sold	Revenue
South West	Ambient	Store Cupboard	4,885.00	550,697.00
South West	Ambient	Home Products	2,314.00	323,094.00
South West	Ambient	Savoury	840.00	67,702.00
South West	Ambient	Confectionary	429.00	33,219.00
South West	Ambient	Tobacco	1,975.00	712,467.00
South West	Ambient	Soft Drinks	619.00	56,493.00
South West	Ambient	Chilled	415.00	22,825.00
South West	Cold & Frozen	Frozen	2,084.00	357,953.00
South West	Cold & Frozen	Chilled	9,478.00	1,059,714.00
South West	Cold & Frozen	Frozen Ice Creams	1,169.00	148,791.00
South West	Alcohol	Alcohol	2,916.00	1,170,043.00
Wales	Ambient	Store Cupboard	3,151.00	352,862.00
Wales	Ambient	Home Products	1,450.00	191,889.00
Wales	Ambient	Savoury	487.00	39,249.00
Wales	Ambient	Confectionary	150.00	8,870.00
Wales	Ambient	Soft Drinks	337.00	29,761.00
Wales	Ambient	Tobacco	1,267.00	454,652.00
Wales	Ambient	Chilled	321.00	17,655.00
Wales	Cold & Frozen	Frozen	1,332.00	226,840.00
Wales	Cold & Frozen	Chilled	6,316.00	702,994.00

Other settings on the Treemap visualization:

Breakdown	Size	Color
Type, Area, Region	Amount Sold	Revenue

Sample visualization: Treemap before the rank filter

Click on a snapshot visualization and then click the Filters drop area on the Visualization Settings pane.
The visualization filter properties are displayed.
Tap the Rank Filter slider to turn it on.
The Filter By drop-down list is enabled.
Select either of the Filter By options:
- Height/Size
  Allows the visualization to be ranked based on the Size or Height variable.
- Sort Order
  Allows the visualization to be ranked based on the top values of the Size or Height variable.
Select either of the rank filter Scope:
- Overall
  For the flat rank, including all the existing leaf nodes.
- Group
  For the per inner node rank of leaf nodes under the same inner node.
Enter the value of the Limits.
Default values are -1,5,10,20,30,40,60,80,100.

For example, the values are set to -1,10,100,1000.

These limits can be selected in the visualization.
Select the ranking Direction that can be selected either:
- In the Direction drop-down list in the visualization
- On the Filter Settings pane
Example 1: Selecting the Height/Size mode, Overall scope, Top direction, 10 as the limit, and Amount Sold as the Size variable.

Example 2: Selecting the Height/Size mode, Group scope, Top direction, 10 as the limit, and Amount Sold as the Size variable.

Example 3: Selecting the Height/Size mode, Overall scope, Bottom direction, 10 as the limit, and Amount Sold as the Size variable.

Example 4: Selecting the Height/Size mode, Group scope, Bottom direction, 10 as the limit, and Amount Sold as the Size variable.
Enabled by default, tap the Interactive slider to turn it off.
This disables the drop-down lists in the visualization. Only the labels of the options are displayed:
Click the Save icon.

Intellectual Property Rights Notice | Technical Support