LOD Functions with Cricket Data

LOD expressions, also referred to as level of detail expressions, let you calculate values at both the data source level and the visualisation level. You have even more choice over the degree of granularity you want to compute, though, thanks to LOD expressions. They can be carried out at a more detailed level (INCLUDE), a less detailed level (EXCLUDE), or a level that is completely autonomous (FIXED).

The several kinds of LOD expressions that Tableau supports, when to use them, and formatting instructions are all covered in this article. It also offers a cricket example, which should make understanding this the most straightforward for you.

Types of LOD expressions .There are three types of LOD expressions you can create in Tableau:(official definitions)

FIXED level of detail expressions compute a value using the specified dimensions, without reference to the dimensions in the view.

INCLUDE level of detail expressions compute values using the specified dimensions in addition to whatever dimensions are in the view.

EXCLUDE level of detail expressions declare dimensions to omit from the view level of detail. EXCLUDE level of detail expressions are useful for ‘percent of total’ or ‘difference from overall average’ scenarios. They are comparable to such features as Totals and Reference Line

For you to easily comprehend the three types of LOD, we offer a particular cricket dataset. Together, we will learn all three LOD functions using cricket data; please watch the above video to view the results in more detail. Happy learning!

Ritesh Bisht - Tableau Specialist

Ritesh Bisht

Founder of Dance & Sing with Data

“Ritesh is 2 times Tableau Ambassador & 1 time Power BI Super User from India and has been featured in the Top 15 Tableau & Power BI World Communities”

Found me on: