Learn Tableau by Working on Exciting Dashboards - Include - LOD

This tutorial explains how to use the 'include' level of detail (LOD) expression in Tableau to compute aggregations by considering additional dimensions not present in the view. It demonstrates calculating average sales by region, creating calculated fields, and verifying results with cross tables and subtotals. The tutorial concludes with publishing the work to Tableau Public.

What is the primary purpose of Include Level of Detail expressions?

• To simplify the calculation process

• To compute aggregations considering both view and specified dimensions

• To compute aggregations considering only the dimensions in the view

• To exclude dimensions from the view

Which step is NOT involved in computing average sales for each region using Include LOD?

• Using a pie chart for visualization

• Dropping the region to the columns

• Including the category in the calculation

• Changing aggregation from sum to average

What is the first step in creating a calculated field for Include LOD?

• Start with square brackets

• Mention the keyword 'exclude'

• Start with curly braces

• Use a semicolon to separate dimensions

How do you verify the average sales value in the cross table?

• By excluding all dimensions

• By adding a pie chart

• By using a line graph

• By adding subtotals and changing to average

What additional dimension is included in the calculation when using Include LOD?

• Time

• Category

• Product

• Location