
1. Re: Sum DeDuped Rows
Ken Flerlage Jan 23, 2019 6:50 AM (in response to andrew.schon)You should be able to use a fixed LOD as you theorized.
{FIXED [Type],[Date]: MAX(1)}
The MAX(1) will just give us a 1 for each unique pair of Type & Date. We can't just put 1 because LODs require that the measure be aggregated.
See attached sample.

LOD.twbx 11.3 KB


2. Re: Sum DeDuped Rows
Ken Flerlage Jan 23, 2019 6:52 AM (in response to Ken Flerlage)Also, if you need some assistance with understanding fixed LODs, here are a couple of good resources:
FIXED Level of Detail Expressions  Tableau
https://interworks.com/blog/rcurtis/2016/03/24/tableaudeepdivelodfixedcalculation/

3. Re: Sum DeDuped Rows
andrew.schon Jan 23, 2019 6:59 AM (in response to Ken Flerlage)Thank you! This makes way more sense in practice now  appreciate the help!


5. Re: Sum DeDuped Rows
andrew.schon Jan 23, 2019 8:24 AM (in response to andrew.schon)One quick follow up, Ken:
I ran a quick table calc based on the fixed LOD: TOTAL(SUM([Interactions DeDuped])) because I want to show the total in the title, as well. but the number it's giving me isn't the sum of all the records on the page see bottom left sum vs top sum in title. Why the discrepancy and what's the best way to show the number on the bottom left instead?
thanks again

6. Re: Sum DeDuped Rows
Ken Flerlage Jan 23, 2019 9:18 AM (in response to andrew.schon)Any chance you can share the workbook?

7. Re: Sum DeDuped Rows
Ken Flerlage Jan 23, 2019 10:14 AM (in response to Ken Flerlage)1 of 1 people found this helpfulThe issue is that the LOD is only looking at unique combinations of Type and Date when it counts, but you've added Interaction Owner to your view, so the calculations for each bar then accounts for that field as well. So, your data must have some type/date combination in one Interaction Owner that is the exact same type/date as another. When you place that in your title, it's ignoring the interaction owner, so it's deduping those as well. Does that make sense?
So, if you want to account for the owner, you'll need to edit your LOD as follows:
{FIXED [Interaction Owners1], [Interaction Type1], [Date1] : MAX(1)}
Please also keep in mind the Tableau order of Operations as you may need to add your filters to context if you want them to apply before the LOD is calculated. Tableau's Order of Operations  Tableau

8. Re: Sum DeDuped Rows
andrew.schon Jan 23, 2019 10:18 AM (in response to Ken Flerlage)ahhh, this makes sense. Thanks  I obviously have more learning to do on how LOD functions.