Statistics panel

Clicking any variable in a table (in variables or cells view) will display that variable's statistics panel. This shows some common summary statistics calculated upon the variable's data.

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

You can compare any variables in this table by holding the command key (or control key on windows) and clicking on two variables.