Joining datasets on multiple columns

Data Pipeline

Joining multiple datasets on more than one column is possible in Chartio. We’ll illustrate this with an example.

In our chart, we want to group our Payments by Date and then by Plan Cost. We want to separate our plans into two datasets: Low Cost and High Cost, which we’ll accomplish by filtering the datasets by the Cost column. Here’s what our first dataset looks like:

Filter the dataset by Cost

We’ll then need to join our datasets on the first two columns. We’ll select Outer Join as the merge type, and select 2 from the Join on first N columns dropdown. This allows us to join our datasets on both the Month of Payment Date and Cost columns.

Choose Outer Join as the Merge type

I’ve also checked Show row totals for numeric columns in the Chart Settings so I can compare between the Low and High cost totals. Here’s what our final chart looks like:

Final result

For more details on joining datasets, please see our documentation on Merging Data.

Related Data Pipeline Help Articles

See more