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
Conferences
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
Learning Tableau

You're reading from   Learning Tableau Leverage the power of Tableau 9.0 to design rich data visualizations and build fully interactive dashboards

Arrow left icon
Product type Paperback
Published in Apr 2015
Publisher Packt
ISBN-13 9781784391164
Length 340 pages
Edition 1st Edition
Tools
Arrow right icon
Author (1):
Arrow left icon
Joshua N. Milligan Joshua N. Milligan
Author Profile Icon Joshua N. Milligan
Joshua N. Milligan
Arrow right icon
View More author details
Toc

Table of Contents (13) Chapters Close

Preface 1. Creating Your First Visualizations and Dashboard FREE CHAPTER 2. Working with Data in Tableau 3. Moving from Foundational to Advanced Visualizations 4. Using Row-level and Aggregate Calculations 5. Table Calculations 6. Formatting a Visualization to Look Great and Work Well 7. Telling a Data Story with Dashboards 8. Adding Value to Analysis – Trends, Distributions, and Forecasting 9. Making Data Work for You 10. Advanced Techniques, Tips, and Tricks 11. Sharing Your Data Story Index

Scope and direction


Scope and direction are terms that describe how a table calculation is computed relative to the table. When a table calculation is relative, rearranging the fields in the view will not change the scope and direction. Let's see what scope and direction are:

  • Scope: The scope defines the boundaries within which a given table calculation can reference other values

  • Direction: The direction defines how the table calculation moves within the scope

You've already seen table calculations being calculated using the Table (Down) option. In these cases, the scope was the entire table and the direction was down. For example, the Running Total calculation ran from top to bottom of the entire table, adding values as it moved.

To define scope and direction for a table calculation, use the drop-down menu for the field in the view and select Compute using. You will get a list of options that will vary slightly depending on the dimensions present in the view. The first of the options listed...

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