Skip to main content

[en] Frequency Table Tool Icon Frequency Table Tool

[en] One Tool Example

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

[en] 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.

[en] Configure the Tool

[en] 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.

[en] Double, FixedDecimal, Date, Time, DateTime, Blob, and SpatialObj types are not supported.

[en] View the Output

[en] The Frequency Table tool has 3 outputs.

  • [en] D anchor: Data Output includes these fields:

    [en] Name

    [en] Description

    [en] Field_Name

    [en] Original field name of the input data.

    [en] Field_Value

    [en] Populated data value for the Field Name.

    [en] Frequency

    [en] Count of times the value is present in the input data for the given Field Name.

    [en] Percent

    [en] (Frequency/Total Records)*100

    [en] Cumulative Frequency

    [en] The running total of the Frequency for each value for a given Field Name.

    [en] Cumulative Percent

    [en] (Running Total Frequency/Total Records)*100

  • [en] 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:

    [en] Name

    [en] Description

    [en] Value

    [en] Populated data value for the Field Name.

    [en] Frequency

    [en] Count of times the value is present in the input data for the given Field Name.

    [en] Percent

    [en] (Frequency/Total Records)*100

    [en] Cumulative Frequency

    [en] The running total of the Frequency for each value for a given Field Name.

    [en] Cumulative Percent

    [en] (Running Total Frequency/Total Records)*100

    [en] 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:

    [en] 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.

    [en] The warning tries to help users that will want to use these fields as categorical fields within R.

  • [en] I anchor: Interactive Output includes a chart where the viewer can customize what displays with a series of dropdown options.

: