Statistics panel

Overview

Clicking any variable in the variable list of a table will launch that variable's statistics panel. This shows some common summary statistics calculated upon the variable's data.

Note that in order to view this panel, you will need metadata access to the corresponding table.

Statistics

Count

The total number of values for this variable in the table. Does not include any null values.

Distinct

The number of unique values in the table. Does not include null as a value. (For example, a variable with values 0, 1, and null will have a distinct of 2.)

Non-null

The percentage of values in the table which are not null. Calculated by dividing the Count by the total number of records in the table.

Stats

For continuous variables (int, float, date, dateTime, time): the minimum, maximum, mean and standard deviation for this variable.

For string variables: the minimum and maximum length of all values.

Histogram

A visual display of values sorted into buckets from low to high. To switch between linear and logarithmic scales, click on the bottom left corner of the chart.

Only shown for continuous variables with a meaningful number of discrete values.

Box plot

A visual display of the distribution of values by frequency. Shown are the minimum, 25%, median, 75% and maximum value.

To include or exclude outliers in the calculations, click on the label on the bottom left corner of the chart.

Only shown for continuous variables with a meaningful number of discrete values.

Frequency table

A table showing the frequency of common values for that variable, limited to 10,000 values. If a variable's values are highly heterogenous, no frequency table will be displayed.

Comparing variables

Often it is useful to compare variables within a table and / or across tables in a project. You can compare variables by clicking the Compare icon in the top right corner.

Click on the variable name to switch it to a different variable in this table. Or click on the table name when looking at a table in a project to choose a different table's variables to compare to.