Calculate Metrics
Overview
Returns mean, median, range, max, min, sum, and collection size for a specific number field in a Record Collection.
Inputs
Records
The Record Collection that is used to calculate the metrics.
Type |
---|
Record Collection |
Field API Name
The API Name of the field on the object to use for metric calculation. This must be a number field.
Type |
---|
Text |
Outputs
Average
The average from the provided Record Collection and values from the Field API Name.
Type | Variable Name |
---|---|
Number | average |
Median
The median from the provided Record Collection and values from the Field API Name.
Type | Variable Name |
---|---|
Number | median |
Max
The max value from the provided Record Collection and values from the Field API Name.
Type | Variable Name |
---|---|
Number | max |
Min
The min value from the provided Record Collection and values from the Field API Name.
Type | Variable Name |
---|---|
Number | min |
Size
The size of the Record Collection.
Type | Variable Name |
---|---|
Number | size |
Sum
The sum from the provided Record Collection and values from the Field API Name.
Type | Variable Name |
---|---|
Number | sum |
Range
The range from the provided Record Collection and values from the Field API Name.
Type | Variable Name |
---|---|
Number | range |