--- schema_version: "1" id: 22617f508a49886d89a9f980e722e5cd55e729f0cc8c6a72b72e33ba3e925f97 title: Working with Nodes in Visual Insight Builder collection: admin version: current locale: en-us portal_url: https://docs.salesforce.com/admin/current/en-us/data/264-0-0/c360_a_working_with_nodes_in_builder.md canonical_url: https://help.salesforce.com/s/articleView?id=data.c360_a_working_with_nodes_in_builder.htm&release=264.0.0&type=5 source_site: help.salesforce.com content_type: documentation content_hash: 9d98bb948e3227f47b305bde6c7a5f9d2012c0a952b70abe4d9be6090d982993 description: 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. products: - Data 360 release: "264" --- # 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 Yes
Minimum Yes No Yes

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 Yes
not Yes No Yes
is null Yes No Yes
is not null Yes No Yes
less than Yes No Yes
less than or equal to Yes No Yes
greater than Yes No Yes
greater than or equal to Yes No Yes
is empty Yes No Yes

contains

 Yes No Yes
does not contain Yes No Yes
contains regular expression Yes No Yes
does not contain regular expression Yes No Yes
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
Null If Yes No Yes
Right Trim Yes No Yes
Left Trim Yes No Yes
Trim Yes No Yes
Substring Yes No No
Lowercase Yes No Yes
Uppercase Yes No Yes
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](https://help.salesforce.com/s/articleView?id=data.c360_a_using_the_join_node.htm&release=264.0.0&type=5)** 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](https://help.salesforce.com/s/articleView?id=data.c360_a_using_the_aggregate_node.htm&release=264.0.0&type=5)** 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](https://help.salesforce.com/s/articleView?id=data.c360_a_using_the_case_node.htm&release=264.0.0&type=5)** 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](https://help.salesforce.com/s/articleView?id=data.c360_a_using_the_filter_node.htm&release=264.0.0&type=5)** 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](https://help.salesforce.com/s/articleView?id=data.c360_a_using_the_transform_node.htm&release=264.0.0&type=5)** 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.