Summary

<< Click to Display Table of Contents >>

Navigation:  Reference > Transforms >

Summary

Description

Summarise the values in the selected columns.

 

Inputs

One.

 

Options

Select the Columns you wish to summarise.

Check check for dates if you wish to check for date values using supported date formats. This can be slow for large datasets.

 

Notes

Empty values is the number of values in the column that are completely empty. Values with whitespace do not count as empty.

Numeric values is the number of numeric of values in the column that can be interpreted as a number.

Date values is the number of values in the column that can be interpreted as a date. Only shown if check for dates is checked.

Text values is the number of values in the column that cannot be interpreted as empty, numeric or date.

Unique values is the number of unique values in the column. Empty values are not counted. Date and numeric values are treated as text (e.g. '7' is treated as different to '7.0' and '1/1/2020' is treated as different to '01/01/2020'). Comparison between values is sensitive to case and whitespace.

Min length is the minimum number of characters of a value in the column. Whitespace is counted. Date and numeric values are treated as text.

Max length is the maximum number of characters of a value in the column. Whitespace is counted. Date and numeric values are treated as text.

Min numeric is the minimum numeric value in the column.

Max numeric is the maximum numeric value in the column.

Min date is the minimum date value in the column. Only shown if check for dates is checked.

Max date is the maximum date value in the column. Only shown if check for dates is checked.

Most frequent lists the most common text in the column. Empty values are not counted. Date and numeric values are treated as text. Comparison between values is sensitive to case and whitespace.

You can use Trim to remove any whitespace at the start or end of values before Summary.

If you wish to have a row displayed per column you can Transpose the table.

 

See also

Count

Pivot

Stats