Difference between revisions of "Data Tables"

From EHS Help
Jump to: navigation, search
m
m
Line 15: Line 15:
 
* Filtering
 
* Filtering
 
* Grouping
 
* Grouping
 +
 +
 +
== Sorting ==
 +
 +
To sort a data table by a column, click on the column header (avoiding the right hand edge of the column header which is reserved for filtering options).
 +
 +
To indicate a table is sorted by a specific column, that column will show a up or down arrow to the right hand side.  Up or down indicates the direction of the sort, ascending or descending.
 +
 +
To sort by multiple fields:
 +
* Click on the first column header.
 +
* Hold down the ''Shift'' key and click on the secondary sort columns
 +
 +
== Filtering ==
 +
 +
Hover your mouse over a column header to reveal a small filter icon.  Click this and you will be presented with a drop down list of all the distinct values in the sub-set of data that the table represents.
 +
 +
[[File:Data table filtering.png align="left"]]

Revision as of 16:26, 19 September 2013

AquilaCRS icon.png

This topic is for AquilaCRS


Work in progress

Data Tables

Tabular data in AquilaCRS is presented inside a commonly used visual component; the Data Table:

Aquilacrs data table example.png

Every data table has the following key features:

  • Sorting
  • Filtering
  • Grouping


Sorting

To sort a data table by a column, click on the column header (avoiding the right hand edge of the column header which is reserved for filtering options).

To indicate a table is sorted by a specific column, that column will show a up or down arrow to the right hand side. Up or down indicates the direction of the sort, ascending or descending.

To sort by multiple fields:

  • Click on the first column header.
  • Hold down the Shift key and click on the secondary sort columns

Filtering

Hover your mouse over a column header to reveal a small filter icon. Click this and you will be presented with a drop down list of all the distinct values in the sub-set of data that the table represents.

File:Data table filtering.png align="left"