Using Quick Table Calculations to Analyze Data

Question 1

What is a table calculation?

Answer 1

A computation applied to the values in a data table for the view, often dependent on the table structure itself

Question 2

Where are table calculations processed, in the database query, or locally in Tableau?

Answer 2

Locally in Tableau

Question 3

Do filters affect table calculations?

Answer 3

Yes

Question 4

How do you avoid messing up your table calculations if you want to remove something from your view?

Answer 4

Hide the item instead of filtering it out

Question 5

What is an easy way to use the same quick table calculation in multiple views?

Answer 5

Save it as a calculated field

Question 6

Table calculations depend on both the _____ and the _____ of the calculation

Answer 6

Scope and direction

Question 7

What are the 4 relevant options for the scope and direction of a table calculation?

Answer 7

Table (Down), Table (Across), Pane (Down), Pane (Across)

Question 8

What is a “pane” in reference to table calculations?

Answer 8

A smaller segment of the whole view that exists when there are multiple dimensions included in the view that break it down at different levels (e.g. State and City - each State would be a pane)

Question 9

How can you use rank as an identifier/dimension within your view instead of as a label or a measure?

Answer 9

You can change the Table Calculation to a discrete field and then add it to one of the shelves