Filtering limits the data that appears in the selected gadget. Each gadget can filter the data it receives from a data object, independently of other gadgets. Filter conditions can use any data in the selected data set or data cube. Multiple filter conditions can combine to form filters that are more complex than a single filter.

Filter operators depend on the data in the selected field. A string field offers the following filter conditions:

A number field offers the following additional filter condition operators:

Business users and developers can edit filter conditions in the gadget data settings if they have permission to edit the dashboard in which the gadget is located. Users can interactively add filter conditions to data appearing inside data visualization gadgets, but these additional filters only use data already received by the gadget. Data available for interactive filtering is data that already matches any parameters on the data object, that already matches the data source filtering of the gadget, and that is being displayed in the gadget.

For example, a gadget uses a data object that displays product orders. The data object contains a field naming the country where the product was sold. The gadget does not display the country field. The dashboard developer can filter the gadget’s data source to show orders from selected countries. In the example, users cannot use interactive filtering to select the country because the country does not appear in the gadget. Interactive filtering of the gadget by users can only filter the country field if that field appears in the gadget.