How to Link and Render a Specific Widget Using the Linking Feature in Bold BI

Creating an interactive dashboard often involves linking various widgets to display related information dynamically. This article provides a step-by-step guide on how to render specific widgets through linking.

Step-by-Step Instructions

Step 1: Obtain Widget IDs

Firstly, you need to identify the widget ID for widget you want to link. This can be done by following steps:

1. Make sure that Get Embed Code for Widgets is enabled in the site settings. 
2. Access the dashboard in view mode and click on the three dots icon situated within the widget container.
3. Select the option Get Embed Code and copy the Dashboard URL which has WidgetId.
4. Within the URL, the widget ID value can be obtained.

 

Sample URL: https://example.boldbi.com/bi/dashboards/6c402b6c-352c-4c3b-a5a5-1987cfb7d284/SampleCategory/SampleLinkingDashboard?isembed=true&isWidgetMode=true&WidgetId=6c402b6c-352c-4c3b-a5a5-1987cfb7d284

Step 2: Enable Linking in Widget

• Enable the link option in the required dashboard's widget by referring Linking Dashboards and URLs where the widget linking needs to be used
• In the URL textbox of the linking section, use the above copied dashboard URL by removing the Query Parameter isembed=true like below,

Sample URL:https://test-demo.boldbi.com/bi/dashboards/6c402b6c-352c-4c3b-a5a5-1987cfb7d283/SampleCategory/SampleLinkingDashboard?isWidgetMode=true&WidgetId={WidgetUniqueID}

Step 3: Save Dashboard

1. After configuring the settings, ensure the changes using preview option and publish the dashboard.
   
2. Based on the Advanced URL Linking option widget gets opened.
   

Example Scenario

We have a dashboard named Sales Analysis Dashboard that aims to analyze country sales performance by product category. When a user clicks on a specific country on the widget graph, a detailed sales widget should appear, displaying top-selling products within the selected country. To achieve this, follow these steps:

1. Obtain the dashboard URL with the query parameters isWidgetMode and WidgetId for the widget containing detailed sales data.

2. Enable linking in the widget configured with country data as follows:

3. Save the changes and open the dashboard in view mode.

4. Click on the widget; it will render a specific widget with a detailed data grid.

We have dashboard with few grid widgets for different category includes Retail, Corporate, Online, Distributor, and Dealer and want to display each grid widget based on the chart widget bar click. To do this, follow the steps to achieve it.

• Get the widget unique ID for all widgets in the dashboard by following the steps 1.
• Create an expression with widget unique ID as below:

IF([Channel]='Retail','b1770f48-b72a-44ea-8ca6-b08a33c8b05d',  IF([Channel]='Corporate','9ebfb359-a8ae-4cd0-8e9d-4bb6a798b8b0',    IF([Channel]='Distributor','09bd67fc-d7e7-48e3-9958-96474f5da217',      IF([Channel]='Online','f9a3cd7f-c13a-4eee-a2a7-052a921315d2',        IF([Channel]='Dealer','92ee88e6-166c-438a-87bc-fa992c5893fc',          'b1770f48-b72a-44ea-8ca6-b08a33c8b05d')))))

• Enable the link in the chart widget along with parameters as mentioned in the Step 2.
• Preview or publish the dashboard.
• Now, when click on the chart widget bar, it will be redirected to the widget based on the selected bar value.