了解詳細(xì)級(jí)別表達(dá)式
-
INCLUDE：以較低的詳細(xì)級(jí)別進(jìn)行計(jì)算
- 在視圖中用作聚合度量
-
EXCLUDE：以較高的詳細(xì)級(jí)別進(jìn)行計(jì)算
- 從可視化詳細(xì)級(jí)別中刪除排除的維度并執(zhí)行計(jì)算帖旨，假設(shè)該維度完全不存在
- {EXCLUDE [地區(qū)]: SUM([銷(xiāo)售額])}
- 可指示 Tableau 排除地區(qū)維度，用可視化內(nèi)容中的其他維度計(jì)算總銷(xiāo)售額碉就。 也就是說(shuō)闷串，最后每個(gè)月都會(huì)得出單個(gè)值，代表所有地區(qū)的總銷(xiāo)售額碉熄。
-
Fixed： 指定確切的詳細(xì)級(jí)別
- 與 INCLUDE 和 EXCLUDE 不同肋拔，該關(guān)鍵字可獨(dú)立于可視化內(nèi)容中所用的維度
表計(jì)算
-
Addressing vs. Partitioning
- Partitioning: the scope or grouping of the calculation. This can be the full table, a pane, a cell, a dimension or it can be customized even further for more advanced calculations
- Addressing: the anchor or the source of each partition. It defines the root of the calculation
-
Table (Across)：水平橫穿
- set the addressing to compute along the entire table, moving horizontally through each partition
-
Table (Down)
- This option sets the addressing to compute along the entire table moving vertically through each partition
-
Table (Across then Down)
- This option sets the addressing to compute across the entire table horizontally and then down the table verticallyy. This means that both the fields that span across the table and down the table are addressing fields
- That means that the entire table is the partition. The computation will compute across, move to the next row and continue to compute across, and so on.
