Frequency Table Tool

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.

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.

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

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.