Skip to main content

Frequency Table Tool Icon Frequency Table Tool

One Tool Example

Frequency Table has a One Tool Example. Go to Sample Workflows to learn how to access this and many other examples directly in Alteryx Designer.

Use Frequency Table 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 3 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 10 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.

In this section: