Table of Statistics

For many data tables, you can view a table of statistics for multiple attributes. If the table has one or more category columns, data can, optionally, be grouped by category. To open a table of statistics, right-click on a data table then select Statistics. In the window that appears, select the Table of Statistics option.

In this example, we have the initial table of statistics for a merged table with both category and numeric columns. However, nothing is displayed in the table because data columns have not yet been selected.

An initial table of statistics for a merged table, its display area reading Nothing is selected because no data columns have been chosen yet

The input data selected in the project tree is already present in the Inputs list, and additional inputs can be added by clicking the Add button () below the Inputs list, then moving inputs from Available Inputs to Selected Inputs.

The Select Inputs window, used to move data objects between Available Inputs and Selected Inputs for a table of statistics

Note: when inputs are added to the selected inputs list and the OK button is clicked, a new copy of the table of statistics with the selected inputs will be created and automatically saved to the Saved Statistics folder.

The input selected in the input list will affect the category and numeric data shown below the input list.

The input selected in the Inputs list determines which category and numeric columns are offered in the panel below

The input data used in the table of statistics can be filtered using a Query filter. See the topic Creating a Query Filter for information on creating query filters.

If you wish to remove an input from the Inputs list, click the Add button () below the Inputs list and move inputs from Selected Inputs to Available Inputs.

The Statistics weighting dropdown list will contain different options depending on the object being inspected. For this merged table example, the options are Un-weighted and Length-weighted.

The Statistics weighting dropdown for a merged table, offering Un-weighted and Length-weighted

For a block model, the options are Un-weighted, Volume-weighted and Mass-weighted. When Mass-weighted is selected, you can also specify the Density as a constant number or by referencing a data column that contains density information. There is also an Additional weighting column which allows the selection of another numeric column to use for scaling. This is especially useful for selecting a stored proportion as illustrated here:

Mass-weighted statistics for a block model, with a constant density of 2.5 and a stored proportion being chosen as the additional weighting column

For columns other than stored proportions, you will need to specify the Weighting unit as Decimal or Percentage depending on the content of the data column.

Click the Add button below the Categories list to select from the category columns available in the input table. An entry will be added to the Categories list. Open the dropdown list to select from the available category columns:

Choosing a category column for Level 1 in the Categories list, with Group and ROCK offered

An additional dropdown list will be added, where individual categories of interest can be selected. There are All and None options to provide alternate starting points for category selection.

The second dropdown beside a category column, used to tick which individual categories are included, with All and None options

When additional category columns are added to the Categories list, the Level 2 category column will be nested below the Level 1 category column in the table of statistics.

A second category column added as Level 2, its values nested beneath each Level 1 category in the table

To reorder the levels for the category columns, it is necessary to delete and re-add the category columns in the preferred order.

Select from the Numeric items available for the table.

Ticking numeric items in the settings panel adds a row for each one under every category in the table

Once Numeric items have been selected, a complete table of statistics will be available:

A complete table of statistics, with count, length, mean, standard deviation, coefficient of variation and variance for each numeric item within each nested category

Change the columns displayed in the table by clicking on the Edit table columns button ():

The Edit Columns window, with an eye button beside each column to show or hide it in the table of statistics

Group by category and Group by numeric item provide further options for the table organisation. Here the Group by category option has been selected, resulting in the numeric rows appearing for each category:

With Group by category selected, the numeric rows appear beneath each category in the table

When Group by numeric item is selected, category rows appear for each numeric data column:

With Group by numeric item selected, the category rows appear beneath each numeric data column in the table

You can also hide empty categories (those with a count of zero) and inactive rows:

The Hide empty categories and Hide inactive rows checkboxes in the Display section

The arrow buttons quickly expand () or collapse () rows.

Saving a Table of Statistics

Click the Save button () to add the table of statistics to the Saved Statistics folder.

This will create a copy of the table of statistics with a default name. You can then modify the name of the table so you can more easily find it in the Saved Statistics folder. You can also switch back to the original table of statistics and make further changes, then save additional versions of the table to the Saved Statistics folder.

Clicking Save creates a copy of the table of statistics in the Saved Statistics folder and switches to displaying the saved copy

Once saved to the Saved Statistics folder, subsequent changes to the table are automatically saved.

Exporting a Table of Statistics

Tables of statistics can be exported as CSV files. Click the Export button (), then specify a filename.

Alternatively, click rows to select them, and select multiple rows by holding down the Shift or Ctrl key while clicking rows. You can then copy rows of data to the clipboard by clicking the Copy button (), then selecting Copy Selected Rows. There is also a Select All option available. Once a selection has been copied to the clipboard, you can then paste the data into another application.