- Tableau Tutorial
- Tableau - Home
- Tableau - Overview
- Tableau - Environment Setup
- Tableau - Get Started
- Tableau - Navigation
- Tableau - Design Flow
- Tableau - File Types
- Tableau - Data Types
- Tableau - Show Me
- Tableau - Data Terminology
- Tableau Data Sources
- Tableau - Data Sources
- Tableau - Custom Data View
- Tableau - Extracting Data
- Tableau - Fields Operations
- Tableau - Editing Metadata
- Tableau - Data Joining
- Tableau - Data Blending
- Tableau Worksheets
- Tableau - Add Worksheets
- Tableau - Rename Worksheet
- Tableau - Save & Delete Worksheet
- Tableau - Reorder Worksheet
- Tableau - Paged Workbook
- Tableau Calculations
- Tableau - Operators
- Tableau - Functions
- Tableau - Numeric Calculations
- Tableau - String Calculations
- Tableau - Date Calculations
- Tableau - Table Calculations
- Tableau - LOD Expressions
- Tableau Sort & Filters
- Tableau - Basic Sorting
- Tableau - Basic Filters
- Tableau - Quick Filters
- Tableau - Context Filters
- Tableau - Condition Filters
- Tableau - Top Filters
- Tableau - Filter Operations
- Tableau Charts
- Tableau - Bar Chart
- Tableau - Line Chart
- Tableau - Pie Chart
- Tableau - Crosstab
- Tableau - Scatter Plot
- Tableau - Bubble Chart
- Tableau - Bullet Graph
- Tableau - Box Plot
- Tableau - Tree Map
- Tableau - Bump Chart
- Tableau - Gantt Chart
- Tableau - Histogram
- Tableau - Motion Charts
- Tableau - Waterfall Charts
- Tableau Advanced
- Tableau - Dashboard
- Tableau - Formatting
- Tableau - Forecasting
- Tableau - Trend Lines
- Tableau Useful Resources
- Tableau - Question Answers
- Tableau - Quick Guide
- Tableau - Useful Resources
- Tableau - Discussion
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
Tableau - LOD Expressions
Level of Detail (LOD) expressions are used to run complex queries involving many dimensions at the data source level instead of bringing all the data to Tableau interface. A simple example is adding dimension to an already calculated aggregate value.
Types of LOD
There are three main types of LOD expressions.
FIXED LOD This expression computes values using the specified dimensions without reference to any other dimensions in the view.
INCLUDE LOD This level of detail expressions compute values using the specified dimensions in addition to whatever dimensions are in the view.
EXCLUDE LOD These levels of detail expressions subtract dimensions from the view level of detail.
FIXED Level of Detail Expressions
Find the amount of Sales for each state in each region. Here, first create the formula field named Regional Sales using the formula as shown in the following screenshot.
Next, drag the Region and State field to the Rows shelf and the calculated field to the Text shelf under the Marks card. Also drag the Region field to the Color shelf. This produces the following view, which shows a fixed value for different states. That is because we have fixed the dimension as region for the calculation of Sales value.
INCLUDE Level of Detail Expressions
INCLUDE level of detail expressions compute values using the specified dimensions in addition to whatever dimensions are in the view. Calculate the sum of sales per state for each sub-category of products.
For this, drag the Sub-Category field to the Rows shelf. Then, write the expression in the Columns shelf as shown in the following screenshot. It produces the following view which includes both the dimensions in the calculations.
EXCLUDE Level of Detail Expressions
EXCLUDE level of detail expressions specify dimensions to exclude from the view level of detail. Exclude Region from Sales figure calculated for every month. Create the formula as shown in the following screenshot.
On dragging the relevant fields to the respective shelves, you will get the final view for the EXCLUDE LOD as shown in the following screenshot.
