Frequency Table Tool
The 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.
Configure the tool
Select the fields to produce a frequency analysis for:
FixedDecimal, Date, Time, DateTime, Blob, and SpatialObj types are not supported.
View the output
The Frequency Table tool has three outputs.
D anchor: 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 anchor: 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 anchor: Interactive Output includes a chart where the viewer can customize what displays with a series of drop down options.