Open main menu

TaticView β

Changes

Filters

167 bytes added, 17:02, 27 January 2016
no edit summary
<!--T:2-->
It is possible to filter data by one or more ''Date'' or ''Text'' '''Dimension''' columns of the ''Data Source'' using the available operators'''Conditions'''. Filters can be set by [[Permission filters|users]], [[Object Filters|objects]] or [[Column filters|columns]]. 
<!--T:3-->
[[File:FilterFilter_main_en.PNGpng|link=]] 
<!--T:4-->
Date type columns can be filtered by date parts (expand the date column by the plus icon), by preset shortcuts (like ''Current Year'' and ''Next 2 months'') or by [[Custom date shortcuts|created shortcuts]].
<!--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-->
<!--T:12-->
* '''Multiple Selection (In)Contains''': Data must be equal to any of ''contain'', ''starts with'' or ''end with'' the selected content (right column)input text. For Text columns only;
<!--T:13-->
[[File* '''Do not contains''':Filter_multipleData must not ''contain'', ''starts with'' or ''end with'' the input text.PNG|link=]]For Text columns only;
<!--T:14-->
* '''Between''': Data must be between the chronological selection (chronological for ''. For Date'' columns and alphabetical for ''Text'' columns)only;
<!--T:15-->
[[File* '''Not between''':Filter_rangeData must be not between the chronological selection.PNG|link=]]For Date columns only; 
<!--T:16-->
* '''Like'''Text type columns can be filtered by selecting the desired values.  [[File:Filter_basic_en.png|link=]] Basic selection screen.  [[File: Data must ''Starts with'', ''Contain'' or ''Ends with'' the entered textFilter_adv_en. Available for ''Text'' columns onlypng|link=]] Advanced selection screen.  
<!--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'' and ''Next 2 months'') or by selecting a specific date. [[File:Filter_dates_short_en.png|link=]][[File:Filter_likeFilter_dates_calen_en.PNGpng|link=]]
* '''Clear all''': Remove all previous selections and set filters;
<!--T:20-->
* '''Edit Expression''': Allows to manually create and edit filter rules by using programming language. See [[Expressions]].
 
<!--T:21-->
[[File:Filter_edit_exp.PNG|link=]]
</translate>