LOD (level of Details) expression is used to run complex queries involving many dimensions at the data sources instead of bringing all the data to the Tableau interface.

Types of LOD expression

There are three types of LOD expressions in the Tableau:
• FIXED LOD: This LOD expression computes the values using the specified dimensions without reference to any other dimensions in the view.
• INCLUDE LOD: This LOD expression computes the values using the specified dimensions with any other dimensions in the view.
• EXCLUDE LOD: These LOD expressions subtract dimensions from the view level of detail.

FIXED Level of Detail Expressions

For example, if you want to calculate the number of Sales for each state in each region. Then,
First, create the formula field named regional_sales using the formula as shown in the below screenshot.

Page 1 Image 1 32 — detail.
FIXED Level of Detail Expressions

• Then, drag the Region and State field to the Rows shelf and the calculated field (regional_sales) to the Text shelf under the Marks card.
• Also, drag the Region field to the Color shelf.
• This creates the below view, that shows a fixed value for different states because we fixed the dimension as a region for the calculation of Sales value.

INCLUDE Level of Detail Expressions

INCLUDE level of detail expressions compute values using the specified dimensions whatever dimensions are in the view.
For example, if you want to calculate the sum of sales per state for each sub-category of products. Then,
• Drag the Sub-Category field to the Rows shelf.
• And, write the expression ” {INCLUDE [State] : SUM(Sales)} ” in the Columns shelf.
• It creates the view that includes both the dimensions in the calculations as shown in the below screenshot.

Page 3 Image 3 10 — INCLUDE Level of Detail Expressions

EXCLUDE Level of Detail Expressions

EXCLUDE level of detail expressions describe the dimensions to exclude from the view level of detail.
For example, Exclude Region from the Sales figure calculated for every month. First,
• Create the formula ” {EXCLUDE [Region] : SUM([Sales])} ” as shown in the below screenshot.

Page 4 Image 4 7 — EXCLUDE Level of Detail Expressions

• On dragging the relevant fields to the respective shelves, you get the final view for the EXCLUDE level of detail expressions as shown in the below screenshot.

So, this brings us to the end of blog. This Tecklearn ‘LOD Expressions in Tableau’ blog helps you with commonly asked questions if you are looking out for a job in Tableau Desktop. If you wish to learn Tableau Desktop and build a career in Business Intelligence domain, then check out our interactive, Tableau Desktop Training, that comes with 24*7 support to guide you throughout your learning period. Please find the link for course details:

Tableau Desktop

Tableau Desktop Training

About the Course

Tecklearn’s Tableau Desktop Training teach you how to transform raw data into interactive and shareable dashboards using Tableau. Our Tableau Course covers the necessary analytical skills to Advanced data visualizations by incorporating real-world use-case scenarios, labs, and exercises. Some of the topics included are Data Blending, Data Mapping, Graphs, creation of charts, and LOD expression by using different versions of Tableau, such as Tableau Desktop, Tableau Reader, and Tableau Public.

Why Should you take Tableau Desktop Training?

• The average salary of a Tableau Professional ranges between $108,697 to $158,000 per annum -Indeed.com.
• Tableau has been positioned as a Leader in the Gartner Magic Quadrant for Analytics and Business Intelligence Platforms – Gartner.com.
• Fidelity Investments, Capgemini, EY, Deloitte, EY, JP Morgan, Verizon, Facebook, Dell, General Motors, KPMG, Bank of America and 40,000 other MNCs worldwide across industries use Tableau.

What you will Learn in this Course?

Understanding Tableau

• Why Tableau
• Tableau Product Platforms
• Tableau Architecture
• Tableau Interface

Data Connection with Tableau Desktop

• Features of Tableau Desktop
• Connect to data from File and Database
• Types of Connections
• Data Blending
• Joins and Unions
• Tableau Desktop User Interface
• Basic project: Create a workbook and publish it on Tableau Online

Basic Visual Analytics

• Visual Analytics
• Basic Charts: Bar Chart, Line Chart, and Pie Chart
• Hierarchies
• Data Granularity
• Highlighting
• Sorting
• Filtering
• Grouping
• Sets

Advanced Visual Analytics

• Parameters
• Tool tips
• Trend lines
• Reference lines
• Forecasting
• Clustering

Calculations in Tableau

• Calculated Fields
• Numeric, String, Data, Logical, Addressing and Partitioning
• Table Calculations

Level of Detail (LOD’s) Calculations

Advanced Charts in Tableau

• Box and Whisker’s Plot
• Bullet Chart
• Bar in Bar Chart
• Gantt Chart
• Waterfall Chart
• Pareto Chart
• Control Chart
• Funnel Chart
• Bump Chart

Parameters

• What If Scenarios
• Parameter in CF (KPI control)
• Parameter in Filter (Top N)
• Parameter in reference line

Dashboards and Stories

• Introduction to Dashboards
• The Dashboard Interface
• Dashboard Objects
• Building a Dashboard
• Dashboard Layouts and Formatting
• Interactive Dashboards with actions
• Designing Dashboards for devices
• Story Points

Data Security in Tableau

Optimizations tips and tricks

Interacting with Tableau Server

Working with Tableau JavaScript API

Got a question for us? Please mention it in the comments section and we will get back to you.

520