Cloudera Docs

Filtering 2: bar chart by region

When working with a very large set of data, it is necessary to quickly access and examine a specific subset of information. CDP Data Visualization gives you the ability to filter information on all fields of the dataset.

This example shows how to use such a filter to limit the result set and visualization to a particular geographic region. It uses the visual previously created in Bars. Clone it and make the changes to the duplicate visual.

To use this visual to see a bar chart for a region, such as Oceania, follow these steps:

  1. Add the field un-region to the Filters shelf, and set its value to Oceania:
    1. Click the field on the shelf of the visual to open the FIELD PROPERTIES menu.
    2. Click Select values.
    3. In the Filter for un_region modal window, select Oceania and click APPLY.
  2. Click REFRESH VISUAL.
    The Bars visual changed to show only the countries in the Oceania UN Region.
  3. Remove un_region from the Colors shelf, and replace it with the country field.
  4. Click REFRESH VISUAL.
  5. Rename the visual.
  6. At the top left corner of the Dashboard Designer, click SAVE.