Loading
Feature Degradation | Agentforce Voice Read More
About Salesforce Data 360
Table of Contents
Filter by (0)Add
Select Filters

          No results
          No results
          Here are some search tips

          Check the spelling of your keywords.
          Use more general search terms.
          Select fewer filters to broaden your search.

            Search all of Salesforce Help
            Search all of Salesforce Help
            Using the Aggregate Node

            You are here:

            1. Salesforce Help
            2. Docs
            3. Data 360

            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
            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.
             
            Loading
            Salesforce Help | Article