What are lod in tableau

Question

Accepted Answer

LOD stands for Level of Detail. It is a technique in Tableau that allows users to compute values at a different level than the view.

LOD expressions can be used to aggregate data at a higher level than the view, or to compute values at a lower level than the view.
There are three types of LOD expressions: FIXED, INCLUDE, and EXCLUDE.
FIXED LOD expressions compute values using a specified set of dimensions, regardless of the dimensions in the view.
INCLUDE LOD expressions compute values for a specified set of dimensions, and include those dimensions in the view.
EXCLUDE LOD expressions compute values for a specified set of dimensions, and exclude those dimensions from the view.

Accepted Answer

LOD stands for Level of Detail , It performs expression and Calculation at different level of Granularity

Fixed Lod : Aggregate the Data independently of Visualization at level of detail using specific dimension as fixed reference

Include Lod : Aggregate the Data while include a specific dimension regardless of presence in the visualization

Exclude Lod: Aggregate the Data while exclude a specific dimension

Top JPMorgan Chase & Co. Associate interview questions & answers