Loading
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
            Working with Nodes in Visual Insight Builder

            You are here:

            1. Salesforce Help
            2. Docs
            3. Data 360

            Working with Nodes in Visual Insight Builder

            Visual Insight Builder uses a low-code, drag-and-drop interface to simplify the creation of streaming, calculated, and real-time insights. Visual components replace complex code, allowing you to develop metrics and expressions, regardless of technical expertise.

            Supported Nodes for Visual Insight Builder

            Nodes are the key components of a workflow, enabling the execution of a series of operations by connecting nodes with different functionalities.

            Node Function Calculated Insights Streaming Insights Real Time Insights
            Using the Join Node Left Join Yes Yes No
            Right Join Yes Yes No
            Inner Yes Yes No
            Full Yes Yes No
            Using the Aggregate Node Count Yes Yes Yes
            Sum Yes Yes Yes
            Average Yes No No
            Maximum Yes No No
            Minimum Yes No No

            Lead

            		 Yes No No
            Lag Yes No No
            Rank Yes No No
            Dense Rank Yes No No
            Percent Rank Yes No No
            Approximate Count Distinct Yes No No
            First Value Yes No No
            Last Value Yes No No
            Row Number Yes No No
            NTile Yes No No
            Using the Case Node equal Yes No No
            not Yes No No
            is null Yes No No
            is not null Yes No No
            less than Yes No No
            less than or equal to Yes No No
            greater than Yes No No
            greater than or equal to Yes No No
            is empty Yes No No

            contains

            		 Yes No No
            does not contain Yes No No
            contains regular expression Yes No No
            does not contain regular expression Yes No No
            Using the Filter Node equal Yes Yes Yes
            not Yes Yes Yes
            is null Yes Yes Yes
            is not null Yes Yes Yes
            less than Yes Yes Yes
            less than or equal to Yes Yes Yes
            greater than Yes Yes Yes
            greater than or equal to Yes Yes Yes
            is empty Yes Yes Yes
            contains Yes Yes Yes
            does not contain Yes Yes Yes
            contains regular expression Yes Yes Yes
            does not contain regular expression Yes Yes Yes
            Relative DateTime Yes No Yes
            Using the Transform Node Absolute Value Yes No No
            Mod Yes No No
            Random Yes No No
            Round Yes No No
            Regular Expression Yes No No
            Regular Expression Extract Yes No No
            egular Expression Replace Yes No No
            Right Trim Yes No No
            Substring Yes No No
            Lowercase Yes No No
            Uppercase Yes No No
            Hour Yes No No
            Day Yes No No
            Month Yes No No
            Quarter Yes No No
            Year Yes No No
            CDP Hour Yes No No
            CDP Day Yes No No
            CDP Month Yes No No
            CDP Quarter Yes No No
            CDP Year Yes No No
            Day of Week Yes No No
            Day of Month Yes No No
            Day of Year Yes No No
            Current Date Yes No No
            Date Addition Yes No No
            Date Subtraction Yes No No
            Date Difference Yes No No
            Date Truncation Yes No No
            To Date Yes No No
            To Timestamp Yes No No
            • Using the Join Node
              The Join node combines data from multiple sources based on shared values. A column represents a category of information, such as an opportunity source or account name.
            • 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.
            • Using the Case Node
              The case node, similar to the CASE statement in SQL, analyzes data by comparing the attributes of conditions. The WHEN/THEN statements determine the outcome based on whether all or any of the specified conditions are true. If none of the WHEN conditions are met, the ELSE statement provides an alternative action. The Case node statement must be followed by at least one WHEN/THEN pair, which applies a designated function when the associated condition is true.
            • Using the Filter Node
              The filter node uses the selected operator and value to keep or remove data based on whether any or all of the specified conditions are met.
            • Using the Transform Node
              Use a Transform node to manipulate data based on the transformations added to the node. To manipulate data at multiple stages of a data transform, add a separate Transform node at each stage.
             
            Loading
            Salesforce Help | Article