Reusable Pipelines allow you to save a query and its Pipeline Steps to use as a Data Source in other charts. Chartio does not store the Pipeline data results; it saves the query or queries and its Pipeline Steps for reuse across charts.
Creating a Pipeline
From the top navigation, select the “…” menu and choose Pipelines. From the Pipelines page, click + New Reusable Pipeline.
Adding a new Reusable Pipeline will take you into the Data Explorer in Advanced Mode where you can build your Pipeline.
Once you’ve created your Pipeline, the last node will be the Reusable Pipeline node where you can give the Pipeline a title and a description, then click Save Pipeline.
Using a Pipeline in a Chart
Pipelines can only be used in charts that are built in Advanced Mode.
After you have created a Pipeline, open the Chart Editor to create a new chart. Switch to Advanced mode, and drag a reusable pipeline node. Once the reusable pipeline node has been placed in the Chart Editor, you can select which Pipeline to use and connect with the rest of your chart.
View the full permissions table in our Teams documentation.
Anyone with access to a data source can create a Pipeline using that data source.
Pipeline Viewers can use the Pipeline in a chart. Editors and Admins can edit the Pipeline and grant View or Edit access. Admins can grant Admin access, edit existing access, and delete the Pipeline. Chartio Owners may view, use, and edit any Pipeline.
Using and editing a Pipeline requires access to the underlying data sources used in the Pipeline.
To share Pipelines with other users, navigate to the Pipelines page. From there, click the ellipsis menu to the right of the Pipeline, and choose Access Settings.
Users can have View, Editor, or Admin access to Pipelines. In order for users to use Pipelines in their charts, they would need view access to the Pipeline. Editors and Admins will have access to edit/change the Pipeline and also share access to other users.
Note: Editors can only share view or editor access to the Pipeline. Only Admins can share admin access and delete Pipelines.
Here we have two charts that calculate User Acquisition. Both charts display the same values but are built differently.
The first chart calculates User Acquisition without Reusable Pipelines
In this chart, the acquisition cost is calculated by combining Marketing and Operations cost and then joining that cost with Users. This requires a series of steps highlighted in the red box above. Other users wanting to calculate this cost or use this cost in their charts would need to repeat the steps. This makes the chart more complicated and difficult to enforce if the definition of acquisition were to change in the future. Instead, this logic can be saved and re-used as a Reusable Pipeline.
Below is the same chart but utilizing Reusable Pipelines. In this chart the acquisition cost is saved into a Pipeline that reduces the number of Data Pipeline Steps into one step.
In addition to a cleaner chart, if the definition of the acquisition cost were to change, the only update that would need to be made is to the Reusable Pipeline definition. All charts using the Pipeline are automatically updated as soon as the Pipeline is updated.