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
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.