Adding Filters to Content

As you create charts or styled tabular content in WebFOCUS Designer, you may want narrow the display of information that is shown. You can do this by creating filters with data fields in your content. You can also use filters as a way to create custom displays of the data that you show in your content. For example, you may only want to show revenue information for specific product categories and models in a given year.

When you add filtered content to a page, the filters automatically appear on the page, and provide interactive controls that your users can choose from to change the view of data available to them. Filtered content can also be kept stand-alone, and you can choose to enable parameter prompting, which requires a user to make a selection before the content displays. There is no limit to the number of filters that you add, however, as you add more than five filters, all filters may not fit on your screen. You can use the arrow control to scroll over to see any filters that are not visible in the Filter toolbar, as shown in the following image.

You can add filters to a chart or styled tabular content in one of the following ways:

• Drag a data field to the filter toolbar above the canvas.
• Right-click a data field, and click Add to filter toolbar.

Note: You can add data fields to the filter toolbar even if you do not have it displayed in your view.

You can remove filters from the filter toolbar by clicking the X in the upper-right corner of the filter, or by right-clicking the filter and then clicking Delete.

Once you have created filters, you can edit them further to customize the data values and selection options that are available for each filter control. For example, when you create a filter using a dimension, it lists the available data values. You can then select the data values that you want a user to choose from, as shown in the following image.

By default, the list filter control does not select any data values, and gives users the option to choose any value that is available. To select data values, you click the filter control, and begin clicking the data values that you want to add, then click outside the filter control area to apply the selection.

If you select one or two values, each selected value is listed by name in the filter control. If you select three or more values, the filter control shows the number of values selected out of the total number of available values. If all values are selected, the filter control says All.

The selected values are displayed in the chart at run time by default, and users can select other values to display them.

You can also choose to exclude data values from the list. To do this, right-click the filter, and click Exclude. You can then click the filter control again, and begin clicking the data values that you want to exclude from the list. Once you have selected the data values that you want to exclude, your chart refreshes.

At run time, instead of choosing which values to display in the chart, users select values to exclude from the chart.

You can also set the filter to use a single value instead of multiple values. If you right-click a filter and click Single, when you click the filter control again, you are only able to select a single value.

If you add a filter using a numeric field, such as a measure, (for example, Cost of Goods), you can use a slider to adjust the range of data values that display, as shown in the following image.

Click the filter, and use the slider options on either side to modify the range of data values. You can set a range using both ends of the slider.

The filter for a numeric field is a WHERE TOTAL filter. That means that the filter is applied after aggregation for all sort values in the chart instead of filtering each row of the data source before aggregation.

If you right-click a numeric filter and select Greater than, you can select a minimum value to display. The upper limit on the slider is fixed and cannot be moved. Similarly, if you right-click a numeric filter and select Less than, you can select a maximum value to display. The lower limit on the slider is fixed and cannot be moved.

Note: The slider displays the Greater than (>) and Less than (<) symbols to differentiate your choices.

If you add a date field, you can use the date picker window to select a start or end date, range of dates, and more, as shown in the following image.

If you right-click a date filter and click After or Before, you are unable to select a range using either the preset or custom range options. Instead, use the calendar to select a start or end date for the filter.

In addition to the options specific to each type of filter, you can right-click any filter and click Require selection to make the filter required. When a filter is required, the chart will not load until the user makes a selection for that filter.