Level of Detail (LOD) Expressions

Level of Detail (LOD) Expressions (also called LOD Calculations)

White paper by Alan Eldridge & Tara Walker: https://www.tableau.com/learn/whitepapers/understanding-lod-expressions

Top 15 LOD Expressions by Bethany Lyons: https://www.tableau.com/LOD-expressions

Tableau online help for LOD expressions: http://onlinehelp.tableau.com/current/pro/online/windows/en-us/help.html#calculations_calculatedfields_lod.html

Video intro for LOD expressions by Craig Bloodworth @ the Information Lab:
https://www.youtube.com/watch?v=BnSF6i4MW0E&feature=youtu.be

Bora Beran’s blog introducing LOD expressions:
https://boraberan.wordpress.com/2015/01/30/whats-new-in-tableau-9-0-part-2-level-of-detail-expressions/

Mark Jackson on Using LOD to return a lower level dimension value (2 posts, plus Jonathan’s remix)
http://ugamarkj.blogspot.com/2015/05/using-tableau-lod-to-find-dimension-at.html
http://ugamarkj.blogspot.com/2015/05/updated-using-tableau-lod-to-find.html
http://drawingwithnumbers.artisart.org/lod-expression-remix-finding-a-dimension-at-a-lower-level/

Alan Eldridge’s blog (this material is refined in the white paper mentioned above):
Understanding Level of Detail Expressions – Part 1
Understanding Level of Detail Expressions – Part 2
Understanding Level of Detail Expressions – Part 3

LOD Rework 1 – Relative Date Filter

Mark Jackson on using LOD expressions for a nested filtering situation:
http://ugamarkj.blogspot.com/2015/02/advanced-grouping-with-tableau-level-of.html

LOD expressions for semi-additive measures:
Guest Post: Tableau LOD calcs for semi-additive measures

Comparison of LOD expressions to techniques in other tools (Excel, SQL, Altered, etc.)
https://dabblingwithdata.wordpress.com/2015/03/05/why-version-9-will-fix-tableau-for-me-and-workarounds-in-the-mean-time/

Using FIXED vs INCLUDE/EXCLUDE:

 

[loop category=”wikicontent” tag=”lod, lod calculations, lod expressions”]
[field title] – Added [field date]
[content]
[/loop]

Related posts:

      [loop tag=”lod, lod calculations, lod expressions” exclude=”this” relation=”and” compare=”not” taxonomy=”category” value=”wikicontent”]
  • [field title-link][field thumbnail-link]

[/loop]

Please add your thoughts and perspectives