In Tableau, the INCLUDE level of detail (LOD) expression allows you to specify additional dimensions to include in your calculations, in addition to the dimensions at the level of granularity at which you are aggregating your data. This can be useful when you want to perform calculations that involve additional dimensions, but do not want to change the level of granularity of your data.

Let me give you an example of how you might use an INCLUDE LOD expression in Tableau.

Let’s say we want to find out the average sales by sub-category in each region.

 

Step one

Drag Region and Sub-Category to the Rows shelf, drag sales to the View and change the measure to average in the Marks.

 

Step two

Create a calculation field.

{INCLUDE [Sub-Category]: SUM([Sales])}

Drag the Include Sub-Category to the view and change the measure to average in the Marks

 

As we can that the Include LOD function provides a view of the data by showing the sub-category level of granularity, and the Avg.Sales shows the row-level detail.

 

Feel free to reach out to me if you have any questions.

 

 

The Data School
Author: The Data School