Learn Tableau by Working on Exciting Dashboards - Comparative Profit Analysis - Exclude LOD Example

The video tutorial explains how to use the exclude LOD expression in Tableau to create a benchmark for profit comparison. It demonstrates creating a calculated field for 2016 profit and using the exclude statement to apply this benchmark across different years. The tutorial also covers calculating the percentage difference in profit from the benchmark year, 2016, and formatting the results in Tableau.

What is the purpose of using the exclude LOD expression in this tutorial?

• To calculate total sales

• To create a benchmark for profit comparison

• To filter out data from 2016

• To include only 2019 data

Why does the calculated field for 2016 profit only show data for 2016?

• Because the data is sorted by profit

• Because the if statement only matches the year 2016

• Because 2016 is the most recent year

• Because the data for other years is missing

What does the exclude statement achieve in the context of this tutorial?

• It excludes 2016 data from the analysis

• It applies the 2016 profit value across all rows

• It calculates the average profit for all years

• It filters out all data except for 2016

How is the percentage difference from the benchmark year calculated?

• By dividing 2017 profit by 2016 profit

• By adding 2016 profit to 2017 profit

• By multiplying 2016 profit by 2017 profit

• By subtracting 2016 profit from 2017 profit

What is the significance of using '1' in the percentage difference formula?

• It represents the total profit

• It is a placeholder for the initial value

• It cancels out the denominator

• It indicates a 100% increase

What format is used to display the percentage difference in the tutorial?

• Currency format

• Decimal format

• Percentage format

• Scientific format

What improvement is observed in the company's profit from 2016 to 2017?

• An increase of 50%

• No change in profit

• A decrease in profit

• An increase of 24.37%