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.
70
｜
第
8
章
数字转换回日期，该函数将以秒为单位的新纪元时间添加到以
1970
年
1
月
1
日为基
准的新纪元日期中。
Tableau
中的函数名是不区分大小写的，所以在本书中你会看到它们的格式
有大写和小写两种。
图
8
-
2
：用 dateadd() 函数转换新纪元日期
如果想检查你的
Epoch
（新纪元）转换是否正确，建议使用新纪元
Unix
时
间戳转换器。
8.5 Excel
序号
如果你处理过数据，可能会遇到一个类似于
UNIX
纪元日期的值，但要小得多。正
如名人堂大师
Jonathan Drummey
发现的那样，
Excel
的序列号是自
00/01/1900
（一
个从未存在过的日期）以来的天数，因此
1
将代表
1900
年
1
月
1
日，但诡异的是，
第一个闰年被跳过并忽略。相当于我们上述例子中的日期的
Excel
序号是
43731
。
使用
dateadd()
函数，我们可以将这个数字转换为一个日期进行分析，就像之前在
新纪元日期解决方案中所做的那样，但这次我们将使用天数的增量和
1900-01-01
这
个起始日期（见图
8-3
）。
图
8
-
3
：用 dateadd() 函数转换一个 Excel 的序列日期
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.