August 2022
Beginner to intermediate
463 pages
9h 22m
Chinese
Content preview from Tableau Prep即学即用
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
｜
297
创建
LOD
计算
要创建图
33-2
中前面所示的集合，用
Tableau Desktop
中的
Categorical Sales
（分类
销售额）数据除以
Sales
（销售额）的值（见图
33-8
）。
图
33
-
8
：在 Tableau Desktop 中计算分类销售额的 % 百分比
该计算确定了每行数据贡献的百分比，然后通过
Tableau Desktop
视图中使用的维度
进行汇总。在本例中，这是子类别，尽管可以使用产品层次结构的其他成员来代替（见
图
33-9
）。
图
33
-
9
：Tableau Desktop 中分类销售的百分比分析
通过将分类销售额的值追加到数据集中，可以使你的最终用户不必自己创建复杂的
计算。然而，这些计算（以及任何数据字段）必须正确地使用，以避免导致错误或
误导性分析。
298
｜
第
33
章
33.2.3 LOD
计算在做什么
为了有助于描述
LOD
计算在做什么，让我们通过向数据集追加一个值来探究其过程。
为了更容易看到
Prep Builder
中发生的事情，我们将使用与之前相同的计算，只是
将数据集汇总到子类别的级别（见图
33-10
）。
图
33
-
10
：Superstore（超市）数据集汇总到 Sub-Category（子类别）的级别
第
1
步：计算分类销售额
使用汇总步骤，按
Category
（类别）进行分组 ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.