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

Quick table calculations

Quick table calculations are predefined table calculations that can be applied to any field used as a measure in the view. These calculations include common and useful calculations such as the running total, difference, percent difference, percent of total, rank, percentile, moving average, YTD total, compound growth rate, year over year growth, and YTD growth. These calculations do not show up as separate fields in the Data window.

Consider the following example using the sample Superstore Sales data:

Here, Sales is shown twice using Measure Names and Measure Values. The second SUM(Sales) field has the Percent of Total quick table calculation applied. Each value shown in the Sales column is the sum of sales for that department and category. The value shown in the % of Total Sales column is the sum of sales for that department and category divided by the total sum of sales. Using the quick table calculation avoided writing any code.


You can actually see the code...