---
title: Aggregation Custom Value
slug: segment/aggregation-custom-value
docTags: 
createdAt: 2026-01-15T19:59:30.409Z
---

:::hint{type="info"}
This feature is available on **Unaric Segment Plus** and **Advanced**.
:::

The Aggregation Custom Value allows you to aggregate multiple values of a Data Extension/Data View that include:

- *Sum* also known as *SUM* in SQL
- *Average* also known as *AVG* in SQL
- *Count* also known as *COUNT* in SQL
- *Minimum* also known as *MIN* in SQL
- *Maximum* also known as *MAX* in SQL

Aggregation is supported in two modes:

- **Basic Mode**: You can use the Basic aggregation when you have a Predefined Relation between Data Extensions. See [Predefined Relations](docId\:w-iSbNRig2oxoNNhkygDl).
- **Advanced Mode**: You need to use Advanced Aggregation when you don’t have a Predefined Relation? See [Advanced Mode of Aggregation Custom Values](docId\:XVrdl43j0jO9Oba1gKQ0H).

## Video overview

::embed[]{url="https://vimeo.com/766456419?fl=pl&fe=cm"}

## Create an Aggregation Custom Value

1. Under **Custom Values**, click the **Add new value** button.

::Image[]{src="https://support.deselect.com/hc/article_attachments/29397424300689" size="50" width="644" height="630" isUploading="false" darkWidth="644" darkHeight="630" showCaption="false"}

2. Provide a name for the Custom Value, select *Aggregation* as **Type**, and click **Next.**
3. Under **Aggregation**, choose the type of aggregation you want to use.

::Image[]{src="https://support.deselect.com/hc/article_attachments/29397401409809" size="50" width="1304" height="1340" isUploading="false" darkWidth="1304" darkHeight="1340" showCaption="false"}

4. On **Field**, select the field that you want to aggregate on.

::Image[]{src="https://support.deselect.com/hc/article_attachments/29397401410961" size="50" width="1322" height="1344" isUploading="false" darkWidth="1322" darkHeight="1344" showCaption="false"}

5. If you have additional filters on this specific aggregation, click **Edit Filters**. A modal will pop up where you can create the conditions that you want to apply.
6. Save and drag-and-drop the new Custom Value to the Target Data Extension fields.