Ultimate Tableau Desktop Course - Beginner to Advanced Bundle - Table Calculations Examples

The video tutorial covers the application of running totals and averages using a retail sales dataset. It explains how to create a running total and apply table calculations, followed by a demonstration of running averages. The tutorial also explores percent difference calculations using COVID-19 data, comparing monthly case counts between 2020 and 2021. The video concludes with a revisit of running total and average calculations, emphasizing their application in data visualization.

What is the primary purpose of creating a running total in a line chart?

• To display individual monthly sales

• To visualize the trend of accumulated sales over time

• To compare sales data from different years

• To highlight the highest sales month

Which method is used to calculate a running total in the example provided?

• Maximum

• Average

• Minimum

• Sum

What happens when you apply a running total calculation with the sum method?

• Each value is replaced by the lowest value

• Each value is added to the previous value

• Each value is replaced by the highest value

• Each value is averaged with the previous value

Which of the following is NOT a method for running total calculations?

• Maximum

• Median

• Average

• Sum

What is the benefit of using a dual-axis chart?

• It automatically calculates the average of the datasets

• It highlights the highest and lowest values in a dataset

• It simplifies the visualization by using a single axis

• It allows for the comparison of two different datasets on the same chart

How does synchronizing axes in a dual-axis chart help?

• It changes the color of the lines for better visibility

• It aligns the axes of both measures for accurate comparison

• It removes the labels from the chart

• It adds a secondary calculation to the chart

What dataset is used to demonstrate percent difference calculations?

• Retail sales data

• COVID-19 case count data

• Weather data

• Stock market data

In percent difference calculations, what does the 'previous' option do?

• Calculates the difference between the current and first value

• Calculates the difference between the first and last value

• Calculates the difference between the current and previous value

• Calculates the difference between the current and next value

Why is it important to set specific dimensions in percent difference calculations?

• To allow for the calculation of averages

• To ensure the calculation is applied to the entire dataset

• To highlight the highest values in the dataset

• To specify the direction of the calculation through the data

What does the 'At the Level' configuration allow you to do in specific dimension calculations?

• It removes the labels from the chart

• It automatically synchronizes the axes

• It lets you fine-tune the specific area where the calculation should be applied

• It allows you to change the color of the chart