How to filter data?

Why to filter?

Iptim allows you to filter data in your data sets (e.g. stand registers or sample plots). Filtering data allows you to discriminate, from your view, the data that is particularly relevant (e.g. certain stands, stands above a certain age, stands with a density between certain values).

Accessing the "filter window"

1. Click on filter.
   
2. The "filter window" is now visible:
   

Basics of filtering

The filter instructions are composed of three components:

1. the variable that you want to filter (e.g. stand, age, or any other variable in the data set)
2. the connector, for example:
   1. equal to (=)
   2. greater than (>)
   3. greater or equal to (>=)
   4. smaller than (<)
   5. smaller or equal to (<=)
   6. not equal (!=)
   7. or (||)
   8. and (applied by entering another line)
3. the restriction which needs to be set between quotation marks.

Examples: filtering one restriction

Example 1.1: Filter stand 10381 (NOTE: in this example, the stand id column is named "stand id").

1. Write the following in the filter window:
   stand id = "10381" 
2. Click on Filter.
   

Example 1.2: Another option to filter a stand name 10381 is to:

1. Highlight the stand that you want to filter by clicking on the respective "stand id" cell
2. Right-click with the mouse.
3. Click on Add filter
4.  Click on Filter.
   

Examples: filtering a range of values

Example 2: Filter stands with age higher than 10 but lower than 20:

1. Write the following in the filter window:
   age > "10"
   age < "20"
2. Click on Filter.
   

Examples: filtering multiple variables that do not share the same restriction

Example 2.1: Filter stands 10381 and 10315.

1. Write the following in the filter window:
   (stand id = "10381" || stand id = "10315")
2. Click on Filter.
   

Example 2.2: Another option to filter stands 10381 and 10315:

1. Highlight the first stand that you want to filter by clicking on the respective "stand id" cell
2. Press Ctrl (in Windows) or Cmd (in Mac) and click on the other stand.
3. Right-click with the mouse.
4. Click on Add filter.
5. Click on Filter.
   

Erase a filter

1. Click on Clear (in the filter window).
2. Click on Filter.