Frequency Table ToolFrequency Table ToolThe Frequency Table tool helps the user understand the contents of their data. For each field selected by the user, a frequency table is produced. The frequency table is a summary of their data with frequency counts and percentages for each value in a field.
The tool has two outputs: a data output and a report output. The report also provides a warning to the user about using numeric data types for categorical fields.
Select the fields to produce a frequency analysis for: Certain field types cannot be selected. These include: FixedDecimal, Date, Time, DateTime, Blob, and SpatialObj.
D: Data Output includes the following 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: Report Output includes a frequency table for each field selected. The header for the table is the field name and the table includes the following 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 ten or less unique values and is set as a numeric data type then a warning will be 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 is to try to help users that will want to use these fields as categorical fields within R.
I: Interactive Output includes a chart where the viewer can customize what displays with a series of drop down options.
©2018 Alteryx, Inc., all rights reserved. Allocate®, Alteryx®, Guzzler®, and Solocast® are registered trademarks of Alteryx, Inc.