A data-grid control is used to select the data to display. Much like a Microsoft Excel pivot-table, the Data Grid has the following properties:
- Select — The data to be graphed can be selected by either clicking in the left upper most square of the Data Grid to select the entire data set, or holding the left mouse button down, dragging over the desired rows and releasing the mouse button. The rows highlighted will be graphed automatically.
- Sort — To sort the data in the Data Grid, click the right mouse button on any column header. The sort is always done from left to right with respect to the columns of data. Subsequent right mouse clicks toggle the sort from ascending to descending.
- Pivot — Pivoting of data is accomplished by holding the left mouse button down on the column header that you wish to pivot, dragging the column to its new desired position and releasing the mouse button. The pivoted column will appear to the left of the column that it was dragged on top of.
For a Values analysis, column headers can take on the following values:
- Table — Table that the variable for the values operation resides in, as specified by the “table” parameter.
- Column — Variable that the values operation will be run against, as specified by the “column” parameter.
- Type — Sata type of this variable.
- Count — Total number of occurrences of this variable.
- Null — Total number of rows where this variable takes on a null value.
- Unique — Total number of rows where this variable takes on a unique value.
- Blank — Total number of rows where this variable is blank.
- Zero — Total number of rows where this variable is equal to 0.
- Pos — Total number of rows where this variable has a positive value.
Neg — Total number of rows where this variable has a negative value.
If a single group by column was specified, an additional group by selector is displayed, with a column header that is the name of the group by column. All distinct values of the group by column are shown and can be selected for display.