Tech Togs

LOD Function Level Of Detail expressions (LOD) allows us to calculate values at data source level and visualization level in tableau application tool. This gives us more control over the level of granularity we want to calculate. Types of LOD FIXED INCLUDE EXCLUDE Fixed : It compute a value using the specified dimensions, without reference to the dimensions in the view. ex: {FIXED [Region] : SUM([Sales])} Include: Calculating values using specified dimensions other than whatever dimensions are in the view ex: { INCLUDE [Customer Name] : SUM([Sales]) } Exclude: It declare dimensions to omit from the view level of detail. ex: {EXCLUDE [Order Date (Month / Year)] : AVG({FIXED [Order Date (Month / Year)] : SUM([Sales])})}