Filtering data

In this activity, you will restrict the items of data being used for a panel to those which matches a set of criteria that you define.

Before proceeding:
Our task now is to create a pie chart similar to the first, except that we limit it to reporting only on the test results of the latest build.
Note: You have two options for filtering the data that's supplied to a Dashboard panel. You can do it in the data profile used by that panel, or in the configuration of the panel itself.
Note: Keep in mind, though, that a data profile can drive more than a single Dashboard panel. Hence, modifying the settings of an existing data profile can have unintended consequences, if you don't know all the panels that rely on it. For that reason, while we will use the existing Test Results (unfiltered) profile, we will do our filtering at the panel level.
  1. Create a clone of the Car Rental Test Results Overview panel.
    1. Click the Clone Panel icon at the top-right corner of the Car Rental Test Results Overview panel.
    2. In the Clone Panel dialog, select Tutorial Page from the Select page drop-down menu, and set Display Name to Car Rental Test Results, Latest Build. Click OK. A new panel, identical to the first except for the display name, is created.
  2. Add a filter to the new panel.
    1. Click the Edit Panel icon at the top-right corner of the Car Rental Test Results, Latest Build panel.
    2. Click the Filters tab in the Edit Panel dialog.
    3. In the Filters tab, create the filter by setting the following fields:

      • Field: Build Number
      • Operator: =
      • Value: latest build
    4. Click on the Display Settings tab.
    5. Note: The Chart Title of Summarized test results across test modules and dates no longer applies to this chart. Since we already have a name for the panel, let's just make Chart Title invisible.
      Under Chart Settings, clear the Show Title check box.
    6. Optional:
      Note: You can also change some other display settings, to see their effect.
      Under Chart Settings, set Legends to None; On the Data Labels line, select the Series check box, and clear the Percentage check box.
    7. Select the Save current chart settings check box, and click OK.
    The new chart is displayed which, while based on the same criteria as the previous one, uses a limited set of test results. Drilling down to the individual data records confirms that they are indeed all restricted to a single build: