Wyn Enterprise User Guide

Wyn Enterprise: Filter Data

Filtering data helps you display relevant data and hence building an effective dashboard.

You can add filters from the measures and dimensions in the dataset, or specify your own filter values and conditions. The options for setting filter conditions are available under General and Matching Rules tabs of the Filter dialog as explained below. You should choose General if you want to add filters from the available dimensions, measures, or dashboard parameters. Switch to Matching Rules if you want to specify your own filter values and conditions.

General Description
Use custom value To use a custom value to filter data
Use a new parameter To use a parameter to filter data
Sort Sort the data in ascending or descending values
Exclude Matched Set to True or False if you want to exclude or include the matched attribute values
Matching Rules Description
Match Type Specify the matching condition - Contains, Start With, End With, Exactly Match
Case Sensitive Specify if the filter should match case
Match Value Specify the value to match with according to the filter condition

Refer to the following example, where a filter is applied on the 'Month' dimension in a chart to show the number of tickets for the first six months of the year, that is, Jan, Feb, March, April, May, and June.

Filter Example

Apply a Filter

  1. Select the Dashboard scenario in the design area for which you want to filter the data. Note that an Action Bar automatically appears on the right of the selected scenario.

  2. From the Action Bar, select Filter action Filter Icon.

  3. In the Filter dialog that appears, click Add a Filter to specify the filter condition and attribute.

    Adding a filter

  4. Set the Target Field to a suitable data attribute from the list. The Target field refers to the data attribute on which you want to apply a filter. For example, set the Target Field to 'Month' to apply the filter on the 'Month' values.

    Setting the Target Field to Month

  5. Select the 'Month' values as Jan, Feb, Mar, Apr, May, and June to see the data for only these months in the scenario.

  6. Choose General since we want to add filters from the available measures.
  7. Keep Exclude Matched to 'False' and click Apply.

    Selecting the attribute values