Mastering Tableau 2018.1, Second Edition 7.3: Quick Table Calculations – Percent Difference and Percent of Total

This video tutorial covers table calculations in Tableau, focusing on the percent difference and percent of total functions. It explains how to calculate and interpret these functions, using examples like pie and bar charts to demonstrate their application. The tutorial also highlights the use of absolute functions to ensure positive values and provides guidance on editing table calculations. The video concludes with a brief introduction to rank functions, setting the stage for the next tutorial.

What is the primary purpose of using the percent difference function in Tableau?

• To create a pie chart

• To find the percentage change between values

• To rank the sales data

• To calculate the total sales

Which function is used to convert a number into its absolute value in the percent difference calculation?

• Average function

• Difference function

• Absolute function

• Sum function

How can you modify the calculation basis in the percent difference function in Tableau?

• By using the edit table calculation option

• By changing the data source

• By altering the chart type

• By adjusting the color scheme

What does the percent of total function help visualize in Tableau?

• The contribution of each category to the total

• The total number of data entries

• The highest sales value

• The average sales per region

Which chart type is commonly used to display the percent of total in Tableau?

• Pie chart

• Scatter plot

• Line chart

• Histogram

What is the formula used in the percent of total calculation?

• Total sales minus sum of sales

• Sum of sales divided by total sales

• Sum of sales plus total sales

• Average sales multiplied by total sales

What topic is introduced at the end of the video for the next session?

• Difference functions

• Rank functions

• Pie charts

• Running totals