Difference between revisions of "Filters"
(Created page with "Specifies fixed content filters in the object. For runtime dinamic filters, see Combo (Filter). It is possible to filter the data displayed in the object by one or more ''Da...") |
|||
| Line 20: | Line 20: | ||
* Greater or equal to: Data must be greater 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); | ||
| + | |||
| + | [[File:Filter_multiple.PNG]] | ||
| + | * Between: Data must be between the selection (chronological for ''Date'' columns and alphabetical for ''Text'' columns); | ||
| + | |||
| + | [[File:Filter_range.PNG]] | ||
| + | |||
| + | * Like: Data must ''Starts with'', ''Contain'' or ''Ends with'' the entered text. Availabre for ''Text'' columns only. | ||
| + | |||
| + | [[File:Filter_like.PNG]] | ||
| + | |||
| + | |||
| + | '''Options''' | ||
| + | |||
| + | * Clear all: Remove all selections; | ||
| + | |||
| + | * Edit Expresssion: Allows to manually create and edit filter rules; | ||
| + | |||
| + | [[File:Filter_edit_exp.PNG]] | ||
'''Applies to''' | '''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) | + | 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 |
Revision as of 14:51, 11 April 2013
Specifies fixed content filters in the object.
For runtime dinamic filters, see Combo (Filter).
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. Availabre for Text columns only.
Options
- Clear all: Remove all selections;
- Edit Expresssion: Allows to manually create and edit filter rules;
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
