-
1. Re: Best Way to Handle Duplicate Records after Join
David Li Sep 20, 2016 8:46 AM (in response to Sean Norse)Hi Sean! One option (in Tableau 9+) is to take advantage of the implicit dimensionality in a LOD calculation to force a measure to use only the minimum value for each employee ID.
That is, you can use a couple LOD calc formulas, like this:
{ FIXED [ID] : MIN([Projects Completed]) }
{ FIXED [ID] : MIN([Revenue Generated]) }
If you put these measures in and sum them, they should sum up the minimum per ID, because Tableau knows that these LOD calcs have already processed at the level of ID.
To give you an easier example of what's happening, consider if you have a data source of 10 rows and you do a LOD calc summing up all the revenue.
{ SUM([Revenue Generated]) }
This value actually gets stored in each record in your data source, so it appears 10 times. Tableau is smart enough to know not to add these 10 values together, because that would give you a grand total 10 times too large!
-
2. Re: Best Way to Handle Duplicate Records after Join
Sean Norse Sep 27, 2016 6:35 AM (in response to David Li)Sorry for the delay in responding David. This was extremely helpful thank you.
-
3. Re: Best Way to Handle Duplicate Records after Join
David Li Sep 27, 2016 8:18 AM (in response to Sean Norse)You're welcome! If that worked for you, could you please mark it as correct so this doesn't show up as unanswered anymore? Thanks!