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.