Frequency Table Tool

The Frequency Table tool helps the user understand the contents of their data. For each field selected by the user, a frequency table is produced. The frequency table is a summary of their data with frequency counts and percentages for each value in a field.

The tool has two outputs: a data output and a report output. The report also provides a warning to the user about using numeric data types for categorical fields.

Configuration Properties

Select the fields to produce a frequency analysis for: Certain field types cannot be selected. These include: FixedDecimal, Date, Time, DateTime, Blob, and SpatialObj.

Outputs

D Output: Data Output includes the following fields:

Name Description
Field_Name Original field name of the input data.
Field_Value Populated data value for the Field Name.
Frequency Count of times the value is present in the input data for the given Field Name.
Percent (Frequency/Total Records)*100
Cumulative Frequency The running total of the Frequency for each value for a given Field Name.
Cumulative Percent (Running Total Frequency/Total Records)*100

R Output: Report Output includes a frequency table for each field selected. The header for the table is the field name and the table includes the following fields:

Name Description
Value Populated data value for the Field Name.
Frequency Count of times the value is present in the input data for the given Field Name.
Percent (Frequency/Total Records)*100
Cumulative Frequency The running total of the Frequency for each value for a given Field Name.
Cumulative Percent (Running Total Frequency/Total Records)*100

If the field has ten or less unique values and is set as a numeric data type then a warning will be displayed underneath the frequency table. “This field has a small number of unique values, and appears to be categorical. Consider changing the field data type to "string" if you intend to use it as a categorical field later in your processing.” The warning is to try to help users that will want to use these fields as categorical fields within R.

I Output: Interactive Output includes a chart where the viewer can customize what displays with a series of drop down options.