Cloudera Docs

Filter data using the include option in the context menu

You can click on a mark of a visual and include selected values in the filter shelf of the visual designer.

The Include option is enabled by default in all visual types except Table and Queries visual types.

Follow these steps to include selected values in a visual.

  1. For Table and Queries visual types, in Edit mode, navigate to the Marks menu, and select the Show Context Menu.
  2. Click any mark of the visual to open the tooltip and the context menu.
  3. In the context menu that appears, click Include. Here, we are selecting the line for Africa, in year 1985.

    These values are added in the filter shelf of the visual designer.

  4. Click REFRESH VISUAL.

    After applying the Include filter, the following image only shows the average life expectancy in Africa in year 1985.