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.
｜
289
实现高级连接
图
32
-
9
：拆分周数区间字段的结果
现在，这些字段可用于设置原始数据集中实际周的区间。将范围内的最小周作为小
于或等于的条件，将范围的最大周作为大于或等于的条件，就可以将相关区间的记
录添加到商品数量和价值数据集中（见图
32-10
）。
图
32
-
10
：多个连接条件和运算符
32.3 OR
语句
正如本章前面所讨论的那样，多个连接条件表现为
AND
语句，但如果你不希望所
有记录都满足你所评估的全部连接条件，会发生什么？在这个例子中，我们正在评
290
｜
第
32
章
估
Profit
数据集（见图
32-2
）和
Actual Volume and Value
（商品销量、销售额）数
据集（见图
32-1
）。连接所需要的输出是实际商品销量或销售额是否低于该周的预算。
你可以通过连接来模仿
OR
语句的行为，但实际上你需要做两个连接，然后把这些
结果联合起来，得到一个完整的符合要求的记录集。
因为连接条件的设置非常相似，所以这里我只展示两个条件中的一个。对于另一个，
只需将
Volume
换成
Value
即可。
Type=Type
是一个连接条件，但它是图
32-11
之外
的内容。
图
32
-
11
：OR 语句的连接条件设置
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.