Skip to main content

Frequency Table Tool Icon Frequency Table Tool

User Role Requirements

User Role*

Tool/Feature Access

Full User

Basic User

X

*Applies to Alteryx One Professional and Enterprise Edition customers on Designer versions 2025.1+.

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.

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.

Configure the Tool

Select the fields to produce a frequency table 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.