◄Show Table of Contents

Field Summary Tool

The Field Summary tool analyzes data and creates a summary report containing descriptive statistics of data in selected columns.

Use the Field Summary Tool to gain insight into data and receive recommendations for managing data.

Numeric, string, spatial, and date/time are supported in this tool. A unique set of descriptive statistics are provided for each data type. See Data Types, for more on types of data.

ClosedConfigure the tool

Select all, some, or a random sample of columns to include in the output.

Columns containing data that is not supported in this tool (for example, boolean data) can be selected during tool configuration; however, the column will be not analyzed or included in the tool output.

ClosedView results

The Field Summary tool has three outputs:

The descriptive statistics available in the output depend on the type of data in the columns selected for analysis. Results are listed horizontally. Scroll left to right to see statistics for each data type.

ClosedNumeric data

If a column contains numeric data, the following statistics are provided:

  • Min: The minimum value in the data.
  • Max: The maximum value in the data.
  • Median: The median value in the data.
  • Std. Dev.: The measure of how dispersed the values are in the data.
  • Percent Missing: The percentage of values in the data that are null.
  • Unique Values: The number of unique values in the data.
  • Mean: The average of the data.
  • Layout: Add a Browse tool and connect it to the R output to view the statistics in a visual format. See Browse Tool.
  • Remarks: Recommendations for managing data, if available.
ClosedString data

If a column contains string data, the following statistics are provided:

  • Percent Missing: The percentage of values in the data that are null.
  • Unique Values: The number of unique values in the data.
  • Shortest Value: The short (length) string value in the data.
  • Longest Value: The longest (length) string value in the data.
  • Min Value Count: The number of values that equal the minimum value.
  • Max Value Count: The number of values that equal the maximum value.
  • Remarks: Recommendations for managing data, if available.
ClosedSpatial data

If a column contains spatial data, the following statistics are provided:

  • Percent Missing: The percentage of values in the data that are null.
  • Object Type: The type of spatial object (for example, Point or Polygon) in the data.
  • Avg Area (Sq Miles): The average area, in square miles, of the values in the data.
  • Avg Length (Miles): The average length, in miles, of the values in the data.
  • Avg Num Points: The average number of values in the data that are Points.
  • Remarks: Recommendations for managing data, if available.
ClosedDate/Time data

If a column contains date/time data, the following statistics are provided:

  • Percent Missing: The percentage of values in the data that are null.
  • Unique Values: The number of unique values in the data.
  • Latest Date: The latest, or most future, date in the data.
  • Earliest Date: The earliest date in the data.
  • Interval: The interval of dates (for example, Monthly) in the data.
  • Remarks: Recommendations for managing data, if available.

Alteryx.com | Community | Customer Support | Documentation Feedback

©2018 Alteryx, Inc., all rights reserved. Allocate®, Alteryx®, Guzzler®, and Solocast® are registered trademarks of Alteryx, Inc.