Rank Filtering for the Table Visualization

For the Table visualization, the rank filter only uses the leaf item of the breakdown when creating the ranking. Consequently, this makes the number of items consistent, regardless of the hierarchy.

1. Click on the Table visualization and then click the Filters drop area on the Visualization Settings pane.

   The visualization filter properties are displayed.

   

2. Tap the Rank Filter slider to turn it on.

   This enables the Filter Mode drop-down list with Sort Order as the setting. In addition, the Direction is set to Top.

   

3. 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.

4. 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.

   • In the Limit drop-down list in the visualization

     

   • On the Filter Settings pane

     

   The data set will be limited to displaying the top/bottom n based on the sorting of the data. When a column is clicked for sorting, the data set will be limited accordingly.

   Example 1: Selecting the Overall scope, 10 as the limit, and the breakdown fields are based on the sorting made on the first visual member, Amount Sold (Bottom).

   

   Example 2: Selecting the Group scope 10 as the limit, and the breakdown fields are based on the sorting made on the first visual member, Amount Sold.

   

5. 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.

   

6. Click the Save   icon.

(c) 2013-2024 Altair Engineering Inc. All Rights Reserved.

Intellectual Property Rights Notice | Technical Support