Embed Link with pivot using global parameter

Embed Link with pivot using global parameter: This video contains how to use Embed Link with pivot using global parameter.

In this Document you will learn to Create a dashboard and add a Card chart widget and Table widget. You will learn create embed link and how to connect embed link with one dashboard to another dashboard and filter detail dashboard with global filter parameters.

[note: to apply global filters, parameterized dataset should be used in detail dashboard]

Use case: You have one summary level of Dashboard which contains summarized data. You don’t want to show detail data in this dashboard. Also, you have another dashboard which contains Detail level of data which is called Detailed dashboard. Now if you want to see detail data of summarized data and by clicking on summarized data it should redirect to the detail dashboard you have created with filter value applied on summary dashboard.

-In this document we will see how to meet this use case. So, we have one summary level of dashboard and one detail level of dashboard. Summary level dashboard contains pivot table showing grouped data and detail dashboard have table widget showing detailed data of that column chart. Detail dashboard table has 2 parameters 1. country and 2. Productline

-In this scenario we will use pivot table. When you click on any numbers it will redirect us to detail data dashboard. Here in pivot table, we have to pass rows and column values of data we are clicking.

Click on hamburger icon.

Click on (+) icon, from visualization Tab.

The Create Dashboard Dialog box will pop up on screen. Enter Dashboard Name as shown in Figure.

Click on Create After entering Dashboard Name in dialog box.

Docusaurus Slash Introduction

You will see an Empty Dashboard, As shown in figure below:

Docusaurus Slash Introduction

From Right Vertical Menu Select the Pivot Widget icon.

The Edit menu box appears as you click on Pivot chart icon. And a widget gets added in content place automatically in dashboard, As shown in Figure below:

Docusaurus Slash Introduction

Enter Following details in Pivot:

Type: Table

Dataset: Salesb.ds

Drag and drop country in rows and productLine in Columns.

Drag and drop country in Values.

Fill above details in edit box, As Shown in figure;

Docusaurus Slash Introduction

Click on Save and Exit.

Pivot widget is shown in Figure Below:

Docusaurus Slash Introduction

Create a New Dashboard and give Name Detailed Data of the dashboard, As shown in figure Below:

Docusaurus Slash Introduction

From Right Vertical Menu Select the Table Widget icon.

The Edit menu box appears as you click on Table Widget icon. And a widget gets added in content place automatically in dashboard, As shown in Figure below:

Docusaurus Slash Introduction

Enter Following details in General Property:

Dataset: Parameter.ds

In Dataset Column Select All the Field.

Fill above details in edit box, As Shown in figure below;

Docusaurus Slash Introduction

Click on Preview and Save and Exit, As shown in figure below:

Docusaurus Slash Introduction

Click on Embed icon Docusaurus Slash Introduction of the Detailed Data Dashboard, As shown in Figure Below:

Docusaurus Slash Introduction

Copy the Link of Internal Embed in Embed.

Click on Cancel.

Open the Pivot Summery Dashboard in Edit mode.

Enter Following details in Pivot Property:

-Click on Hyperlink dropdown and select Custom Link

Link:http://localhost:8080/OPNBI/embed/internal/OPNBIHubInternalEmbed/a_i212&a_nDetailedData&a_asdashboards&a_aftrue/OPNBIg_country{{country}}&OPNBIg_productline{{productLine}}

Fill above details As shown in figure below:

Docusaurus Slash Introduction

Click on Preview Save and Exit.

Now Click on Preview mode.

Docusaurus Slash Introduction

Here If we want to see detail data of Belgium with classic cars, just click on 4 number and it will take row value as Belgium and column value as classic cars in embed URL.

It will redirect on Detailed Data Dashboard. You can see data is filtered by country Belgium and Product line Classic Cars, As shown in figure Below:

Docusaurus Slash Introduction