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 Certified Associate: Exam Guide

You're reading from   Tableau Desktop Certified Associate: Exam Guide Develop your Tableau skills and prepare for Tableau certification with tips from industry experts

Arrow left icon
Product type Paperback
Published in Dec 2019
Publisher Packt
ISBN-13 9781838984137
Length 370 pages
Edition 1st Edition
Tools
Arrow right icon
Authors (5):
Arrow left icon
Dmitry Anoshin Dmitry Anoshin
Author Profile Icon Dmitry Anoshin
Dmitry Anoshin
Fabian Peri Fabian Peri
Author Profile Icon Fabian Peri
Fabian Peri
JC Gillet JC Gillet
Author Profile Icon JC Gillet
JC Gillet
Radhika Biyani Radhika Biyani
Author Profile Icon Radhika Biyani
Radhika Biyani
Gleb Makarenko Gleb Makarenko
Author Profile Icon Gleb Makarenko
Gleb Makarenko
+1 more Show less
Arrow right icon
View More author details
Toc

Table of Contents (15) Chapters Close

Preface 1. Section 1: Getting Started with Tableau FREE CHAPTER
2. Building Your Data Model 3. Section 2: Answering Questions with Data
4. Working with Worksheets 5. Analyzing Data Using Charts 6. Visualizing Geographic Data 7. Understanding Simple Calculations in Tableau 8. Section 3: Advanced Tableau
9. Tableau Table Calculations 10. Level of Detail Expressions 11. Leveraging Analytics Capabilities 12. Building Your Dashboards 13. Mock Test A + B (Assessment) 14. Other Books You May Enjoy

Creating calculations

To create a calculation, click on Analysis | Create Calculated Field. Alternatively, you can scroll to the end of dimensions/measures tabs and right-click in the white space there.

You should see the following calculations window:

The top of the window, where it says Calculation1, is where you enter the name of your calculated field. The blank area underneath is where you enter your calculation. To the right side, you have a list of all of the available functions you can use and their syntax to quickly help you out. The tiny triangle icon to the right of the calculation editor can be used to toggle the functions window in/out.

Let's create a very simple calculation to see what our total profit would be if the average profit increased four times, and name this calculation 4x Profit, as shown in the following screenshot:

You will see, at the bottom of...

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