如何在Google Data Studio数据融合时为缺失记录显示0
2026-8-25
Google Data Studio 数据源融合问题
数据源1：按市场划分的周度销售数据
| ID | WeekEndingDate | Market | Sales |
|---|---|---|---|
| 1 | 7/17/2022 | Utah | $400 |
| 2 | 7/17/2022 | Arizona | $500 |
| 3 | 7/17/2022 | Colorado | $600 |
| 4 | 7/17/2022 | Dallas Fort Worth | $700 |
| 5 | 7/10/2022 | Utah | $400 |
| 6 | 7/10/2022 | Colorado | $300 |
| 7 | 7/10/2022 | Dallas Fort Worth | $800 |
| 8 | 7/10/2022 | Arizona | $600 |
| 9 | 7/10/2022 | Utah | $500 |
| 10 | 7/10/2022 | Colorado | $100 |
数据源2：按市场划分的周度预算数据
| WeekEndingDate | Market | Sales Budget |
|---|---|---|
| 7/17/2022 | Utah | $5000 |
| 7/17/2022 | Arizona | $4000 |
| 7/17/2022 | Colorado | $3000 |
| 7/17/2022 | Dallas Fort Worth | $2000 |
| 7/17/2022 | Tennessee | $1000 |
| 7/17/2022 | Oregon | $1000 |
| 7/10/2022 | Utah | $5000 |
| 7/10/2022 | Arizona | $4000 |
| 7/10/2022 | Colorado | $3000 |
| 7/10/2022 | Dallas Fort Worth | $2000 |
| 7/10/2022 | Tennessee | $1000 |
| 7/10/2022 | Oregon | $1000 |
期望结果
表格需包含数据源2中所有市场-日期组合，无对应销售记录的行显示$0销售额（加粗行是当前无法获取的内容）：
| WeekEndingDate | Market | Sales Budget | Sales |
|---|---|---|---|
| 7/17/2022 | Utah | $5000 | $400 |
| 7/17/2022 | Arizona | $4000 | $500 |
| 7/17/2022 | Colorado | $3000 | $600 |
| 7/17/2022 | Dallas Fort Worth | $2000 | $700 |
| 7/17/2022 | Tennessee | $1000 | $0 |
| 7/17/2022 | Oregon | $1000 | $0 |
| 7/10/2022 | Utah | $5000 | $900 |
| 7/10/2022 | Arizona | $4000 | $600 |
| 7/10/2022 | Colorado | $3000 | $400 |
| 7/10/2022 | Dallas Fort Worth | $2000 | $800 |
| 7/10/2022 | Tennessee | $1000 | $0 |
| 7/10/2022 | Oregon | $1000 | $0 |
当前设置与问题
- 融合设置：以
WeekEndingDate和Market作为关联键，先后尝试内连接、全外连接 - 问题：内连接仅显示两个数据源匹配的行；切换全外连接后，仍无法显示数据源2独有的市场-日期组合（如7/17/2022 Tennessee、7/17/2022 Oregon等），这类行的销售额需显示$0但无法出现在结果中
更新说明
补充了样本数据和Data Studio样本报告，用于排查问题。
内容的提问来源于stack exchange，提问作者Schaeffer Warnock
相关产品推荐
相关产品推荐
