How to remove duplicate data with LOD calculations in Tableau

In this silent video, you’ll learn how to use LOD calculations to delete duplicated data when joining two or more table.

Read the full article here: Removing Duplicate Data with LOD Calculations - https://kb.tableau.com/articles/howto...

- - - - - - - - - - - - - -

Use a FIXED expression to remove the duplicate data.

It is necessary to know which dimension in the data source is unique for each row value, or the combination of dimensions. For example, if the measures on Table A have a unique row identifier based on Date/Time, use that dimension to remove duplicate values.

Once the necessary dimension or dimensions are found, use an LOD calculation to remove the duplicate values.

Related solutions:
Create Level of Detail Expressions in Tableau - https://onlinehelp.tableau.com/curren...

- - - - - - - - - - - - - -

Subscribe to the Tableau YouTube channel here: http://www.youtube.com/subscription_c...

Free Trial of Tableau: https://www.tableau.com/products/trial

• #science_technology
• #tableau
• #tutorial
• #how_to
• #data_visualization
• #gss
• #duplicate_data
• #remove
• #lod