Selecting Discrete Values on Filter Shelves

It is very simply to select discrete values on the filter shelf for all datatypes: numerical, string, date, and so on.

For selecting discrete numbers in a filter, let's use the example from building Cross Tabulation Visuals, where we specify several discrete years of the dataset World Life Expectancy.

  1. On the Filters shelf, click (down arrow) on the year field placed there earlier, then click Select values.

  2. In the Filter for year modal window, under the Values tab, select 1900, 1910, 1920, 1930, 1940, 1950, 1960, 1970, 1970, 1980, 1990, 2000, and 2010, then click Apply.

  3. After clicking Refresh Visual, the cross-tabulation visual appears. Note the years we specified in the previous step.

Alternatively, with a numerical data, we can specify a Range of Values on the Filter Shelf. We can also choose the desired combination of filters by specifying an Expression on the Filter Shelf.