Add a new chart to a dashboard, or click Explore from the top navigation. Click Advanced to toggle to the Advanced Data Pipeline.
You’ll see an empty Database Query node and a Chart node on your canvas. Click the pencil icon on the Database Query node to edit its query.
Use Interactive Mode or SQL Mode to build your query as you normally would. Click Done when finished.
Add a second Database Query node to the canvas by clicking Database Query in the left sidebar, and dragging it onto the canvas. Edit its query and click Done.
Drag a Merge Step node onto the canvas, and drop it on the line connecting the Database Query node to the Chart node. The connecting line will appear dotted to signify the Merge Step node will connect between the two nodes.
To connect the second Database Query node to the Merge Step, click the square on the bottom middle of the node—the node’s output connector—and then click anywhere on the Merge Step node.
To run your queries and update your pipeline, click the Run Pipeline button.
Next, drag any Transformation Step node to the canvas, and hover over the line between the Merge step and the Chart node. Drop the Transformation Step node there, and edit as needed.
Click Run Pipeline to update your chart.