Cloudera Docs

Selecting discrete values on filter shelves

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

For selecting discrete numbers in a filter, let's use the example from building Cross tabulation, 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.
  3. Click Apply.
  4. 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 Selecting a range of number values on filter shelves. We can also choose the desired combination of filters by specifying an Selecting values by using an expression on filter shelves.