Stat-Xplore : Working With Tables - Totals, Percentages, Sorting and Codes

This section describes some of the options available when working with tables. It is assumed that you have already read the guide to getting started and you know how to login to Stat-Xplore and create a basic table by dragging and dropping fields or selecting the values you want and using the Add buttons.

Totals

Stat-Xplore automatically adds totals to tables, but you can choose whether to show totals. To show or hide totals, click the menu iconĀ  next to the field name:

In some cases, it may not make sense for a total on certain fields (for example, a time series on a caseload dataset). In this case, we have configured a setting that prevents you from adding a total for that particular field.

Percentages

Use the option at the top of the table area to change the values in the table to percentages:

You can choose from the following options:

OptionDescription
NoneDo not show percentages.
ColumnReplace the values in the table with a percentage of the total in each column.
RowReplace the values in the table with a percentage of the total in each row.

Some of the percentage options are not available for certain types of table.

Percentages are also not supported when opening a saved system table that was originally created in a ready-made table and that contains grand totals generated by that ready-made table.

Sorting

Click the arrows to sort the table:

Use the arrows in the column headings to sort the table based on the values in that column:

Use the arrows shown against the row field name to sort the table based on the row labels:

In both cases, your first click will sort the column or row in ascending order, your second click will sort it in descending order, and your third click will revert back to the default sort order.

Codes

By default, the field labels show the names of the values (such as Male and Female). Select the Codes option from the field menu to display the field codes instead:

This is particularly useful for the unique geographical codes as these can be used to conjunction with other software for mapping and GIS.

Automatically Retrieving Data

By default, whenever you change the fields in the table, you need to click Retrieve Data to run the cross tabulation and display the values.

To avoid the need to click Retrieve Data, you can select the Automatically Retrieve Data option:

When this option is activated, Stat-Xplore automatically performs the cross tabulation whenever you change the table.

For performance reasons you may find it better to leave this option turned off, particularly if you are working with large tables.

Attachments:

SW2-Hide-Total.png (image/png)
SW2-Show-Total.png (image/png)
SW2-Percentages-Row.png (image/png)
SW2-Percentages-Column.png (image/png)
SW2-Percentages-None.png (image/png)
SW2-Percentages-Totals.png (image/png)
SW2-Percentages.png (image/png)
SW2-Sort-Table-Values.png (image/png)
SW2-Sort-RowLabels.png (image/png)
SW2-Show-Codes-2.png (image/png)
SW2-Show-Codes-1.png (image/png)
SW2-Codes.png (image/png)
SW2-Totals.png (image/png)
SW2-Auto.png (image/png)
SW2-Percentages.png (image/png)
SW2-Percentages.png (image/png)
SW2-Percentages.png (image/png)
SW2-Percentages.png (image/png)
SW2-Show-Total.png (image/png)
SW2-Hide-Total.png (image/png)
SW2-Hide-Total.png (image/png)
SW2-Show-Total.png (image/png)
SW2-Sort-RowLabels.png (image/png)
SW2-Sort-Table-Values.png (image/png)
SW2-Show-Total.png (image/png)
SW2-Hide-Total.png (image/png)
SW2-Table-Menu.png (image/png)
SW2-Percentages.png (image/png)
SW2-Percentages-Totals.png (image/png)
SW2-Percentages-Row.png (image/png)
SW2-Percentages-Column.png (image/png)
SW2-Percentages-None.png (image/png)
SW2-Sort-RowLabels.png (image/png)
SW2-Sort-Table-Values.png (image/png)
SW2-Show-Codes-2.png (image/png)
SW2-Show-Codes-1.png (image/png)
SW2-Hide-Total.png (image/png)
SW2-Show-Total.png (image/png)
SW2-Percentages.png (image/png)
SW2-Percentages-None.png (image/png)
SW2-Percentages-Column.png (image/png)
SW2-Percentages-Row.png (image/png)
SW2-Percentages-Totals.png (image/png)
SW2-Sort-Table-Values.png (image/png)
SW2-Sort-RowLabels.png (image/png)
SW2-Show-Codes-1.png (image/png)
SW2-Show-Codes-2.png (image/png)
SW2-Hide-Total.png (image/png)
SW2-Show-Total.png (image/png)
SW2-Percentages.png (image/png)
SW2-Percentages-Row.png (image/png)
SW2-Percentages-Column.png (image/png)
SW2-Percentages-None.png (image/png)
SW2-Percentages-Totals.png (image/png)
SW2-Sort-RowLabels.png (image/png)
SW2-Sort-Table-Values.png (image/png)
SW2-Show-Codes-2.png (image/png)
SW2-Show-Codes-1.png (image/png)