Manipulate Tables

Above a table there are a number of drop-down boxes, one for each variable, or if tabular (cube) data, one for each table dimension. Survey data may also include a 'Type' and/or a 'Measure' box.

These boxes can be used to change the displayed information and to create new categories using the 'Insert calculation' functionality.

draganddrop

  [click to enlarge image]

This section contains information on:

Item Level Metadata

When opening a tablular/cube dataset you may find a marker in the top left corner of some cells. This indicates that information is available about that cell. If you hover over the cell marker information about that cell will be displayed as a 'tool-tip'. There may also be markers for certain categories in either the the table header or row information. These indicate that information is available for those specific categories.

Variable/Dimension boxes

These enable you to:

Selecting an option will automatically recreate the table. For 'Custom selection' and 'Insert calculation' a new window will open containing the available options.

Custom selection

This option will open a new window containing a list of categories for the chosen variable/dimension. Categories can selected by:

Subcategories may be present and these are indicated by a '+' next to a category name. Click on the '+' to expand each category in turn, or use the options 'Expand tree' or 'Collapse tree' as necessary.

Click on the OK button to update the table with the selected categories.

The selection criteria for the categories can be changed using the options available under the dropdowns for each selected variables.

table-options-categories

  [click to enlarge image]

 

table-options-categories-change-selection

  [click to enlarge image]

Sorting rows and columns

Clicking a row or column heading will display icon if that row or column can be sorted. Select one of the following options to sort your chosen row or column:

Filter box

The Filter option can be modified as shown below.

table-options-filter

  [click to enlarge image]

Type box

When no 'measure' variable has been added to a survey-based table, the numbers in the table represent either the number of cases or the percentage of cases. For crosstabulations, 'Column percentage' is displayed by default. The Type drop-down box contains the following options: Column Percentage, Row Percentage, Raw Numbers, or Row and Column Percentage, which can be selected as necessary.

Measure box

For survey data, when a variable is added as a 'measure' to a table, the numbers in the table represent the measure variable. For example, in a cross tabulation of 'Marital status' and 'Gender' with 'Age' as the measure variable, the values in the table, by default, represent the average age for each combination of 'Marital status' and 'Gender' category.

Other values available for survey data are (with examples):

Tabular (cube) datasets always have a 'Measure' box. If more than one measure is available, e.g. numbers and percentages, these can be selected from this box.

 

table-options-measure-thumb

  [click to enlarge image]

Drag and drop

When working with tables, Nesstar WebView also supports drag and drop to alter a table. It is possible to drag variables in and out of the table, and to move a variable from column to row and vice versa.

To drag a variable already in the table, click and hold the cell containing its name. The cell will “jump” out and attach itself to the mouse pointer, and droppable areas will light up. These are usually the opposite table position (column or row) or the area above the table where all the variables in use are shown. Drag the variable to a drop area and drop it by releasing the mouse button.

draganddrop_from_table_thumb

To move a variable into the table, it must already be in the table as filter. This is indicated by a “handle” on the left side of the variable's drop down box in the area above the table. Click and hold this handle to drag it and drop it on either the column or row label cells.

draganddrop_to_table_thumb

To cancel a drag, simply release the mouse button while holding the dragged cell outside a drop area.

The following 'drag and drop' options are supported.

Dropping variables onto other variables will rearrange the layout of the table.