Book Image

Learning Tableau

By : Joshua N. Milligan
Book Image

Learning Tableau

By: Joshua N. Milligan

Overview of this book

Table of Contents (18 chapters)
Learning Tableau
About the Author
About the Reviewers
Adding Value to Analysis – Trends, Distributions, and Forecasting

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...