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.
304
｜
第
34
章
为了反映我们要如何处理排名计算，在“表计算编辑器”中，我们需要更改
Tableau
Desktop
在计算中使用的特定维度。所选维度的排名将对未选择的维度的每一个组
合进行计算。图
34-5
展示了更新后的计算结果。
图
34
-
5
：排名表计算的更新结果
表计算是非常有用的，因为它们会随着附加维度被带入视图而更新。然而，正如你
所看到的，在
Tableau Desktop
中创建它们是一个包含多步骤的过程，而且还需要一
些背景知识才能使它们按要求工作。因此，如前所述，在
Prep Builder
中预先计算
这个度量，可以让用户免于自己动手，尽管随着其他维度被带入视图，它们会失去
一些更新计算的灵活性。
34.2
在
Prep Builder
中应用表计算逻辑
为了省去
Tableau Desktop
最终用户的麻烦，可以在数据准备阶段创建计算，这样也
能从增加分析计算中受益。你已经看到，分析过程可以在
Prep Builder
中开始，也
可以在
Prep Builder
中完成，因此在这里先创建这些计算函数可以使分析变得更容易。
分析计算的语法与
Tableau Prep
中的其他函数不同：
{ PARTITION [
Dimension
] : {ORDERBY [
Measure
] :
ANALYTICAL_CALC
( ) }}
让我们来探讨一下计算编辑器中的
Analytic Reference
（分析参考）菜单中所列出的
每个选项（见图
34-6
）。
｜
305
分析计算
图
34
-
6
：分析计算选项
34.2.1
关键词
分析参考菜单包括以下关键词： ...
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.