Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
Tableau Desktop Specialist Certification

You're reading from   Tableau Desktop Specialist Certification A prep guide with multiple learning styles to help you gain Tableau Desktop Specialist certification

Arrow left icon
Product type Paperback
Published in Jan 2023
Publisher Packt
ISBN-13 9781801810135
Length 276 pages
Edition 1st Edition
Tools
Arrow right icon
Author (1):
Arrow left icon
Adam Mico Adam Mico
Author Profile Icon Adam Mico
Adam Mico
Arrow right icon
View More author details
Toc

Table of Contents (17) Chapters Close

Preface 1. Part 1: Introduction to Tableau
2. Chapter 1: Tableau Desktop Specialist Certification Overview FREE CHAPTER 3. Chapter 2: Data Ingestion 4. Chapter 3: How to Interpret Data in a Tableau Visualization 5. Chapter 4: Working with Dimensions, Measures, and Marks (Oh My) 6. Chapter 5: Calculations and Functions Syntax 7. Part 2: Mastering the Exam
8. Chapter 6: Connecting to and Preparing Data 9. Chapter 7: Understanding and Creating Fundamental Charts in Tableau 10. Chapter 8: Data Organization and Worksheet Analytics 11. Chapter 9: Sharing Insights 12. Part 3: The Final Prep
13. Chapter 10: Exam Preparation 14. Chapter 11: Mock Test 15. Index 16. Other Books You May Enjoy

Tableau functions

Functions are the options Tableau uses to create calculations. Tableau has a robust set of functions for developers to create an almost infinite number of calculations with many capabilities. You will not need to learn all functions at this level as many are used for more advanced applications, but we will cover the foundational functions in the following subsections.

Number functions

Numerical fields or fields with # in front of them can be used in calculations to create or refer to something that can be measured. Number functions can only be applied with numerical fields. The number functions that are most common and will be referenced in the exam appear in the following list:

  • ABS: Provides the absolute or non-negative value of a number from the field used. It changes all negative numbers to the positive version of the number and keeps non-negatives the same—for example, ABS(-10) = 10.
  • MAX: Finds the maximum value of the field (based on...
lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at $19.99/month. Cancel anytime
Banner background image