You are here:
Aggregation and Total Aggregation Functions
An aggregation function computes numerical calculations on data, allowing the query to return summarized information about a given column or result set. You can use an aggregation function to calculate each row at the dimension level or the total value. In Marketing Cloud Intelligence, you define the aggregation function when creating a calculated measurement.
For example, to perform a different calculation per row, such as getting the average value for each dimension while summing all the values in the total row, set the aggregation function to AVG and the total aggregation function to SUM to sum the values in the different rows.
Use Case
You can use both the aggregated function and the total aggregation function in cases where you have a calculated measurement with a formula that includes a dimension with an aggregation function set to Auto, and the total value in the query for this calculated measurement is zero. The reason there’s no total value is because the total row doesn’t include the formulas’ required dimension for this calculated measurement. To solve this issue and display a total value, you can set a total aggregation function to display a total value based on the value of each row in the query.
