Displaying top/bottom records

Contents[Hide]

1. Overview

You can display Top N and/or Bottom N records using the Top/Bottom Measure property in the Metric Set Binding. If you have filters, the data gets filtered first, and then the Top N and/or Bottom N records are displayed;. This can be done either at the Metric Set level (i.e. using the Metric Set designer), or at the dashboard level.

2. Data

Sample data can be found below. Goal is to show only the Top 5 Sales.

Sample Data
Sample Data

3. Configure the Data Binding Panel

  1. Right-Click on the table, and select Data Binding Panel

    Open the Data Binding Panel
    Open the Data Binding Panel

  2. Click on the Edit icon.

    Click Edit
    Click Edit

  3. On the Metric Set Default Values section, set the following values:
      • Top/Bottom Measure: Sales
      • Top: 5
      • Bottom: 0

    You can enter values on both Top and Bottom.

    Set the values
    Set the values

4. Testing

View the result:

Result showing Top 5 values
Result showing Top 5 values

5. See also

 

Dundas Data Visualization, Inc.
500-250 Ferrand Drive
Toronto, ON, Canada
M3C 3G8

North America: 1.800.463.1492
International: 1.416.467.5100

Dundas Support Hours: 7am-6pm, ET, Mon-Fri