Frequency Table Tool Icon

Frequency Table Tool

Version:
Current
Last modified: May 21, 2020

Use the Frequency Table tool to help you understand the contents of your data. For each field you select, a frequency table is produced. The frequency table is a summary of your data with frequency counts and percentages for each value in a field.

Configure the Tool

Select the fields to produce a frequency analysis for: Select the fields (columns) that you want to produce a frequency analysis for. Use the All or None links to make bulk selections.

Double, 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 these 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 these 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 is 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 tries 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 dropdown options.
Was This Helpful?

Running into problems or issues with your Alteryx product? Visit the Alteryx Community or contact support.