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 |