Click different data under the same field to jump to the corresponding dashboard

1.1 Expected effect

Sometimes users hope to click on different fields in the dashboard to jump to the corresponding dashboard to view detailed data, as shown in the following figure:

1.2 Implementation ideas

Add a new column to the self-service dataset, use the IF or SWITCH function to determine the URL links that need to be redirected to different fields;

When making a dashboard, use the "Jump" function, and the jump link directly selects the new field.

Sample data: "Internet Industry>Internet Channel Statistics".

The example is to click "New media marketing" to jump to the detailed dashboard interface, and click "Online channel" to jump to the detailed dashboard interface.

2.1 Add a new column to determine the jump location

Continue to edit "Internet Channel Statistics", add a new column, name it "Judge jump field", and enter the formula: SWITCH(First-level channel name, "New Media Marketing", "http://localhost:37799/webroot/decision/v5/design/report/b08a7269a5ad463c9fb37f5b45963a9b/view", "Online Channel", "http://localhost:37799/ webroot/decision/v5/design/report/4b750c54ceb14b2f956d121cc197a18a/view","offline channel","http://localhost:37799/webroot/decision/v5/design/report/752b01b34cdb4406bd98ce71c18940de/view"). The returned text is the URL of the corresponding dashboard, and the user can modify it to his BI access URL according to actual needs, as shown in the following figure:

Formula description:

If the first-level channel is named "New Media Marketing", the URL text will be returned: http://localhost:37799/webroot/decision/v5/design/report/b08a7269a5ad463c9fb37f5b45963a9b/view

If the first-level channel is named "online channel", the URL text will be returned:http://localhost:37799/webroot/decision/v5/design/report/4b750c54ceb14b2f956d121cc197a18a/view

Save the self-service dataset.

2.2 Set Jump

Create a dashboard and add a new group table, as shown in the following figure:

Enter the dashboard editing interface, click "Jump Settings", add a "web link" and select the "Judge jump field" in the jump to position, as shown in the following figure:

2.3 Effect view

See section 1.1 of this article for details.