How to create a Databoard using data from multiple Data Sources

In this document, we will walk through how to add data from multiple Data Sources to one Databox report.

HOW TO

You can add data from multiple Data Sources to a Databoard using the Metric Library, the list of blank Visualization Types, or My Metrics in the Designer. 

1
 Click the Metric Library icon on the lefthand side of the Designer.
2
 Choose the Data Source you want to add to the Databoard from the Metric Library from the Data Source drop-down.
3
 Search for a pre-built Datablock that reports on the data you're looking for, using the Search bar if necessary. If a pre-built Datablock isn't available for your data, click on the Visualization Types icon right below the Datablock Library.
Pro Tip : If you've added the Metric to your Metrics screen, it will also be available to add to your Databoard from the My Metrics tab below the Visualization Types icon. 
4
 Drag and drop the selected Datablock to your Databoard. 

If you have chosen a pre-built Datablock from the Metric Library, this will automatically populate with data from the selected Data Source. 

If you have chosen a Datablock from the list of Visualization Types, you will need to use the righthand Datablock Editor to select the desired Data Source, Metric, Date Range, and further customize the Datablock.
5
 To add another Datablock to the Databoard, navigate back to the Metric Library and choose the next Data Source you want to add data from to your Databoard. Or, click on the Visualization Type icon right below the Metric Library.
6
 Drag and drop the selected Datablock to your Databoard. 
  • If you have chosen a pre-built Datablock from the Metric Library, this will automatically populate with data from the selected Data Source. 
  • If you have chosen a Datablock from the list of Visualization Types, you will need to use the righthand Datablock Editor to select the desired Data Source, Metric, Date Range, and further customize the Datablock. 
Pro Tip: Each Datablock is completely unique from all other Datablocks on the Databoard.
7
 Repeat this process for the remaining Datablocks you want to add to your Databoard.

How to add data from multiple Data Sources to 1 Datablock

You can only add data from multiple Data Sources to one Datablock for select Visualization Types. These include the Pie Chart, basic Table, Pipeline, Funnel, Compare, Interval, Combo Chart, and Multi-Tab Chart.

HOW TO

How to add data from multiple Data Sources to a Table or Pie Chart

1
 Click the Visualization Type icon on the lefthand side of the Designer.
2
 Drag and drop the Table or Pie Chart Visualization to your Databoard.
3
 In the righthand Datablock Editor, select Data From: Multiple Metrics. This will allow you to manually map each row of the Table or slice of the Pie Chart to a different Metric and/ or Data Source.
Pro Tip: Each Metric is completely unique from all other Metrics on the Datablock.
4
 Select the Data Source and Metric that you want to populate the first row of the Table or slice of the Pie Chart.
5
 Click + Add new row.
6
 Select the Data Source and Metric you want to populate the next row of the Table or slice of the Pie Chart.
7
 Repeat this process for the remaining rows of the Table or slices of the Pie Chart that you want to add to the Datablock.

How to add data from multiple Data Sources to a Pipeline, Funnel, Compare, Interval, Combo Chart, and Multi-Tab Chart

1
 Click the Visualization Type icon on the lefthand side of the Designer.
2
 Drag and drop the Pipeline, Funnel, Compare, Interval, Combo Chart, or Multi-Tab Chart visualization to your Databoard.
3
 In the righthand Datablock Editor, select your first Data Source and Metric.
4
 Depending on the visualization you've added to your Databoard, you may or may not need to click +  Add Row to add your next Data Source and Metric to the Datablock.
Pro Tip: Each Metric is completely unique from all other Metrics on the Datablock.
5
 Select the second Data Source and Metric you want to populate the Datablock.
6
 Repeat this process for the remaining Data Source/ Metric spaces that the Datablock supports.
Pro Tip: Learn more about the capabilites and considerations of each Visualization Type here. 
Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Related Articles