Filters/en

See a video tutorial about how to use filters.

It is possible to filter data by one or more Date or Text columns of the Data Source using the available operators. Filters can be set by users, objects or columns.

File:Filter.PNG

Operators

• Equal to: Data must be equal to the selection. Multiple values can be selected by holding CRTL key or using advanced selection mode;

• Not equal to: Data must be different from the selection. Multiple values can be selected;

• Less than: Data must be lesser than the selection (chronological for Date columns and alphabetical for Text columns);

• Greater than: Data must be greater than the selection (chronological for Date columns and alphabetical for Text columns);

• Less or equal to: Data must be lesser or equal to the selection (chronological for Date columns and alphabetical for Text columns);

• Greater or equal to: Data must be greater or equal to the selection (chronological for Date columns and alphabetical for Text columns);

• Contains: Data must contain, starts with or end with the input text. For Text columns only;

• Do not contains: Data must not contain, starts with or end with the input text. For Text columns only;

• Between: Data must be between the chronological selection. For Date columns only;

• Not between: Data must be not between the chronological selection. For Date columns only;

Text type columns can be filtered by selecting the desired values.

Basic selection screen.

Advanced selection screen.

Date type columns can be filtered by date parts (expand the date column by the plus icon), by preset Shortcuts (like Current Year and Next 2 months) or by selecting a specific date.

Options

• Clear all: Remove all previous selections and set filters;