âShow Table of Contents
The following list describes the types of summarize functions that the Summarize Tool can perform.
Group by: Combines database records with identical values in a specified field into a single record. All of the resulting data from the records in a group are then summarized. (Any non-blob or spatial object has this option.) If no Group by field is specified, the entire file will be summarized.
Sum: Returns the sum value for the group. The sum is calculated by adding all of the values of a group.
Count: Count of records in the group.
Count Non Null: Identical to Count, except it is only counting those records that are NOT null. Null means there is no value set for this record. This is different than a zero or an empty string.
Count Distinct: Count of unique records in the group.
Count Distinct Non Null: Identical to Count Distinct, except it is only counting those records that are NOT null. Null means there is no value set for this record (different than a zero or an empty string)
Min: Returns minimum value.
Max: Returns the maximum value.
First: Returns the first record in the group, based upon its record position.
Last: Returns the last record in the group, based upon its record position.
The following are additional Summary Processes split into categories relevant to the type of field chosen for summarization.
Net Present Value: Calculates the Net Present Value for a group. Measures the excess or shortfall of cash flows, in present value terms, once financing charges are met.
NPV Properties: Specify the Discount Rate (per period) in %
Net Present Value with Dates: Calculates the Net Present Value for a group for a series of dates.
XNPV Properties: Specify the Finance Rate in % and select the Date Field from the drop down list of available fields.
Internal Rate of Return: Calculates the Internal Rate of Return for a group. The Internal Rate of Return of an investment is the interest rate at which the costs of the investment lead to the benefits of the investment. This means that all gains from the investment are inherent to the time value of money and that the investment has a zero net present value at this interest rate.
Internal Rate of return with dates: Calculates the Internal Rate of Return for a group for a series of dates.
XIRR Properties: Select the Date field from the drop down list of available fields.
Modified Internal Rate of Return: A modification of the internal rate of return and as such aims to resolve some problems with the IRR. The MIRR is a financial measure of an investment's attractiveness.
MIRR Properties: Specify the Finance Rate in % and specify the Reinvest Rate in %
Modified Internal Rate of Return with Dates: Calculates the Modified Internal Rate of Return for a group for a series of dates.
MXIRR Properties: Specify the Finance Rate in %, the Reinvest Rate in % and select the Date field from the drop down list of available fields.
*Finance definitions came from Wikipedia: http://en.wikipedia.org
Percentile: Calculates the specified percentile value for the group. The percentile is calculated by sorting the data and returning the row value relative to the specified percentile and its position in the sorted array - the largest value is the 100th percentile, lowest value is the 0 percentile, median is the 50th percentile, the 25th percentile is the value in the middle of the median and minimum, etc.
Specify the percentile to return.
Median: Calculates the median value for a group. The median of the group is "the number in the middle" when the values are sorted in order. If there is an even number of scores there is no number in the middle so the two numbers in the middle are averaged.
Mode: Calculates the mode value for a group. The mode of a set of numbers is the smallest number that occurs most often in a group of values. If all values are unique, the smallest number will be returned.
The mode of a string can also be calculated. The mode of a set of string values is the smallest string that occurs most often in a group of values. If all values are unique, the smallest string will be returned. The smallest string is the first in ascending sort order.
Variance: Calculates the Variance for the group. The variance is calculated by taking the Standard Deviation and multiplying it times itself, StdDev^2.
Ignore 0s: Calculates the Numeric processes described above ignoring records that have a value of zero.
Count Blank: Counts how many records in a group have a blank or empty value.
Count Non Blank: Counts how many records in a group do not have a blank or empty value.
Concatenate (Strings Only): Takes all the records in a group and concatenates the strings.
The start, separator and end elements must be specified for each field an action is being applied to.
Longest: Returns the longest string value of the group.
Shortest: Returns the shortest string value of the group.
Combine Spatial Objects: Combines the area of all the spatial objects in a group.
Create Intersection of Spatial Objects: Identifies all of the overlapping areas of a group's spatial objects and creates a polygon that consists only of that overlap. This means that if the group being summarized contains two polygons that overlap and one that does not, nothing will be returned.
Create Bounding Rectangle of Spatial Objects: Identifies the geographic extent of all spatial objects in a group and draws a bounding rectangle to those extents.
Create Convex Hull of Spatial Objects: The Convex Hull polygon is the smallest convex polygon that can be drawn to include a group of points. The polygon will not contain any concave angles, so it will never turn in on itself.
Create Centroid of Spatial Objects: Identifies the geographic center of a group of spatial objects
Combine Profiles: Combines all the Profiles in a group into a single Profile per group specified.
Combine Horizontal: Combines all the Report Snippets in a group into a single snippet for the group laid out horizontally.
Combine Vertical: Combines all the Report Snippets in a group into a single snippet for the group laid out vertically.
Â©2017 Alteryx, Inc., all rights reserved. AllocateÂ®, AlteryxÂ®, GuzzlerÂ®, and SolocastÂ® are registered trademarks of Alteryx, Inc.