Difference between revisions of "Filters"
| Line 1: | Line 1: | ||
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. | 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. | ||
| − | [[File:Filter.PNG]] | + | [[File:Filter.PNG|link=]] |
'''Operators''' | '''Operators''' | ||
| − | * Equal to: Data must be equal to the selection; | + | * '''Equal to''': Data must be equal to the selection; |
| − | * Not equal to: Data must be different from 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); | + | * '''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); | + | * '''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); | + | * '''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); | + | * '''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); | + | * '''Multiple Selection (In)''': Data must be equal to any of the selected content (right column); |
| − | [[File:Filter_multiple.PNG]] | + | [[File:Filter_multiple.PNG|link=]] |
| − | * Between: Data must be between the selection (chronological for ''Date'' columns and alphabetical for ''Text'' columns); | + | * '''Between''': Data must be between the selection (chronological for ''Date'' columns and alphabetical for ''Text'' columns); |
| − | [[File:Filter_range.PNG]] | + | [[File:Filter_range.PNG|link=]] |
| − | * Like: Data must ''Starts with'', ''Contain'' or ''Ends with'' the entered text. Available for ''Text'' columns only. | + | * '''Like''': Data must ''Starts with'', ''Contain'' or ''Ends with'' the entered text. Available for ''Text'' columns only. |
| − | [[File:Filter_like.PNG]] | + | [[File:Filter_like.PNG|link=]] |
| Line 36: | Line 36: | ||
'''Options''' | '''Options''' | ||
| − | * Clear all: Remove all previous selections and set filters; | + | * '''Clear all''': Remove all previous selections and set filters; |
| − | * Edit Expression: Allows to manually create and edit filter rules by using programming language; | + | * '''Edit Expression''': Allows to manually create and edit filter rules by using programming language. After manually editing the expression the others operators cannot be used until you clear all the filters; |
| − | [[File:Filter_edit_exp.PNG]] | + | [[File:Filter_edit_exp.PNG|link=]] |
Revision as of 18:55, 13 May 2013
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. After manually editing the expression the others operators cannot be used until you clear all the filters;
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
