Frequency Table Tool Icon

Frequency Table Tool

Version:
Current
Last modified: October 21, 2019

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.

Tool Configuration

Configure the tool

Select the fields to produce a frequency analysis for:

FixedDecimal, Date, Time, DateTime, Blob, and SpatialObj types are not supported.

View the output

The Frequency Table tool has three outputs.

D anchor: 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 anchor: 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 anchor: Interactive Output includes a chart where the viewer can customize what displays with a series of drop down options.

Was This Helpful?

Need something else? Visit the Alteryx Community or contact support.