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.
｜
123Prep Builder
中的汇总功能
图
15
-
2
：Total Cost（总成本）的计算
这将每一行的值加在一起，同时创建一个新的列来存放总数（见图
15-3
）。
图
15
-
3
：总成本计算的结果
两种工具的总成本计算方式，和用额外的列来存放总成本是相同的。对于没有使用列
工具的重度
Excel
用户来说，在
Excel
中实现的方法是一样的：计算这个值时，你只
需选择哪些单元格加在一起，而不是像在
Tableau
中那样选择列名（见图
15-4
）。
图
15
-
4
：相当于图
15
-
2
中 Excel 表格数据的计算
15.2 Prep Builder
中的哪些计算方式不同
如果我们基于行的计算方式在
Prep Builder
和
Desktop
中都是一样的，那么哪些计
算是不一样的呢？你可能已经猜到了答案：将多行汇总到同一列中的计算。
Prep
124
｜
第
15
章
Builder
中的汇总允许你更改数据集的粒度，并创建小计或总计。
我们以总计为例。在
Desktop
中，要把每个项目的总成本加起来，可写出如图
15-5
所示的算式。
图
15
-
5
：在 Tableau Desktop 中计算一个数据集的总额
如果已经使用了一段时间的
Desktop
，你应该知道，在计算中添加一个汇总时，
Tableau
会根据视图中的离散字段是什么，将所有这些值加起来（见图 ...
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.