Tableau LOD – Level of Detail Expression in Tableau
1. Tableau LOD – Objective
In our last article, we were discussing Tableau Operators. In this Tableau tutorial, we are going to learn about Tableau LOD – Level of Detail Expression, types of Level of Detail in tableau with appropriate explanations and examples.
So, let us start with Tableau LOD – Level of Detail Expression.
2. Level of Detail Expression in Tableau
Tableau Level of Detail (Tableau LOD) articulations is utilized to run complex questions including numerous measurements at the information source level as opposed to conveying every one of the information to Tableau interface. A straightforward illustration is adding measurement to an effectively ascertained total esteem.
Let’s discuss Tableau Navigation in Tableau Workbook in detail
3. Kinds of Tableau LOD
There are three fundamental kinds of Tableau LOD articulations.
a. Fixed LOD
This articulation figure esteems utilizing the predetermined measurements without reference to some other measurements in the view.
b. Include LOD
This level of detail articulations register esteems utilizing the predetermined measurements notwithstanding whatever measurements are in the view.
c. Exclude LOD
4. Fixed Level of Detail Expressions
Fixed Tableau LOD, discover the measure of sales for each state in every area. Here, first make the equation field named regional sales utilizing the recipe has appeared in the accompanying screen capture.
Next, drag the region and state field to the rows rack and the ascertained field to the text retire under the marks card. Likewise, drag the region field to the color rack. This delivers the accompanying perspective, which demonstrates a settled an incentive for various states. That is on the grounds that we have settled the measurement as an area for the figuring of Sales esteem.
Let’s revise Tableau Data Extract in detail
5. Include Level of Detail Expressions
Include Tableau Lod, incorporate level of detail articulations register esteems utilizing the predefined measurements notwithstanding whatever measurements are in the view. Compute the aggregate of offers per state for each sub-class of items.
Read about Adding Worksheets And Renaming Worksheet In Tableau
For this, drag the Sub-Category field to the Rows rack. At that point, compose the articulation in the Columns retire as appeared in the accompanying screen capture. It delivers the accompanying perspective which incorporates both the measurements in the computations.
6. Exclude Level of Detail Expressions
Exclude Tableau LOD, bar level of detail articulations indicate measurements to avoid from the view level of detail. Reject Region from Sales figure ascertained for consistently. Make the equation as appeared in the accompanying screen capture.
Read about Tableau Paged Workbook & Steps to Create it
On dragging the important fields to the separate racks, you will get the last view for the EXCLUDE LOD as appeared in the accompanying screen capture.
So, this was all about Tableau LOD. Hope you like our explanation.
In this tutorial, we learned about Tableau LOD – Level of Detail Expression, different types of Tableau LOD: Exclude Level of Detail Expressions, Include Level of Detail Expressions, Fixed Level of Detail Expressions, Fixed LOD, Include LOD, and Exclude LOD with examples. Furthermore, if you have any query, feel free to ask in a comment section.
See Also- Tableau Line Chart – Create Line Chart in Tableau