Filter configuration
The data filtering feature is available for supported chart components that are bound to a data table resource.
Prerequisites
- The data filtering feature supports only the following chart components:
- The chart component must be bound to a data table resource as its data source. For more information, see Data table resource.
Features
- Filter data to display specific results.
- Set filter conditions for string, numeric, and time-based data.
- Display filters as query items to search or filter data dynamically at runtime.
Properties
- Under the dimension or metric sections, click the triangle icon next to a field and select filter.
- Set the filter conditions for the field and click OK.
By default, the chart component displays all data for the field. You can set filter conditions for string, numeric, and time-based data.
The following example shows how to configure a filter for a string field.
Click the input box under Field filtering, enter keywords to search for and select filter values. You can select multiple values.
To filter the field at runtime, select the display as query item checkbox. A query box for the field appears above the component.
Note For line chart, column chart, bar chart, and pie chart components, when you select the display as query item checkbox, a filter icon appears in the upper-right corner of the component.On the preview page, you can click the filter icon to open the configured filter query box.
The properties panel on the right displays the name of the configured filter field.
You can edit or delete configured filters.
Note If you set a field as a filter but do not configure any filter conditions or select the display as query item checkbox, the field does not appear in the filter list in the properties panel.
Style
After setting a filter to display as a query item, click style in the right-hand panel. Expand the filter section to configure the query item's appearance.