Filters

It is possible to filter the data displayed in the object by one or more Date or Text columns of the Data Source using the available operators.

Operators

• Equal to: Data must be equal to the selection;

• Not equal to: Data must be different from the selection;

• 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);

• Multiple Selection (In): Data must be equal to any of the selected content (right column);

• Between: Data must be between the selection (chronological for Date columns and alphabetical for Text columns);

• Like: Data must Starts with, Contain or Ends with the entered text. Available for Text columns only.

Options

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

• Edit Expression: Allows to manually create and edit filter rules by using programming language;

Applies to

Table, Cross Table, Column Chart, Bar Chart, Line Chart, Area Chart, Pie Chart, Cross Column Chart, Cross Bar Chart, Cross Line Chart, Cross Area Chart, Combo (Filter), Gauge