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

Practical examples

Having looked at some of the foundational concepts of table calculations, let's consider some practical examples. We'll start with some simple ones and move toward complexity.

Moving Average

We've been looking at table calculations mostly in text-tables because this is a natural way to think about how they work. It's also a great way to build and verify table calculations prior to transforming the view into a more complex visualization.

The following is a view of daily website traffic for the blog. Observe that the top time series displays a cyclical up-down pattern. What causes this? It turns out that most people visit the blog during the week. Very few individuals read it on weekends.

Seeing this pattern can be useful, but it can also be distracting if we really just care about the overall trends and pattern.

To "smooth out" the chart, the second Visits field on the Rows shelf uses the Moving Average quick table calculation to "smooth out" the chart with...