Open main menu

TaticView β

Changes

Filters

840 bytes added, 22:48, 4 October 2022
no edit summary
Specifies fixed content filters in the object.<languages/>
For runtime dinamic filters, see Combo (Filter).
It is possible to filter the data displayed in the object by one or more <translate><!--T:1-->[[File:mainmenu5.png]]''Date'' or ''Text'' columns of the 'See a [[Object and Column Filters|video tutorial]] about how to use filters'Data Source'' using the available operators.
[[File:Filter.PNG]]
<!--T:2-->
It is possible to filter data by one or more ''Date'' or ''Text'' '''Dimension''' columns of the ''Data Source'' using the available '''Conditions'''. Filters can be set by [[Permission filters|users]], [[Object Filters|objects]], [[Column filters|columns]] or [[Dashboard|dashboards]].
 
 
<!--T:3-->
[[File:Filter_main_en.png|link=]]
 
 
 
<!--T:5-->
'''Operators'''
<!--T:6-->* '''Equal to''': Data must be equal to the selection. Multiple values can be selected by holding ''CRTL'' key or using advanced selection mode; <!--T:7-->* '''Not equal to''': Data must be different from the selection. Multiple values can be selected; <!--T:8-->* '''Less than''': Data must be lesser than the selection (chronological for ''Date'' columns and alphabetical for ''Text'' columns); <!--T:9-->* '''Greater than''': Data must be greater than the selection (chronological for ''Date'' columns and alphabetical for ''Text'' columns); <!--T:10-->* '''Less or equal to''': Data must be lesser or equal to the selection(chronological for ''Date'' columns and alphabetical for ''Text'' columns); <!--T:11-->* '''Greater or equal to''': Data must be greater or equal to the selection (chronological for ''Date'' columns and alphabetical for ''Text'' columns); <!--T:12-->* '''Contains''': Data must ''contain'', ''starts with'' or ''end with'' the input text. For Text columns only; <!--T:13-->* '''Do not contains''': Data must not ''contain'', ''starts with'' or ''end with'' the input text. For Text columns only; <!--T:14-->* '''Between''': Data must be between the chronological selection. For Date columns only; <!--T:15-->* '''Not between''': Data must be not between the chronological selection. For Date columns only;
* 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<!--T: Data must 16-->Text type columns can be greater than filtered by selecting the selection (chronological for ''Date'' columns and alphabetical for ''Text'' columns);desired values.
* 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<!--T: Data must be greater or equal to the selection (chronological for ''Date'' columns and alphabetical for ''Text'' columns);22-->[[File:Filter_basic_en.png|link=]]
* Multiple Selection (In)<!--T: Data must be equal to any of the selected content (right column);23-->Basic selection screen.
[[File:Filter_multiple.PNG]]
* Between: Data must be between the selection (chronological for ''Date'' columns and alphabetical for ''Text'' columns);
<!--T:24-->[[File:Filter_rangeFilter_adv_en.PNGpng|link=]]
* Like<!--T: Data must ''Starts with'', ''Contain'' or ''Ends with'' the entered text. Availabre for ''Text'' columns only25-->Advanced selection screen.
[[File:Filter_like.PNG]]
<!--T:17-->Date type columns can be filtered by date parts (expand the date column by the plus icon), by preset Shortcuts (like ''Current Year'Options'and ''Next 2 months'') or by selecting a specific date.
* Clear all<!--T: Remove all selections;26-->[[File:Filter_dates_short_en.png|link=]][[File:Filter_dates_calen_en.png|link=]]
* Edit Expresssion: Allows to manually create and edit filter rules;
[[File:Filter_edit_exp.PNG]]
<!--T:18-->
'''Options'''
<!--T:19-->* '''Applies toClear all''': Remove all previous selections and set filters;
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</translate>
Retrieved from "http://wiki.taticview.com/index.php/Special:MobileDiff/41...29670"