--- schema_version: "1" id: 8b86a9414f2fb742a5d63ac5cf43cd248f20ae9861c06d0080b3b40cf1b663db title: Using the Aggregate Node collection: admin version: current locale: en-us portal_url: https://docs.salesforce.com/admin/current/en-us/data/264-0-0/c360_a_using_the_aggregate_node.md canonical_url: https://help.salesforce.com/s/articleView?id=data.c360_a_using_the_aggregate_node.htm&release=264.0.0&type=5 source_site: help.salesforce.com content_type: documentation content_hash: 97d25e3ba2ae958e0fbaeb140fa8b48ed9bce8f6f524752cb392b5586616b0f2 description: The aggregate node performs a calculation on a set of values and returns a single value. For example, Average returns the average value of a numerical column. You can use dimensions to roll up the records to a higher granularity. Dimensions, which are typically textual, categorize and describe data by supplying qualitative data points. They are commonly used to filter and segment data based on specific characteristics, such as customer ID, product type, location, or date. Dimensions provide context for measurements, which allows for analysis across different aspects of a dataset. products: - Data 360 release: "264" --- # Using the Aggregate Node The aggregate node performs a calculation on a set of values and returns a single value. For example, Average returns the average value of a numerical column. You can use dimensions to roll up the records to a higher granularity. Dimensions, which are typically textual, categorize and describe data by supplying qualitative data points. They are commonly used to filter and segment data based on specific characteristics, such as customer ID, product type, location, or date. Dimensions provide context for measurements, which allows for analysis across different aspects of a dataset. ![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-data-data_cloud-264-0-0-production-enus/f3569962-3c9b-4f83-9d0c-b6a574e785da/images/icon_note.png) Note For real-time insights, aggregate nodes must use fields with a real-time source. Otherwise, the result is blank.

Approximate Count Distinct	Calculates the relative rank of a row within a group of rows.
Average	Calculates the average of all the values in the selected field. Supports numerical values.
Count	Counts all values in the selected field. Supports date, text, and boolean measures.
Dense Rank	Returns the rank of each row within a result set partition, with no gaps in the ranking values.
First Value	Returns the first value from the unsorted data records. The results may change in a future insight processing job. For a consistent result use the Min or Max.
Last Value	Returns the first value from the unsorted data records. The results may change in a future insight processing job. For a consistent result use the Min or Max.
Lead	Returns the value from the preceding row.
Maximum	Calculates the maximum value of the selected field. Supports numerical values.
Minimum	Calculates the minimum value of the selected field. Supports numerical values.
NTile	Distributes the rows in an ordered partition into a specified number of groups. The groups are numbered, starting at one. For each row, NTILE returns the number of the group to which the row belongs.
Percent Rank	Calculates the relative rank of a row within a group of rows.
Rank	Returns the rank of each row within the partition of a result set. The rank of a row is one plus the number of ranks that come before the row in question.
Row Number	Returns the sequential number of a row within a partition of a result set.
Sum	Calculates the total by adding all values in the selected field. Supports numerical values.