Field functions

Most frequent values

Computes the most frequently occurring values for a field.

Maximum number of output

Most frequent values

Number of records by value

Least frequent values

Computes the least frequently occurring values for a field.

Maximum number of output

Least frequent values

Number of records by value

Null count

Computes the number of null values for a field.

N/A

Number of null values

Not null count

Computes the number of not null values for a field.

N/A

Number of not null values

Distinct count

Computes the number of different values that occur.

N/A

Number of distinct values

Unique count

Computes the number of values that occur only once.

N/A

Number of unique values

Not unique count

Computes the number of values which occur more than once.

N/A

Number of not unique values

Maximum length

Returns the length of the longest field value.

Count white spaces as 1 size

Length of the longest field value

Minimum length

Returns the length of the shortest field value.

Count white spaces as 1 size

Length of the shortest field value

Average length

Computes the average length of a field value: Sum of length of all distinct values of a field divided by the number of distinct values.

Count white spaces as 1 size

Average length of a fields values

Highest value

Returns the highest value from a given field. It returns 'NULL' if all values are null.

N/A

Highest field value

Lowest value

Returns the lowest value from a given field. It returns 'NULL' if all values are null.

N/A

Lowest field value

Average of values

Computes the sum of all field values divided by the number of non-null values. It returns 'NULL' if all values are null.

N/A

Field value average

Field length statistics

Computes the highest, lowest, and average field lengths.

Count white spaces as 1 size

Min length

Max length

Average length

Median of a field's values

Computes the median of a numeric series. It returns the value which divides all the values sorted in 2 sub lists of the same size. If the number of values is odd, the result is the middle value of the list of all the sorted values. If the number of values is even, the result is the mean of the two values in the middle of the list of all the sorted values. If all values are null, result is 'NULL'.

N/A

Median of a field's values

Range of a field's values

Computes the difference between the highest value and the lowest value of a numeric series.

N/A

Range of a field's values

Field completeness rate

Computes the completeness rate of an asset (the percentage of fulfillment of a field against all records in the table).

N/A

Field completeness rate

Patterns

Identifies and displays the most common formats. "L" is a letter and "D" is a digit.

N/A

Format value

Count

Number value distribution

Reports all the distinct number values in the selected column and number of rows (number of counts) in the table that each value represents.

Maximum number of output

Distinct number values

Number of counts by number value

String length distribution

Reports all the distinct lengths of string values in the selected column and the number of rows in the table that each length represents.

Maximum number of output

Distinct string length values

Number of counts by string length value

Duplicate count

Computes the number of duplicate value for a field. A duplicate value is a value that is repeated in the column.

N/A

Number of duplicate values