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 the Histogram analysis, the column headers can take on the following values:
- Bin Range — The high and low values in each bin. This column header will be present unless the Cross-tab (Multi-dimensional Analysis) options is selected.
- Single Count — The number of occurrences within the specified bin. This column header will be present when the Show Single Counts radio button is enabled; see below.
- Overlay — The distinct values of the variable specified by the Overlay Columns option.
- Overlay Count — The number of occurrences of the overlay value within the specified bin. This column header will only be present if the Overlay Columns option is selected.
- <Variable Name> — The name of the column that the Histogram analysis was executed against. When the Crosstab option is selected, there will be one <Variable Name> column for each variable selected in the analysis.
- Count — The number of occurrences of the cross-tabulated variable values. This column header will only be present when the Crosstab option is selected.
- Min/Max/Mean/Std — Respectively, the minimum, maximum, mean and standard deviation of the variable specified by the Statistics Columns option.