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
- 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.
Create a table that contains sales and profit details of cities in each region
- 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.
Configure a cross-chart reference on the pie chart
Click Advanced tab on pie chart. Join the pie chart with the table.
Click the Preview button to view how the correlation works.
Save the dashboard
Publish the dashboard
If no sensitive data exists in a dashboard, you can publish this dashboard on the Internet.