[Direct] Jump pass parameter

1. Overview

This function only supports real-time data.

1.1 Version

1.2 Problem description

The user wants to click to jump from one dashboard to another dashboard, and at the same time realize the parameter pass, so that the BI dashboard realizes data filtering through the jump pass parameter.

1.2.1 Public link jump pass parameters

"Public link jump pass parameter": Used when you want the dashboard to be unexportable after the jump.

For example, enter dashboard A, click on one of the "COUNTRY" to jump, and the pop-up dialog box is dashboard B, where the "Counter" corresponding to the country. The effect is shown in the following figure:

1.2.2 Preview link jump pass parameters

"Preview link jump pass parameters":

1.3 Implementation ideas

This article uses BI internal dashboard to pass web link parameters as an example, and provides two methods: "Public Link Pass Parameters" and "Preview Link Pass Parameters".

1) A dashboard uses a group table to display the content in the "FRDemo_Employe".

2) B dashboard displays the daily average number of visits for each country in the "customerdata".

3) Set the A dashboard to jump to the B dashboard, pass the "COUNTRY" as a parameter, and set the open position as "dialog".

2. Operation steps

Sample data: "FRDemo_Employe" under the FRDemo.

2.1 Add SQL dataset

First, you need to create the "COUNTRY" parameter in the SQL dataset.

Log in to FineBI, enter the "package" and add the SQL dataset, set the table name as "customerdata", enter the SQL statement with parameters select * from CUSTOMER where 1=1 <parameter> and COUNTRY in ('$ {COUNTRY}')</parameter>, that is, set "COUNTRY" as a parameter and name it "COUNTRY", click the parameter setting "Refresh", and select the default to be "Empty", that is, select all, click "OK" to save, as shown below:

Note 1: The above SQL "where 1=1" indicates that the condition is always true, to prevent errors caused by excessive "where" if there are no subsequent parameter conditions; "<parameter>" and "COUNTRY in ('${COUNTRY}') </parameter>" is the added country property parameter. The added parameter is used to obtain all the value of the country property when the intermediate parameter is empty.

Note 2: Different databases have different writing methods. This article only provides reference examples. The example is the SQL writing method of the date range filter component. For details on the writing method of other date types, please refer to: SQL Dataset Parameter Writing Example.

2.2 Create dashboard A before jump

Use the data from "FRDemo_Employe" to create dashboard A, as shown in the figure below:

Note: If the dataset used by the dashboard before the jump has no parameters, it can be made with extracted data, but this method of use is not recommended.

2.3 Create jump sub-dashboard B

Use the newly created dataset "customerdata" to create a template web jump link "B", as shown in the figure below:

2.4 Set jump pass parameters

2.4.1 Public link jump pass parameters

Create a public link for dashboard B and copy the link, as shown in the following figure:

Set the redirection of dashboard A, click "+", choose to add "web link", copy the public link of dashboard B to the URL,

Versions prior to 5.1.11: Add the parameter access channel after the URL as the channel ID in the "FRDemo_Employe": "&COUNTRY=China";

Version after 5.1.11: Add the parameter access channel after the URL as the channel ID in the "FRDemo_Employe": "?COUNTRY=China";

And set the open position as "dialog", click "OK", as shown in the figure below:

If you need to pass multiple values to the parameter, the format is as follows: "&parameter name=parameter value 1','parameter value 2".

For example: add parameter: &access channel=China','America, then click "A" and jump to B from the dashboard to filter out the data of China and America.

Note: If it is a dynamic parameter pass, the parameter cannot be passred when corresponding to multiple values.

2.4.2 Preview link jump pass parameters

Copy the link in the preview state of dashboard B, as shown in the figure below:

Set the redirect to dashboard A, click "+", choose to add "web link", copy the preview link of dashboard B to the URL, and add parameters after the URL. The access channel is "COUNTRY" in "FRDemo_Employe": "?COUNTRY=COUNTRY", and set the open psition as "dialog", click "OK", as shown in the figure below:

If you need to pass multiple values to a parameter, the format is as follows: ? parameter name=parameter value 1','parameter value 2.

For example: add parameters: ?COUNTRY=China','America.

2.5 Effect view

See section 1.2 of this article for details.

3. Notice

After the redirection, the parameters are passed according to the URL first, and the filter conditions set by the filter component are not effective; when the filter conditions are set for the filter components, only the filter component filtering is effective, and the URL redirection parameters are not effective.

For example, in the above example, if a text filter component is added to the B dashboard and the bound parameter is also "COUNTRY", the jump parameter pass result will be displayed first, and then the filter component can be used to pass parameters on the dashboard after the jump, as shown in the figure below: