-
Frequency Table Tool
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 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.