Apply Top Bottom N Filters
Use the Top Bottom N filter to filter a measure or attribute and display its highest or lowest values.
- To apply the Top Bottom N filter to the canvas and all visualizations in the
workbook:
- On the Home page, select a workbook, click the Actions menu, and then select Open.
- In the Data panel of the visualization, select the attribute or measure that you want to filter on and drag and drop it to the filter bar.
- In the filter bar, click the filter, then click Top Bottom N. You can only convert a range filter to Top Bottom N filter.
- To apply the Top Bottom N filter to a specific visualization in the
workbook:
- In the canvas, select the visualization that you want to filter.
- In the Data Panel, locate the attribute or measure that you want to filter on and drag and drop it to the Filter drop target in the Grammar Panel.
- In the filter bar, click the filter, then click Top Bottom N.
- To apply the Top Bottom N filter to an on-canvas filter:
- With the canvas selected, go to the Data Panel and click Visualizations, then click the List Box filter.
- In the Data Panel, locate the attribute or measure that you want to filter on, and drag and drop it to the List Box visualization that you just created.
- To configure a Top Bottom N filter, click the filter, then:
- To change between top to bottom, click Method value and click Top or Bottom.
- To specify the number of rows that are displayed, click the Count field and enter the number of rows.
- To change which attribute or measure column to limit by, click the By field and select an attribute or measure or custom calculation included on the canvas. Or click Plus (+) to locate and select the attribute or measure or metric that you want to limit by
- Click outside of the filter to close the filter panel.