了解详细级别表达式
-
INCLUDE：以较低的详细级别进行计算
- 在视图中用作聚合度量
-
EXCLUDE：以较高的详细级别进行计算
- 从可视化详细级别中删除排除的维度并执行计算，假设该维度完全不存在
- {EXCLUDE [地区]: SUM([销售额])}
- 可指示 Tableau 排除地区维度，用可视化内容中的其他维度计算总销售额。 也就是说，最后每个月都会得出单个值，代表所有地区的总销售额。
-
Fixed： 指定确切的详细级别
- 与 INCLUDE 和 EXCLUDE 不同，该关键字可独立于可视化内容中所用的维度
表计算
-
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.
网友评论