Filters

From TaticView
Revision as of 18:55, 13 May 2013 by Luiz (talk | contribs)
Jump to: navigation, search

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.

File:Filter.PNG


Operators

  • Equal to: Data must be equal to the selection;
  • Not equal to: Data must be different from the selection;
  • 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);
  • Multiple Selection (In): Data must be equal to any of the selected content (right column);

File:Filter multiple.PNG


  • Between: Data must be between the selection (chronological for Date columns and alphabetical for Text columns);

File:Filter range.PNG


  • Like: Data must Starts with, Contain or Ends with the entered text. Available for Text columns only.

File:Filter like.PNG


Options

  • Clear all: Remove all previous selections and set filters;
  • Edit Expression: Allows to manually create and edit filter rules by using programming language. After manually editing the expression the others operators cannot be used until you clear all the filters;

Filter edit exp.PNG


Applies to

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

Retrieved from "http://wiki.taticview.com/index.php?title=Filters&oldid=558"