When you work with a large dataset, you can use the filter feature to view only specific types of data from the dataset.

You can filter data of the string, number, or date type.

Filter data in string type

You can filter municipalities from the province field using the filter feature.

Take filtering municipalities as an example.

  1. Drag the province field to the Filter Bar area, as shown in the following figure.
  2. Click the Set Filter icon, and set filtering criteria.
  3. Select the required filtering criteria. For example, select Filter by Enumeration, as shown in the following figure.


  4. Manually enter the field names or select the city names from the list.
  5. After you have specified the fields, click OK.
  6. Click Update. The system automatically redraws the chart based on the filters.

Filter numerical data

You can specify filtering criteria in the filter. For example, you can specify the order number with a value between 50 thousand and 100 thousand. In this case, the chart displays data based on your specified range.

Take filtering profit amount as an example.

  1. Drag the profit amount field to the Filter Bar area.
  2. Click the Set Filter icon, and set filtering criteria.
  3. Select the filters as needed, such as greater than, less than, or equal to, as shown in the following figure.


  4. After you have specified the fields, click OK.
  5. Click Update. The system automatically redraws the chart based on the filters.

Filter data in date type

You can use the filter feature to filter data in a specific date range. For example, you can filter the order amounts in the range from 2013 to 2015.

Note You can filter data in date type exact to seconds.

Take filtering order dates (year) as an example.

  1. Drag the order date (year) field to the Filter Bar area. Click the Set Filter icon, and set filtering criteria.
  2. Select the filters as needed. For example, specify the Absolute Time with the range from 2013 to 2015, as shown in the following figure.


  3. After you have specified the fields, click OK.
  4. Click Update. The system automatically redraws the chart based on the filters.