Tableau华夫饼图2

---

---

注意观察数据

---

数据准备：
建立Waffle2的CSV文件：

 Metric,Path,Value
 Metric 1,1,0.8
 Metric 1,100,0.8
 Metric 2,1,0.95
 Metric 2,100,0.95
 Metric 3,1,0.55
 Metric 3,100,0.55
 Metric 4,1,0.3
 Metric 4,100,0.3

---

建立计算字段：

创建 Path (数据桶)

右键 Path, 创建数据桶
设置数据桶大小为1.
确认

Index

INDEX()

X

IF [Index] = 1 THEN
1
ELSEIF [Index] <= 3 THEN
2
ELSEIF [Index] <= 6 THEN
3
ELSEIF [Index] <= 10 THEN
4
ELSEIF [Index] <= 15 THEN
5
ELSEIF [Index] <= 21 THEN
6
ELSEIF [Index] <= 28 THEN
7
ELSEIF [Index] <= 36 THEN
8
ELSEIF [Index] <= 45 THEN
9
ELSEIF [Index] <= 55 THEN
10
ELSEIF [Index] <= 64 THEN
11
ELSEIF [Index] <= 72 THEN
12
ELSEIF [Index] <= 79 THEN
13
ELSEIF [Index] <= 85 THEN
14
ELSEIF [Index] <= 90 THEN
15
ELSEIF [Index] <= 94 THEN
16
ELSEIF [Index] <= 97 THEN
17
ELSEIF [Index] <= 99 THEN
18
ELSE
19
END

Y

IF [X] = 1 THEN
[Index]-0
ELSEIF [X] = 2 THEN
[Index]-1.5
ELSEIF [X] = 3 THEN
[Index]-4
ELSEIF [X] = 4 THEN
[Index]-7.5
ELSEIF [X] = 5 THEN
[Index]-12
ELSEIF [X] = 6 THEN
[Index]-17.5
ELSEIF [X] = 7 THEN
[Index]-24
ELSEIF [X] = 8 THEN
[Index]-31.5
ELSEIF [X] = 9 THEN
[Index]-40
ELSEIF [X] = 10 THEN
[Index]-49.5
ELSEIF [X] = 11 THEN
[Index]-59
ELSEIF [X] = 12 THEN
[Index]-67.5
ELSEIF [X] = 13 THEN
[Index]-75
ELSEIF [X] = 14 THEN
[Index]-81.5
ELSEIF [X] = 15 THEN
[Index]-87
ELSEIF [X] = 16 THEN
[Index]-91.5
ELSEIF [X] = 17 THEN
[Index]-95
ELSEIF [X] = 18 THEN
[Index]-97.5
ELSE
1
END

Color

IF [Index]/WINDOW_MAX([Index])< WINDOW_MAX(MAX([Value])) THEN
WINDOW_MAX(MAX([Metric]))
ELSE
"Grey"
END

Size

IF [Index]/WINDOW_MAX([Index])< WINDOW_MAX(MAX([Value])) THEN
1
ELSE
0
END

开始操作：

更改标记为圆
把Metric 拖到筛选器, 选择 Metric 1.
把Metric 拖到详细信息
把 Metric 拖到列

把 Path (数据桶) 拖到列
右键Path (数据桶)，确保选择， 显示缺失值
把这个Path (数据桶)拖到，详细

把X拖到列
右键，计算依据选择Path (数据桶)

把Y拖到行
右键，计算依据选择Path (数据桶)

把Color拖到颜色
右键，计算依据选择Path (数据桶)

把size拖到大小
右键，计算依据选择Path (数据桶)

可以得到下图

接着调整一些参数
把 Values 拖到列
设置格式为百分比
右键，选择维度，离散

---

好了
还可以变换一下图案、
比如把X和Y对换位置
比如编辑X轴，Y轴，选择倒叙。

---