Open main menu

TaticView β

Changes

Filters

729 bytes added, 22:48, 4 October 2022
no edit summary
Specifies fixed content filters in the object.<languages/>
For run-time dynamic 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-->* Not equal to'''Greater than''': Data must be different from greater than the selection(chronological for ''Date'' columns and alphabetical for ''Text'' columns);
<!--T:10-->* '''Less thanor equal to''': Data must be lesser than or equal to the selection (chronological for ''Date'' columns and alphabetical for ''Text'' columns);
<!--T:11-->* '''Greater thanor equal to''': Data must be greater than or equal to the selection (chronological for ''Date'' columns and alphabetical for ''Text'' columns);
<!--T:12-->* Less or equal to'''Contains''': Data must be lesser or equal to the selection (chronological for ''Datecontain'', ''starts with'' columns and alphabetical for or ''Textend with'' the input text. For Text columns)only;
<!--T:13-->* Greater or equal to'''Do not contains''': Data must be greater or equal to the selection (chronological for not ''contain'', ''Datestarts with'' columns and alphabetical for or ''Textend with'' the input text. For Text columns)only;
<!--T:14-->* Multiple Selection (In)'''Between''': Data must be equal to any of between the selected content (right column)chronological selection. For Date columns only;
[[File<!--T:Filter_multiple15-->* '''Not between''': Data must be not between the chronological selection.PNG]]For Date columns only;
* Between: Data must be between the selection (chronological for ''Date'' columns and alphabetical for ''Text'' columns);
[[File<!--T:Filter_range16-->Text type columns can be filtered by selecting the desired values.PNG]]
* Like<!--T: Data must ''Starts with'', ''Contain'' or ''Ends with'' the entered text. Available for ''Text'' columns only22-->[[File:Filter_basic_en.png|link=]]
[[File<!--T:Filter_like23-->Basic selection screen.PNG]]
 
<!--T:24-->
[[File:Filter_adv_en.png|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>