When you create a dashboard, you may have a requirement like that. For example, when you click an area of a chart, you want the corresponding fields of other correlated charts to change along with this area.

This section describes how to create a dashboard with a cross-chart reference. Take a sample dataset provided in our data model as an example. This dashboard consists of two charts, divided into two parts the upper half and lower half respectively. In the upper half, a pie chart contains the profit data for each region. In the lower half, a table contains the sales and profit data of cities in each region.

Prepare sample datasets

Create a dataset by using a CSV file. For more information, see Upload local files.

Rename this dataset demo sales dataset.

Create a pie chart that contains profit data of each region

Create a dashboard and then click the pie chart icon in the configuration area of this dashboard. You can configure the dataset of this pie chart as follows.
  • Select Sales data demo dataset as the dataset of this pie chart.
  • Select the area field as a dataset dimension.
  • Select the profit_amt field as a metric.

Click the Update button.

On the Style tab, set the title of the pie chart to Regional Data. The result is shown in the following figure.

Create a table that contains sales and profit details of cities in each region

In the configuration area of this dashboard, click the table icon and then drag it to the lower half of the dashboard. You can configure data attributes of this table as follows.
  • Select Sales data demo dataset as a dataset of this table.
  • Select the area field and the city field as data dimensions.
  • Select the profit_amt field and the order_amt field as metrics.

On the Style tab of the table, set the title of this table to City data details.

Click the Update button. The result is shown as follows.

Configure a cross-chart reference on the pie chart

Click Advanced tab on pie chart. Join the pie chart with the table.

Preview correlations

Click the Preview button to view how the correlation works.

Click the East region on the pie chart, the data is shown as follows.
Click the North region on the pie chart, the data is shown as follows.

Save the dashboard

Save this dashboard after you complete the previous steps.

Publish the dashboard

If no sensitive data exists in a dashboard, you can publish this dashboard on the Internet.

You can publish the dashboard as shown in the following figure.