Difference between revisions of "Filters"

From TaticView
Jump to: navigation, search
 
(19 intermediate revisions by 4 users not shown)
Line 1: Line 1:
−
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 ''Date'' or ''Text'' columns of the ''Data Source'' using the available operators.
+
<translate>
 +
<!--T:1-->
 +
[[File:mainmenu5.png]]
 +
'''See a [[Object and Column Filters|video tutorial]] about how to use filters'''.
  
−
[[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'''
 
'''Operators'''
  
−
* Equal to: Data must be equal to the selection;
+
<!--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);
  
−
* Not equal to: Data must be different from the selection;
+
<!--T:9-->
 +
* '''Greater than''': Data must be greater than the selection (chronological for ''Date'' columns and alphabetical for ''Text'' columns);
  
−
* Less than: Data must be lesser 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);
  
−
* Greater than: Data must be greater than 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);
  
−
* Less or equal to: Data must be lesser 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;
  
−
* Greater or equal to: Data must be greater or equal to the selection (chronological for ''Date'' columns and alphabetical for ''Text'' columns);
+
<!--T:13-->
 +
* '''Do not contains''': Data must not ''contain'', ''starts with'' or ''end with'' the input text. For Text columns only;
  
−
* Multiple Selection (In): Data must be equal to any of the selected content (right column);
+
<!--T:14-->
 +
* '''Between''': Data must be between the chronological selection. For Date columns only;
  
−
[[File:Filter_multiple.PNG]]
+
<!--T:15-->
 +
* '''Not between''': Data must be not between the chronological selection. For Date columns only;
  
  
−
* Between: Data must be between the selection (chronological for ''Date'' columns and alphabetical for ''Text'' columns);
 
  
−
[[File:Filter_range.PNG]]
+
<!--T:16-->
 +
Text type columns can be filtered by selecting the desired values.
  
  
−
* Like: Data must ''Starts with'', ''Contain'' or ''Ends with'' the entered text. Availabre for ''Text'' columns only.
+
<!--T:22-->
 +
[[File:Filter_basic_en.png|link=]]
  
−
[[File:Filter_like.PNG]]
+
<!--T:23-->
 +
Basic selection screen.
  
 +
 +
<!--T:24-->
 +
[[File:Filter_adv_en.png|link=]]
 +
 +
<!--T:25-->
 +
Advanced selection screen.
  
  
−
'''Options'''
 
  
−
* Clear all: Remove all previous selections and set filters;
+
<!--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.
  
−
* Edit Expresssion: Allows to manually create and edit filter rules by using programming language;
+
<!--T:26-->
 +
[[File:Filter_dates_short_en.png|link=]]
 +
[[File:Filter_dates_calen_en.png|link=]]
  
−
[[File:Filter_edit_exp.PNG]]
 
  
  
 +
<!--T:18-->
 +
'''Options'''
  
−
'''Applies to'''
+
<!--T:19-->
 +
* '''Clear 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>

Latest revision as of 22:48, 4 October 2022

Other languages:
English • ‎português do Brasil


Mainmenu5.png See a video tutorial about how to use filters.


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 users, objects, columns or dashboards.


Filter main en.png


Operators

  • Equal to: Data must be equal to the selection. Multiple values can be selected by holding CRTL key or using advanced selection mode;
  • Not equal to: Data must be different from the selection. Multiple values can be selected;
  • Less than: Data must be lesser than the selection (chronological for Date columns and alphabetical for Text columns);
  • Greater than: Data must be greater than the selection (chronological for Date columns and alphabetical for Text columns);
  • 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);
  • Contains: Data must contain, starts with or end with the input text. For Text columns only;
  • Do not contains: Data must not contain, starts with or end with the input text. For Text columns only;
  • Between: Data must be between the chronological selection. For Date columns only;
  • Not between: Data must be not between the chronological selection. For Date columns only;


Text type columns can be filtered by selecting the desired values.


Filter basic en.png

Basic selection screen.


Filter adv en.png

Advanced selection screen.


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.

Filter dates short en.png Filter dates calen en.png


Options

  • Clear all: Remove all previous selections and set filters;
Retrieved from "http://wiki.taticview.com/index.php?title=Filters&oldid=29670"