Mastering Tableau 2018.1, Second Edition 7.2: Quick Table Calculations – Running Total and Difference

The video tutorial covers the use of running total and difference functions in Tableau. It begins with an introduction to these functions, followed by a demonstration of the running total function using sales data. The tutorial then applies the running total function to analyze monthly expenses. It also explains how to manually create a running total using calculated fields. Finally, the video introduces the difference function, explaining its use and demonstrating it with examples.

What is the primary purpose of the running total function in Tableau?

• To subtract each value from the previous one

• To add each value to the previous one to get a cumulative total

• To calculate the average of all values

• To find the maximum value in a dataset

In the demonstration, what data is used to showcase the running total calculation?

• Regions and expenses

• Months and revenues

• Subcategories and sales

• Product categories and profits

In the context of the video, what is the significance of using a bar chart for visualizing data?

• It helps in identifying the maximum value

• It makes it easier to compare cumulative totals

• It highlights the minimum value

• It is the only chart type available in Tableau

How can you manually create a running total in Tableau?

• By creating a new worksheet

• By using a filter to exclude certain values

• By using a calculated field with a running sum function

• By exporting data to Excel

What does the difference function in Tableau do?

• Subtracts values from one row to the next

• Multiplies values across columns

• Divides values by a constant

• Adds values from different rows

Which functions are used by the difference function in Tableau to handle null values?

• SUM and AVG

• ZN and LOOKUP

• MIN and MAX

• COUNT and DISTINCT

What is the role of the ZN function in the difference calculation?

• To convert null values to zeros

• To filter out negative values

• To find the average of values

• To calculate the sum of values