Marketing Intelligence Aggregate Functions

Aggregate Functions in calculated fields perform a calculation based on groups of rows, rather than on a single row. For example, it doesn't make sense to use Sum or Average on a single value; instead, you want to take the sum or average over a row or column group, or over the total set. In many cases, aggregate functions in the Ad Hoc Editor are analogous to SQL functions that can be used with the GROUP BY clause in a SELECT statement.

The Aggregate Functions are as follows:

• Average

• CountAll

• CountDistinct

• Custom (Note: This option is displayed only if you've defined a custom summary calculation for calculated field or measure.)

• Max

• Median

• Min

• Mode

• PercentOf

• Range  

• StdDevP

• StdDevS

• Sum

• WeightedAverage (Note: This option is displayed only if you've created a WeightedAverage summary calculation for a field or measure.)

 Because Aggregate Functions already operate on groups, their use is restricted in the following ways:

• You can use Aggregate Functions only in calculated measures; aggregates should not be used to create regular, non-measure fields.

• You can't add an Aggregate Function to a group.

• You should not use an Aggregate Function as a filter.

• Only AggregateFormula, Custom, or None are supported as summary calculations for aggregate functions.

 Copyright © Marigold    Marigold Engage+ Online Help v24.8.0  August 2024