[MUSIC]

In the last lesson, we focused on what calculated fields are used for and

how to create new fields.

In this lesson, I will cover quick table calculations and show you how to use this

calculations to better tell your story.

To take the functionality of calculated fields even further,

Tableau allows you to do additional calculations on your data

after Tableau has completed a query of the data base.

Table calculations address data in the cache table and

allow you to perform calculations on visible results.

So, what does that mean?

Once our visualization is rendered,

we can ask Tableau to literally look at the results, numbers, bars or plots.

And then do math on those visible results.

Most importantly, unlike calculated fields that allow you to compare two or

more separate measures in your data set,

table calculations allow you to compare a singular measure to itself.

To take the functionality of calculated fields even further,

Tableau allows you to do additional calculations on your data

after Tableau has completed a query of the data base.

Table calculations address data in the cache table and

allow you to perform calculations on visible results.

So, what does that mean?

Once our visualization is rendered,

we can ask Tableau to literally look at the results, numbers, bars or plots.

And then do math on those visible results.

Most importantly, unlike calculated fields that allow you to compare two or

more separate measures in your data set,

table calculations allow you to compare a singular measure to itself.