Difference between revisions of "Applying filters to individual tables in an InfoEx report"

From InfoEx Help Information
Jump to navigation Jump to search
m (Functionality tested by)
(Step-by-step description)
 
(21 intermediate revisions by 3 users not shown)
Line 2: Line 2:
 
{{Requirements|UserLevel=All user levels|Connectivity=Online only}}
 
{{Requirements|UserLevel=All user levels|Connectivity=Online only}}
  
This page shows you how to exclude specific operations from your InfoEx reports.
+
This page shows you how to exclude specific observations from your InfoEx reports.
  
 
==Background==
 
==Background==
Each table of observations in an InfoEx report can be individually customized to exclude information that you do not require
+
Each table of observations in an InfoEx report can be individually customized to exclude information that you do not require.
 
+
{{Note|It is recommended that you only use the filtering functionality described in this document on table-specific parameters. To filter the entire report by date and/or locations, please use the following approaches:
The following information assumes you are logged in to the InfoEx application, you have selected an operation (if you have more than one valid operation) and you have selected 'Reports' on the main application menu.
+
* [[Specifying the date or date range of an InfoEx report]]
 +
* [[Restricting the locations included in an InfoEx report]]|NoteWithImage}}
  
 
==Step-by-step description==
 
==Step-by-step description==
Line 14: Line 15:
 
|-
 
|-
 
|class="StepNum" | 1.
 
|class="StepNum" | 1.
|[[File:SelectingAReport.png|300px|thumb|right|Fig. 1: Selecting a report]]Select the report that you want to view
+
|[[File:FilterPopupOnly.png|300px|thumb|right|Fig. 1: Filter popup]]Left-click on any column of the table's top line (except the date and locations column). From the popup menu select 'Filter' (Fig. 1).
 
|-
 
|-
 
|class="StepNum" | 2.
 
|class="StepNum" | 2.
|[[File:FilterPopupOnly.png|300px|thumb|right|Fig. 2: Filter popup]]Click on any column of the table's top line (except the date and locations column). From the popup menu select '''Filter'''
+
|Each column has different options for filtering. Filter options depend on the character of the parameter shown in the table column:
 
|-
 
|-
|class="StepNum" | 3.
+
|class="StepNum" |  
|Each column has options for filtering. There are two basic kinds of filters:
+
|[[File:FilterPopup.png|300px|thumb|right|Fig. 3: Filter by selection]]
{|class="TblSteps"
+
* '''Categorical observation parameters'''<br/>These types of parameters can be filtered by selecting the values to be included in the table from a list. Only entries matching selected values will be retained for your report (Fig. 3).
 +
|-
 +
|class="StepNum" |
 +
|[[File:FilterByValue.png|300px|thumb|right|Fig. 4: Filter by value]]
 +
* '''Numerical observation parameters'''<br/>These types of parameters can be filtered with a range of numerical conditions (Fig. 4). You may select a threshold value, filter values that are equal to your selected value, or filter for non-empty values (non-null).
 
|-
 
|-
|class="StepNum" | Select/Deselect:
+
|class="StepNum" |
|[[File:FilterPopup.png|300px|thumb|right|Fig. 3: Filter by selection]]With this kind of filter you can select and deselect items from a list. Only entries matching selected values will be retained for your report.
+
|
 +
* '''Free-form text fields'''<br/>It is not possible to filter general comment fields.  
 
|-
 
|-
|class="StepNum" | Value:
+
|class="StepNum" | 3.
|[[File:FilterByValueMain.png|300px|thumb|right|Fig. 4: Filter by value]][[File:FilterByValue.png|300px|thumb|right|Fig. 4: Filter by value]]With this kind of filter you can include entries that are related to a selected numerical value. You may select a threshold value or filter values that are identically equal to your selected value.
+
|The table will immediately be updated with new filter condition without downloading the data from the server again.
 
|-
 
|-
 
+
|class="StepNum" | 4.
 
+
|Concatenated columns (e.g. Size in Avalanche Obs) cannot be filtered. However you can filter on the raw data columns that are used for the concatenation (e.g. Size Typ and Size Max)
|}
 
 
 
 
|}
 
|}
  
 
==Related documents==
 
==Related documents==
* Link to relate document 1
+
{{PagesInfoExReport}}
* Link to relate document 2
 
  
 
==Functionality tested by==
 
==Functionality tested by==
* Date: Oct. 29: John Kelly / QA Server / Test Version 0.32.00)
+
* Dec. 31, 2013: Pascal Haegeli
  
[[Category:Help Files]]
 
 
[[Category:Super User]][[Category:Operation Administrator]][[Category:Submission Moderator]][[Category:User]]
 
[[Category:Super User]][[Category:Operation Administrator]][[Category:Submission Moderator]][[Category:User]]
[[Category:Reports]]
+
[[Category:Reports]][[Category:Version 3.4.0]]
[[Category:Software Issues]][[Category:Version 0.32.00]]
 

Latest revision as of 15:56, 31 May 2017

REQUIREMENTS
Permission All user levels
Connectivity Online only

This page shows you how to exclude specific observations from your InfoEx reports.

Background

Each table of observations in an InfoEx report can be individually customized to exclude information that you do not require.

NOTE It is recommended that you only use the filtering functionality described in this document on table-specific parameters. To filter the entire report by date and/or locations, please use the following approaches:

Step-by-step description

1.
Fig. 1: Filter popup
Left-click on any column of the table's top line (except the date and locations column). From the popup menu select 'Filter' (Fig. 1).
2. Each column has different options for filtering. Filter options depend on the character of the parameter shown in the table column:
Fig. 3: Filter by selection
  • Categorical observation parameters
    These types of parameters can be filtered by selecting the values to be included in the table from a list. Only entries matching selected values will be retained for your report (Fig. 3).
Fig. 4: Filter by value
  • Numerical observation parameters
    These types of parameters can be filtered with a range of numerical conditions (Fig. 4). You may select a threshold value, filter values that are equal to your selected value, or filter for non-empty values (non-null).
  • Free-form text fields
    It is not possible to filter general comment fields.
3. The table will immediately be updated with new filter condition without downloading the data from the server again.
4. Concatenated columns (e.g. Size in Avalanche Obs) cannot be filtered. However you can filter on the raw data columns that are used for the concatenation (e.g. Size Typ and Size Max)

Related documents

Customizing reports

[1] Click to watch a help video
[2] Click to watch a help video

Managing report templates

Viewing report templates

Map Layers

Charts

Functionality tested by

  • Dec. 31, 2013: Pascal Haegeli