If you have a large amount of data, you can enable the filter function to filter out data from a dataset.

Filters can filter data from character classes, numeric classes, and date classes.

Character classes

You can filter the municipalities from the province field through the filter function.

You can filter the municipalities from the province field through the filter function.

  1. Drag Province field to the Filters area, as shown in the following figure.
  2. Click Fliter icon
  3.  Select Enum option. All the items are automatically listed in the dialog window. See the following figure.


  4. Enter the field name manually, or select the required city names from the list.
  5. After the settings, click OK
  6. Click Update. The system then re-creates a chart based on the filter settings.

Numeric classes

You can set a numeric range to filter data. For example, you can set the range of the number of orders to 50,000 to 100,000. Then the chart displays data within the specified range.

The following procedure uses the profit_amt field as an example to describe how to filter data.

  1. Drag the profit_amt field from the measurement list to the Filters area.
  2. Click the Filter icon, and set filter conditions.
  3. Select the expected filter conditions from the drop-down lists, such as Greater Than, Less Than, or Equal To. See the following figure.


  4. Click OK
  5. Click Update. The system then re-creates a chart based on the filter settings.

Date classes

You can filter the data in a time period by using the filter function. For example, filter the order amount from 2013 to 2015.

Note
Time data can be accurate to seconds.

The following procedure uses the report_date(year) field as an example

  1. Drag the report_date(year) field from the measurement list to the Filters area. Click the Filter icon, and set filter conditions.
  2. Select a time period, for example, select Absolute Time, and set the time range from 2013 to 2015. See the following figure.


  3. After the settings, click OK.
  4. Click Update. The system then re-creates a chart based on the filter settings.