#### Overview of this book

The Tableau Desktop Specialist certification is fundamental for any data visualization professional who works in the field with Tableau. This book gets you started by covering the exam format, Tableau basics, and best practices for preparing data for analysis and visualization. It also builds on your knowledge of advanced Tableau topics to get you up to speed with the essential domains and domain objectives. Although the guide provides an outline and starting point to key in on what needs to be understood before the examination, it also delivers in context to give you a strong understanding of each piece before taking the exam. Instructions on how to get hands on with examples, a common data source, and suggested elements are also included. Understanding the concepts will not only assist you in passing the examination, but will also help you work effectively with the tool in your workspace. By the end of this book, you'll be able to efficiently prepare for the certification exam with the help of mock tests, detailed explanations, and expert advice from the author.
Preface
Part 1: Introduction to Tableau
Free Chapter
Chapter 1: Tableau Desktop Specialist Certification Overview
Chapter 2: Data Ingestion
Chapter 3: How to Interpret Data in a Tableau Visualization
Chapter 4: Working with Dimensions, Measures, and Marks (Oh My)
Chapter 5: Calculations and Functions Syntax
Part 2: Mastering the Exam
Chapter 6: Connecting to and Preparing Data
Chapter 7: Understanding and Creating Fundamental Charts in Tableau
Chapter 8: Data Organization and Worksheet Analytics
Chapter 9: Sharing Insights
Part 3: The Final Prep
Chapter 10: Exam Preparation
Chapter 11: Mock Test
Index
Other Books You May Enjoy

# Working with basic table calculations

Table calculations in Tableau are special calculations that allow you to modify the data to get the percentage of a total, running totals, moving averages, and differences. Table calculations can only be applied to measures (for a dimension to be used, it needs to be transformed into a measure – for example, CNT[Dimension]). Table calculations can be made in the Marks, Rows, or Columns section.

Basic table calculations are out-of-the-box calculations that do not require significant effort from the user to generate. They are made available by right-clicking a measure in the Rows, Columns, or Marks section.

There are so many options, but for the purposes of this exam, you will need to understand the following five options:

• Running Total: Provides a cumulative calculation rather than restarting every dimension.
• Percent of Total: Rather than providing the actual value, it determines the percentage based on the partition.
• ...