Open main menu

TaticView β

Changes

Filters

1,419 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;   <!--T:16-->Text type columns can be filtered by selecting the desired values.  <!--T:22-->[[File:Filter_basic_en.png|link=]] <!--T:23-->Basic selection screen.  <!--T:24-->[[File:Filter_adv_en.png|link=]] <!--T:25-->Advanced selection screen. 
* Not equal to: Data must be different from the selection;
* Less than<!--T: Data must 17-->Date type columns can be lesser than filtered by date parts (expand the date column by the selection plus icon), by preset Shortcuts (chronological for like ''DateCurrent Year'' columns and alphabetical for ''TextNext 2 months'' columns);or by selecting a specific date.
* Greater than<!--T: Data must be greater than the selection (chronological for ''Date'' columns and alphabetical for ''Text'' columns);26-->[[File:Filter_dates_short_en.png|link=]][[File:Filter_dates_calen_en.png|link=]]
* 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);
<!--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)</translate>