January 2016
Beginner to intermediate
736 pages
16h 26m
English
Content preview from Tableau Your Data!, 2nd Edition
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.
Appendix E Understanding Tableau Functions
If you are accustomed to creating SQL statements in a database, the functions and syntax of Tableau’s calculated values should look familiar. If you are a spreadsheet expert, the syntax will be new but should not pose a significant challenge for you to learn.
Tableau’s formula-editing window provides help and error-checks the syntax of the formulas you create. Even if you have no experience, with a little practice you’ll find that you use some functions frequently. Table E-1 groups functions into thirteen categories.
Table E-1: Tableau Function Categories
| Function Category | Category Capabilities |
| Aggregate | Mathematical and statistical summaries of your data. |
| Date | Calculate and parse date fields. |
| Google Big Query | Functions that work with Big Query data sources only. |
| Hadoop Hive | Functions that work with Hadoop Hive data sources only. |
| Level of Detail (LOD) | Level of detail expressions support aggregation in calculations at dimension levels different from the view level. Computed at the data source unlike table calculations, totals, or reference lines. |
| Logical | Conditional operations based on your data. |
| Number | Arithmetic and trigonometric operations. |
| RawSQL Pass Through | Pass SQL statements directly to the data source and then excute the statement within the data source. These functions do not work with every data source supported by Tableau. |
| String | Functions for manipulating strings. |
| String Pattern | Specialized string patter functions (REGEXP) ... |
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.