The chart join feature is highly versatile, enabling you to merge data from different sources. The DataTile platform excels in performing data from multiple databases and presenting the results on a single dashboard, simplifying your data management and analysis tasks. This is particularly useful for tasks like benchmarking and comparing data across various datasets.
The key to combining charts is matching labels. Even if the data and logic in the charts are different, you can join them as long as they share identical labels. For instance, you can display the test results of an ad, add a benchmark from the norm database on the same chart, and compare them using statistical tests.
Table joins are limited to data with matching metrics. When you join tables derived from the same dataset, the resulting data will adhere to the metric specified in the main table. However, if the data comes from different databases and the metrics don't match, they won't be displayed.
How to join charts
Export both charts to a dashboard.
Click on the chart that you want to be integrated, then select ‘Join: Horizontal’ or ‘Join: Vertical’ from the assignment panel. When you are joining horizontally ensure that the rows match to display them side-by-side, and for a vertical join, ensure that the column labels match so they can be stacked.
You have the option to manually match the variables by renaming them within the crosstab.
You can apply conditional formatting and other customizations to your joined chart as you would with any regular chart.
For example, we have two surveys conducted by different research agencies, both examining technology ownership. The first survey focuses on general device ownership, while the second delves into the specifics of laptop brand, particularly the 'Techbook' brand.
Although these are two separate surveys they can be joined as they have identical row labels - except for the option ‘65+’. The joining can be made in two steps: we join them horizontally and rename the mismatching option in crosstab. Please, refer to our instructional video.
After the joining, you can hide the ‘Techbook laptop owned’ table by clicking the ‘eye’ icon in the widget settings. Note that deleting it results in the loss of the joined table.
Controls for joined charts
You can’t have one control for the joined chars because each control is built on data from one database only. The solution here is to create two controls - one for each of the charts - and synchronize them. The joined chart will be managed by a hidden control, which in turn will be synchronized with the primary control. The primary control assigned to the joined chart will effectively operate in dual modes, ensuring the accurate display of data in the joined chart.