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.
On the Filters shelf, click Down
Arrow on the year field placed there earlier, then click
- 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.
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.