Nodes are modules you drag onto the canvas to build your chart. Types of nodes include Database Query, Transformation Step, and Merge Step.

Connect nodes

Charts are built by first dragging one or more Database Query nodes onto the canvas, combining those nodes using one or more Merge Step nodes, and connecting the final node to the Chart node. Add Transformation Step nodes as needed to edit your dataset results.

Adding a node

To add a node to the canvas, click and drag it from the left sidebar onto the canvas.

Connecting nodes

To connect Node B to the result of Node A, click the output square of Node A and then hover anywhere on Node B. Node B will be highlighted in blue to show the connection is recognized. Then, click on Node B to complete the connection.

Nodes to which you can’t connect will be greyed out.

If a node is already connected to another node, its connector square will not be visible.

Connect nodes

Disconnecting nodes

To disconnect two nodes, hover over the line connecting the nodes and click the scissors icon.

Click scissors to disconnect nodes

Node types

Database Query node

Drag a Database Query node onto the canvas to add a dataset to your chart. Database Query nodes are equivalent to datasets in the Basic Chart Editor.

Database Query node in Advanced Mode

Edit a Database Query node

To edit a Database Query node, click the pencil icon on the node.

Clone a Database Query node

Click the square clone icon on the node to clone it.

Transformation Step node

To edit the data output of a node, drag a Transformation Node onto the canvas, hover over the output line of the node you want to edit, and drop it there. Transformation Step nodes are equivalent to Pipeline Steps in the Basic Chart Editor. For details on each Transformation step, see our Data Pipeline Steps documentation.

Transformation Step node

Merge Step node

Combine the results from two or more Database Query nodes by connecting their output to a Merge Step node. You may use as many Merge Nodes as you wish.

Advanced Preview Data

Click any node in the Pipeline to view its Input and Output data in the Preview Data drawer, below the canvas.

Preview Data

Run selected node

Click any node, then click Run Selected Node to run the pipeline up to that point and view its dataset in the Preview Data drawer. This can be especially useful for troubleshooting and testing a part of your pipeline separately.

Run selected Node