Open main menu

TaticView β

Changes

Filters

828 bytes added, 22:48, 4 October 2022
no edit summary
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.<languages/>
[[File:Filter.PNG]]
<translate>
<!--T:1-->
[[File:mainmenu5.png]]
'''See a [[Object and Column Filters|video tutorial]] about how to use filters'''.
 
<!--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-->* Not '''Greater or equal to''': Data must be different from greater or equal to the selection(chronological for ''Date'' columns and alphabetical for ''Text'' columns);
<!--T:12-->* Less than'''Contains''': Data must be lesser than the selection (chronological for ''Datecontain'', ''starts with'' columns and alphabetical for or ''Textend with'' the input text. For Text columns)only;
<!--T:13-->* Greater than'''Do not contains''': Data must be greater than the selection (chronological for not ''contain'', ''Datestarts with'' columns and alphabetical for or ''Textend with'' the input text. For Text columns)only;
<!--T:14-->* Less or equal to'''Between''': Data must be lesser or equal to between the chronological selection (chronological for ''. For Date'' columns and alphabetical for ''Text'' columns)only;
<!--T:15-->* Greater or equal to'''Not between''': Data must be greater or equal to not between the chronological selection (chronological for ''. For Date'' columns and alphabetical for ''Text'' columns)only;
* Multiple Selection (In): Data must be equal to any of the selected content (right column);
[[File:Filter_multiple.PNG]]
<!--T:16-->
Text type columns can be filtered by selecting the desired values.
* Between: Data must be between the selection (chronological for ''Date'' columns and alphabetical for ''Text'' columns);
<!--T:22-->[[File:Filter_rangeFilter_basic_en.PNGpng|link=]]
<!--T:23-->
Basic selection screen.
* Like: Data must ''Starts with'', ''Contain'' or ''Ends with'' the entered text. Available for ''Text'' columns only.
<!--T:24-->[[File:Filter_likeFilter_adv_en.PNGpng|link=]]
<!--T:25-->
Advanced selection screen.
'''Options'''
* Clear all<!--T: Remove all previous selections 17-->Date type columns can be filtered by date parts (expand the date column by the plus icon), by preset Shortcuts (like ''Current Year'' and set filters;''Next 2 months'') or by selecting a specific date.
* Edit Expression<!--T: Allows to manually create and edit filter rules by using programming language;26-->[[File:Filter_dates_short_en.png|link=]][[File:Filter_dates_calen_en.png|link=]]
[[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>