---
schema_version: "1"
id: 5c7f9e8aadaef89b9496d11db2bfbcebb8bf0cb02aa1703340825e9df6b9d545
title: Groups and Aggregates
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/ind/264-0-0/dpe_group_aggregate.md
canonical_url: https://help.salesforce.com/s/articleView?id=ind.dpe_group_aggregate.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 2bad85e166d038046ced2d0d38ea0b05d22acf5d84dab903e0a45e41f1e628c6
description: Use the group and aggregate node to group records by field, and aggregate the data from one or more fields.
products:
  - Cross Cloud
release: "264"
---
# Groups and Aggregates

Use the group and aggregate node to group records by field, and aggregate the data from one or more fields.

### Required Editions

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small edition"><colgroup><col></colgroup><tbody><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;"><a href="https://help.salesforce.com/s/articleView?id=ind.dpe_editions.htm&amp;release=264.0.0&amp;type=5" title="Review the supported editions and availability for Data Processing Engine (DPE).">View supported editions</a>.</td></tr></tbody></table>

You can group a dataset by multiple fields and aggregate multiple fields. You can only group a dataset by fields of the type Text, Date, and Date/Time.

![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-ind-data_processing_engine-264-0-0-production-enus/80e06924-e6c0-4b82-81cf-e99ccd77d857/images/icon_note.png)

Note The number of fields you can use for aggregation is calculated by adding the fields in the source node and the fields used for aggregation.

Aggregate your data using the following functions:

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small ">
      <colgroup>
        <col style="width:33.33333333333333%">
        <col style="width:33.33333333333333%">
        <col style="width:33.33333333333333%">
      </colgroup>
      <thead class="slds-text-title_caps ">
        <tr class="">
          <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d6101e69">Function</th>
          <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d6101e72">Supported Data Types</th>
          <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d6101e75">Description</th>
        </tr>
      </thead>
      <tbody>
        <tr class="">
          <td data-label="Function" class="slds-cell-wrap" style="vertical-align:top;" headers="d6101e69 ">Unique</td>

          <td data-label="Supported Data Types" class="slds-cell-wrap" style="vertical-align:top;" headers="d6101e72 ">
            <ul>
              <li>Text</li>

              <li>Date</li>

              <li>Date/Time</li>

            </ul>
          </td>

          <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d6101e75 ">Returns the count of unique values.</td>

        </tr>
        <tr class="">
          <td data-label="Function" class="slds-cell-wrap" style="vertical-align:top;" headers="d6101e69 ">Count</td>

          <td data-label="Supported Data Types" class="slds-cell-wrap" style="vertical-align:top;" headers="d6101e72 ">
            <ul>
              <li>Number</li>

              <li>Text</li>

            </ul>
          </td>

          <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d6101e75 ">Returns the number of rows.</td>

        </tr>
        <tr class="">
          <td data-label="Function" class="slds-cell-wrap" style="vertical-align:top;" headers="d6101e69 ">Sum</td>

          <td data-label="Supported Data Types" class="slds-cell-wrap" style="vertical-align:top;" headers="d6101e72 ">Number</td>

          <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d6101e75 ">Returns the sum of the field selected for aggregation.</td>

        </tr>
        <tr class="">
          <td data-label="Function" class="slds-cell-wrap" style="vertical-align:top;" headers="d6101e69 ">Minimum</td>

          <td data-label="Supported Data Types" class="slds-cell-wrap" style="vertical-align:top;" headers="d6101e72 ">Number</td>

          <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d6101e75 ">Returns the minimum value of the field selected for aggregation.</td>

        </tr>
        <tr class="">
          <td data-label="Function" class="slds-cell-wrap" style="vertical-align:top;" headers="d6101e69 ">Maximum</td>

          <td data-label="Supported Data Types" class="slds-cell-wrap" style="vertical-align:top;" headers="d6101e72 ">Number</td>

          <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d6101e75 ">Returns the maximum value of the field selected for aggregation.</td>

        </tr>
        <tr class="">
          <td data-label="Function" class="slds-cell-wrap" style="vertical-align:top;" headers="d6101e69 ">Average</td>

          <td data-label="Supported Data Types" class="slds-cell-wrap" style="vertical-align:top;" headers="d6101e72 ">Number</td>

          <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d6101e75 ">Returns the arithmetic mean for the field selected for aggregation.</td>

        </tr>
        <tr class="">
          <td data-label="Function" class="slds-cell-wrap" style="vertical-align:top;" headers="d6101e69 ">Standard Deviation</td>

          <td data-label="Supported Data Types" class="slds-cell-wrap" style="vertical-align:top;" headers="d6101e72 ">Number</td>

          <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d6101e75 ">Returns the sample standard deviation computed on the field selected for
            aggregation.</td>

        </tr>
        <tr class="">
          <td data-label="Function" class="slds-cell-wrap" style="vertical-align:top;" headers="d6101e69 ">Standard Deviation Population</td>

          <td data-label="Supported Data Types" class="slds-cell-wrap" style="vertical-align:top;" headers="d6101e72 ">Number</td>

          <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d6101e75 ">Returns the population standard deviation computed on the field selected for
            aggregation.</td>

        </tr>
        <tr class="">
          <td data-label="Function" class="slds-cell-wrap" style="vertical-align:top;" headers="d6101e69 ">Variance</td>

          <td data-label="Supported Data Types" class="slds-cell-wrap" style="vertical-align:top;" headers="d6101e72 ">Number</td>

          <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d6101e75 ">Returns the sample variance (unbiased variance) computed on the field selected
            for aggregation.</td>

        </tr>
        <tr class="">
          <td data-label="Function" class="slds-cell-wrap" style="vertical-align:top;" headers="d6101e69 ">Variance Population</td>

          <td data-label="Supported Data Types" class="slds-cell-wrap" style="vertical-align:top;" headers="d6101e72 ">Number</td>

          <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d6101e75 ">Returns the population variance (biased variance) computed on the field selected
            for aggregation.</td>

        </tr>
      </tbody>
    </table>

After you create your group and aggregate node, you can view the fields that are created based on the node.

![Aggregate node](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-ind-data_processing_engine-264-0-0-production-enus/80e06924-e6c0-4b82-81cf-e99ccd77d857/data_processing_engine/images/data_processing_engine_aggregate.png)

![Example](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-ind-data_processing_engine-264-0-0-production-enus/80e06924-e6c0-4b82-81cf-e99ccd77d857/images/icon_example.png)

Example You can group opportunities by Campaign field and find the sum of the amount by defining an aggregate.