注意觀察數(shù)據(jù)
數(shù)據(jù)準備：
建立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
建立計算字段：
創(chuàng)建 Path (數(shù)據(jù)桶)
右鍵 Path, 創(chuàng)建數(shù)據(jù)桶
設(shè)置數(shù)據(jù)桶大小為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 (數(shù)據(jù)桶) 拖到列
右鍵Path (數(shù)據(jù)桶)，確保選擇， 顯示缺失值
把這個Path (數(shù)據(jù)桶)拖到，詳細
把X拖到列
右鍵，計算依據(jù)選擇Path (數(shù)據(jù)桶)
把Y拖到行
右鍵，計算依據(jù)選擇Path (數(shù)據(jù)桶)
把Color拖到顏色
右鍵，計算依據(jù)選擇Path (數(shù)據(jù)桶)
把size拖到大小
右鍵，計算依據(jù)選擇Path (數(shù)據(jù)桶)
可以得到下圖
接著調(diào)整一些參數(shù)
把 Values 拖到列
設(shè)置格式為百分比
右鍵，選擇維度，離散
好了
還可以變換一下圖案、
比如把X和Y對換位置
比如編輯X軸，Y軸，選擇倒敘。
