June 2023
Beginner
320 pages
8h 16m
English
Content preview from Tableau For Dummies, 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.
Chapter 13
Ten Tableau Must-Know Function Types
I don't know about you, but I am not a fan of doing extra data crunching when it's unnecessary. Most big vendors agree that such activity is not a good use of time for folks like you and me. It is common practice for business intelligence and data analysis software to include functions, which provide a way to calculate and convert complex values easily.
This chapter aims to give you a Top 10 list of crucial function areas you might want to use when crunching. Rather than using extraordinarily painful formulas and converting data slowly with a pen and paper (or some other computer application), using these functions can save you lots of time and yield data value precision.
Number Functions
The number function is among the most heavily used in Tableau. Why? Because Tableau first and foremost builds data based on quantitative results. And how do you generate quantitative output? By using numbers. Table 13-1 lists key number functions to support creating numerical output.
TABLE 13-1 Key Number Functions
NAME |
DESCRIPTIONS |
|---|---|
|
Presents the absolute value of a number. |
|
Presents the arc cosine of a number. |
|
Presents the arc sine of a number. |
|
Presents the arc tangent of a number. |
|
Presents the arc tangent of two numbers. |
|
Presents a rounded number up to the nearest integer. |
|
Presents the cosine of an angle. |
|
Presents the cotangent of an angle. |
|
Converts an angle from radians ... |
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.