The 'Sync' tool empowers you to switch between charts independently using a single control. It works by allowing two controls to simultaneously switch positions when they share the same tab titles, even if their tab contents are different. Let's examine this further through an example.
How to synchronize controls
Consider a scenario where you create a brand awareness chart and apply region-based filters. Your goal is to display specific brands for various regions, even though your dataset lacks a clear-cut brand distribution by geographical regions. In this scenario, each brand can belong to multiple regions.
| Region1 | Region2 | Region3 |
Brand1 | v | v | v |
Brand2 | v |
| v |
Brand3 | v | v |
|
Brand4 |
| v | v |
To display specific brands for each region, you can manually assign brands to regions with the help of the 'Sync' control option.
Start by creating a chart that lists brands in the rows (with one total column).
On the dashboard, create a control based on the 'Region' variable.
Now, create another control with multiple tabs, naming each tab after a different region. Populate each tab with the brands you want to display for that specific region.
Select the chart and enable the 'Filter' toggle under 'Show in header' to ensure that the correct region is always visible above the chart.
Assign the controls as follows:
Click on the ‘Region’ control, select ‘Sync’ on the command bar of the other brand control and then select ‘Filter’ on the command bar of the chart;
Next, select the brand control and assign it to the chart as ‘Put on: Rows’.
Go to VIEW mode and switch between regions to check if the desired brands displayed for each region.
The sync-assigned control is hidden automatically. To make it visible, click the visibility ‘eye’ icon in the widget settings toolbar.