Aggregation type

Select the aggregation type to use to derive the value of this calculation variable. Your choices are: • Sum: The total value is calculated for the selected items. • Average: The average value is calculated for the selected items. • Median: The median value is calculated for the selected items. • Maximum: The largest value is calculated for the selected items. • Minimum: The minimum value is calculated for the selected items. • Array: A list of values is provided. You can also specify a maximum value for this list. • First: The first value is selected from the list. • Last: The last value is selected from the list. Note: If Array, First, or Last is selected, you must select the join path that relates to an asset, the attribute to use to order the selected items, and a sort direction.

	See Also

Attribute to use for ordering

Select the attribute to use for ordering. The list is based on attributes of the chosen relationship.

	See Also

Sort direction

Select the sorting direction. You can choose either ascending or descending order.

	See Also