> ## Documentation Index
> Fetch the complete documentation index at: https://help.dingtalk.io/llms.txt
> Use this file to discover all available pages before exploring further.

# Multiple data sources in a dashboard

> Combine multiple tables as data sources in dashboard widgets — analyze related data together for deeper insights.

## Plan availability

| **Feature**                                           |
| ----------------------------------------------------- |
| Cross-table dashboard analysis: multiple data sources |

For full plan details, see [all benefits](https://table.dingtalk.io/pricing?spm=a2q1e.24441682.0.0.4b2c765f7fkSqE). Click [Upgrade](dingtalk://dingtalkclient/page/link?url=https://h5.dingtalk.io/40plan/h5-official-order/order-form.html?articleCode=DT_GOODS_881757389307400&_dlp_=channel%3Daitable_helpdoc\&ddtab=true\&web_wnd=general\&width=820\&height=768) or Book a consultation.

## Overview

When adding or editing a dashboard widget, you can now select multiple tables as data sources. Combine related tables for more complete and deeper insights.

### Example scenario

A national restaurant chain stores foot traffic data per region in separate tables — **North China**, **East China**, **South China**, and **West China traffic tables**.

The operations director wants the **company-wide** monthly foot traffic trend, not four separate regional reports. Combine multiple data sources into a **line chart** — X-axis is month, Y-axis sums foot traffic across regions.

The chart clearly shows peak months and overall growth/decline. Based on accurate trends, the team can prep marketing and staffing for peak months and run promotions in low months.

## Supported chart types

| 📈 Chart type                                                | 🎯 Multi-source primary use                                               |
| ------------------------------------------------------------ | ------------------------------------------------------------------------- |
| **XY-axis charts** (column, line, bar, scatter, combo, area) | Compare values, trends, or distribution across sources within a category. |
| **Pie chart**                                                | Show composition of the same category across sources.                     |
| **Funnel chart (coming soon)**                               | Visualize cross-source business funnel conversion.                        |
| **Word cloud**                                               | Combine and display keywords or text data from multiple sources.          |
| **Radar chart (coming soon)**                                | Compare sources across multiple dimensions.                               |
| **Metric card (coming soon)**, **Stat number**               | Highlight aggregated cross-source key metrics.                            |
| **Ranking widget (coming soon)**                             | Unified ranking of items across sources.                                  |

## Configuration

### XY-axis charts (column, line, bar, scatter, combo, area)

Using a basic column chart as an example — configure type/data and custom style:

**Data**: check **Multiple data sources** — pick multiple tables from the dropdown. Configure data range per table. **All data** enables filters; picking a specific view inherits the view's filter config.

![](https://img.alicdn.com/imgextra/i3/O1CN01KszDmi1d79prGjyxy_!!6000000003688-0-tps-298-303.jpg)

**Chart**: switch chart type, pick a color theme.

![](https://img.alicdn.com/imgextra/i3/O1CN01BKuShI1fKYeeX7Vsr_!!6000000003988-0-tps-301-127.jpg)

**X-axis**: pick an X field per table (preferably same type), sort basis (X value or record order), and order.

![](https://img.alicdn.com/imgextra/i2/O1CN01SxMNFw1mmDt6sncN3_!!6000000004996-0-tps-299-282.jpg)

Sort basis details:

X value: sort by the X field's value — numeric, alphabetical, single/multi-select option order, etc.
Record order: sort by record order in the source view.

**Y-axis**: first decide whether to aggregate by X value. Without aggregation, each table appears as a separate series; with aggregation, each table's Y values for the same X are summed. Examples below.

![](https://img.alicdn.com/imgextra/i4/O1CN01GR8u5C1ErXYE4Bcgh_!!6000000000405-0-tps-294-279.jpg)

Configure aggregation (count of records or aggregated field value).

With "count of records": Y-axis shows the record count corresponding to the X field.

With "aggregated field value": pick a Y field per table and a single overall aggregation (count, distinct count, sum, average, max, min).

Without group aggregation: each Y series is shown independently — e.g., Y shows total purchase count and total sales count per product.

![](https://img.alicdn.com/imgextra/i2/O1CN01Mbd5G21ijhF0fmmaS_!!6000000004449-0-tps-296-398.jpg)

With group aggregation: Y series are merged by aggregation — e.g., Y shows the combined purchase + sales count per product.

**Note**: sum, max, min, average only apply to numeric fields.

**Custom style**: same as single-source. Configure background color, legend position, value display, gridlines, axis labels, overlap settings, axis visibility, axis baselines, axis-tick labels, X-label angle.

![](https://img.alicdn.com/imgextra/i1/O1CN01b5qFxm1nV6hfzKf6w_!!6000000005094-0-tps-298-617.jpg)

> 📌 The sections below cover only multi-source-specific differences from XY-axis charts.

### Pie chart

**Sectors**: pick a sector field per table (preferably same type), sort basis (by sector field value), and order (by sector value).

![](https://img.alicdn.com/imgextra/i2/O1CN01OHbexD1u1ypFmd8x6_!!6000000005978-0-tps-295-324.jpg)

**Sector value**: aggregation supports count of records or aggregated field value. With count: each sector shows the total record count for the X field. With aggregated field value: sectors show the aggregated value (e.g., sum across fields). Examples below.

![](https://img.alicdn.com/imgextra/i3/O1CN01D4ttyH1TH6H8YreMp_!!6000000002356-0-tps-827-382.jpg)

![](https://img.alicdn.com/imgextra/i3/O1CN01NtKC6o20QboolJS9O_!!6000000006844-0-tps-836-410.jpg)

### Word cloud

In Data, pick multiple tables and data ranges. In Keyword field, pick one keyword field per table — the word cloud shows all keywords on the left, sized by frequency.

![](https://img.alicdn.com/imgextra/i3/O1CN01jguns21vsTqGzkY5w_!!6000000006228-0-tps-578-304.jpg)

### Stat number

In Data, pick multiple tables and data ranges. In Aggregation, pick one field per table and an aggregation method — the left displays the aggregated value. Example: with sum, the displayed value is the sum across both fields. With count of records, it's the total record count.

![](https://img.alicdn.com/imgextra/i2/O1CN01HnoslA1iq6mijQ8M3_!!6000000004463-0-tps-644-256.jpg)